ASA Database Administration Guide
Connecting to a Database
Troubleshooting connections
The client application makes a call to one of the Adaptive Server Anywhere interface libraries. In general, the location of this DLL or shared library is transparent to the user. Here we describe how to locate the library in case of problems.
For ODBC, the interface library is also called an ODBC driver. An ODBC client application calls the ODBC driver manager, and the driver manager locates the Adaptive Server Anywhere driver.
The ODBC driver manager looks in the supplied data source in the odbc.ini file or registry to locate the driver. When you create a data source using the ODBC Administrator, Adaptive Server Anywhere fills in the current location for your ODBC driver.
Embedded SQL applications call the interface library by name. The name of the Adaptive Server Anywhere Embedded SQL interface library is as follows:
Windows NT/2000/XP and Windows 95/98/Me dblib9.dll
UNIX dblib9 with an operating-system-specific extension
NetWare dblib9.nlm
The locations that are searched depend on the operating system:
PC operating systems On PC operating systems such as Windows, files are looked for in the current directory, in the system path, and in the Windows and Windows\system directories.
UNIX operating systems On UNIX, files are looked for in the system path and the user library path.
NetWare On NetWare, files are looked for in the search path, and in the sys:system directory.
Once the client application locates the interface library, it passes a connection string to it. The interface library uses the connection string to assemble a list of connection parameters, which it uses to establish a connection to a server.