If you are having problems establishing a connection to the correct server across a network, try deleting the sasrv.ini file. This file contains server information, including server name, protocol, and address. It is possible that the server information in this file is overriding information you specified in the connection string. Deleting this file causes SQL Anywhere to create a new sasrv.ini file containing the information you specify in the connection string. The default location of sasrv.ini is %ALLUSERSPROFILE%\Application Data\SQL Anywhere 11 on Windows and ~/.sqlanywhere11 on Unix.
If you continue to experience problems establishing a connection, you should also delete any copy of sasrv.ini located in any of the following places:
The bin32 or bin64 subdirectory of your SQL Anywhere installation directory (listed in the HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\SQL Anywhere\11.0\Location registry key)
Windows directory
Windows system directory
Anywhere else in your path
For more information about the sasrv.ini file, see Server name caching for faster connections.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |