ASA Database Administration Guide
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 provider name (ASAProv) is used to locate the ASAOLEDB DLL based on entries in the registry. The entries are created when the ASAProv provider is installed or if it is reregistered.
The Java package jodbc.jar must be in the classpath when you run your application. The native DLLs or shared objects must be in the system path.
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.
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.