Specifications

Making the data source available
600 InfoMaker
Installing ODBC and system files
If your application uses ODBC drivers, each user’s computer needs three types
of files:
• PowerBuilder ODBC interface and driver syntax files Install
PBODB115.DLL in the application directory or a directory on the system
path. The PBODB115.INI file must be in a directory defined by the
HKEY_CURRENT_USER\Software\Sybase\InfoMaker\11.5\InitPath
registry setting or, in the absence of that key, in the same directory as the
DLL file. In most cases, the target deployment machine will not have the
registry setting and, therefore, the INI file should be in the same directory
as the DLL file.
For information about adding sections or functions to the PBODB115.INI
file, see Connecting to Your Database.
• Microsoft ODBC driver and DLLs The Microsoft ODBC Driver
Manager (ODBC32.DLL) and supporting files are usually already
installed in the user’s Windows system directory.
• ODBC database drivers and supporting files Sybase provides ODBC
database drivers for SQL Anywhere.
Configuring an ODBC driver
To use an ODBC data source in your application, the ODBC configuration
must include:
• An entry for the data source in ODBC.INI with instructions on how to start
the database
• An entry for the DBMS driver in ODBCINST.INI
ODBC.INI
To allow the user to connect to a particular data source, your installation
program must provide a definition for that data source in the ODBC.INI key in
the registry on the computer that accesses the data source, in
HKEY_CURRENT_USER for a user DSN or in HKEY_LOCAL_MACHINE for
a system DSN. The data source definition specifies the name and location of
the database driver as well as the command required to start the database
engine. The data source in the ODBC Data Sources key must also be listed in
ODBC.INI.
The following shows typical registry entries for a data source called
MyApp DB
that uses SQL Anywhere. Registry keys are enclosed in square brackets and are
followed by string values for that key in the format
"Name"="Value":