What's New in SQL Anywhere Studio
Upgrading Version 5 Applications
Version 5 client applications that connect to a database server do so via the SQL Anywhere Client, an executable named dbclient.exe. The client executable command line contains information needed to locate a server, including the following:
Default server name The server name on the client command line is the default server name. When a client executable is running, the application does not need to supply a server name in order to connect to the default server.
Network communications parameters A listing of network protocols to use together with a set of communications parameters specifies where the client executable is to look as it attempts to locate a server.
Client/Server communication tuning A set of parameters allows the packet size, buffer size, and so on to be tuned for optimum performance.
In Version 9, this information is held in an ODBC data source along with other connection information. As there is no longer a client executable, there is no longer a client command line. In Version 9, embedded SQL applications can use ODBC data sources as a source of connection parameters.
Only one Version 5 client executable can be run at a time, and it may be used by more than one application and handle connections to more than one server. The command information is therefore global to the machine.
How to capture client command information