Using the correct sasrv.ini file

If you are having problems establishing a connection to the correct server across a network, try deleting the sasrv.ini file. This file contains database server information, including the database server name, protocol, and address. The server information in this file could be 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.

Operating system Default location of sasrv.ini
Windows %ALLUSERSPROFILE%\Application Data\SQL Anywhere 12
Windows Mobile The same directory as the executable that is running
Unix $HOME/.sqlanywhere12

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\12.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.