Locating the interface library

Generally, the location of this DLL or shared library is transparent to the user.

ODBC driver location

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 SQL Anywhere driver.

The ODBC driver manager searches the supplied data source to locate the driver. When you create a data source using the ODBC Administrator or dbdsn utility, SQL Anywhere fills in the current location for your ODBC driver. The data source information is stored in the Windows registry, or in the Unix system information file (named .odbc.ini by default).

Embedded SQL interface library location

Embedded SQL applications call the interface library by name. The name of the SQL Anywhere embedded SQL interface library is:

  • Windows   dblib11.dll

  • Unix   libdblib11 with an operating-system-specific extension

OLE DB driver location

The provider name (SAOLEDB) is used to locate the SQL Anywhere OLE DB provider DLL (dboledb11.dll) based on entries in the registry. The entries are created when the SAOLEDB provider is installed or if it is re-registered.

ADO.NET

ADO.NET programs add a reference to the SQL Anywhere ADO.NET provider, which is named iAnywhere.Data.SQLAnywhere.dll. The .NET Data Provider DLL is added to the .NET Global Assembly Cache (GAC) when it is installed.

iAnywhere JDBC driver location

When you run your application, the Java package jodbc.jar must be in the classpath. The system must be able to locate the native DLLs or shared objects.

  • PC operating systems   On PC operating systems such as Windows, the current directory, the system path, and in the Windows and Windows\system32 directories are searched.

  • Unix operating systems   On Unix, the system path and the user library path are searched.

When the library is located

A connection string is sent to the interface library when it is located by the client application. The string is used by the interface library to assemble a list of connection parameters, and establish a server connection.