Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Running the database server » Troubleshooting server startup


Make sure you are using the right 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 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.