This section lists files that are required for all ODBC database connections from PowerBuilder or InfoMaker applications, as well as files required for a specific database interface or DBMS.
The following PowerBuilder ODBC interface files are required if your application uses ODBC:
Name |
Description |
|---|---|
PBODB105.DLL |
PowerBuilder ODBC interface |
PBODB105.INI |
PowerBuilder ODBC initialization file |
Installed path \Program Files\Sybase\Shared\PowerBuilder
Deployment path Same directory as the application, in a directory on the system path, or in the App Path registry key.
Registry entries See “App Path registry key”.
Notes The INI and DLL files must be in the same directory. If you have modified the PBODB105 initialization file, make sure you deploy the modified version.
Table 41-7 lists the Microsoft ODBC files that are required if your application uses ODBC.
Name |
Description |
|---|---|
DS16GT.DLL DS32GT.DLL ODBC32.DLL ODBC32GT.DLL ODBCAD32.EXE ODBCCP32.CPL ODBCCP32.DLL ODBCCR32.DLL ODBCINST.CNT ODBCINST.HLP ODBCINT.DLL ODBCTRAC.DLL |
Microsoft ODBC driver manager, DLLs, and Help files |
Installed path Windows system directory.
Deployment path Windows system directory.
Notes The Microsoft ODBC Driver Manager (ODBC32.DLL) and supporting files are usually already installed in the user’s Windows system directory. You can use the redistributable MDAC_TYP.EXE setup file in the Support directory on the CD to update users’ systems if necessary.
The PB DataDirect ODBC files in Table 41-8 are required if you use the database interface specified. For each database interface, the table shows required registry entries. In the string values, replace %SHARED% with the path to the directory where the drivers are installed.
Optional Help files
Help files need only be deployed if you expect users to perform
database administration tasks. The help files are in HTML format
and are installed in the Help subdirectory
of the DataDirect directory. The names of the
Help files for each driver begin with the letter R and include the
name of the database interface. For example, the files for Adaptive
Server are named Rase.html, Rase2.html,
and so forth.
Name |
Driver and registry entry: |
|---|---|
IVPB.LIC PBBAS21*.DLL PBUTL21*.DLL PBTRN21.dll |
All PB DataDirect OEM 5.1 drivers. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Translators] "OEM to ANSI"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\OEM to ANSI] "Translator"="%SHARED%\\DataDirectODBC\\PBtrn21.dll" "Setup"="%SHARED%\\DataDirectODBC\\PBtrn21.dll" |
PBBTR21.DLL PBBTR21R.DLL PBBTR21S.DLL PBFLT21.DLL PBFLT21R.DLL |
PB DataDirect OEM 5.1 Btrieve. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 Btrieve (*.dta)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 Btrieve (*.dta)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBBTR21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBBTR21S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="1" "FileExtns"="*.dta" "SQLLevel"="0" "CPTimeout"="60" |
*.UCT PBDB221.DLL PBDB221R.DLL PBDB221S.DLL APPC21IV.DLL BIND21IV.DLL CLRT21IV.DLL COSI21IV.DLL DRDA21IV.DLL LIBUNIC.DLL MEMR21IV.DLL PROT21IV.DLL SOCK21IV.DLL XCPG21IV.DLL XDB2DB2.ERR XDB2DRDA.ERR XDBMF.ERR XDBNET.ERR XDBRES.ERR |
PB DataDirect OEM 5.1 DB2 Wire Protocol. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 DB2 Wire Protocol"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 DB2 Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBDB221.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBDB221S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="03.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
PBDBF21.DLL PBDBF21R.DLL PBFLT21.DLL PBFLT21R.DLL |
PB DataDirect OEM 5.1 dBASE. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 dBASEFile (*.dbf)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 dBASEFile (*.dbf)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBDBF21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBDBF21.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="1" "FileExtns"="*.dbf" "SQLLevel"="0" "CPTimeout"="60" |
PBXLWB21.DLL PBXLWB21R.DLL PBFLT21.DLL PBFLT21R.DLL |
PB DataDirect OEM 5.1 Excel Workbook. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 ExcelWorkbook (*.xls)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 ExcelWorkbook (*.xls)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBXLWB21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBXLWB21.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="2" "FileExtns"="*.xls" "SQLLevel"="0" "CPTimeout"="60" |
PBINF21.DLL PBINF21R.DLL PBINF21S.DLL PBINFDTC21.DLL |
PB DataDirect OEM 5.1 Informix. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 INFORMIX"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 INFORMIX] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBINF21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBINF21S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
PBIFCL21.DLL PBIFCL21R.DLL PBIFCL21S.DLL |
PB DataDirect OEM 5.1 Informix Wire Protocol. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 INFORMIX Wire Protocol"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 INFORMIX Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBIFCL21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBIFCL21S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
PBOR821.DLL PBOR821R.DLL PBOR821S.DLL PBOR8DTC21.DLL |
PB DataDirect OEM 5.1 Oracle. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 Oracle"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 Oracle] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBOR821.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBOR821S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
PBORA21.DLL PBORA21R.DLL PBORA21S.DLL |
PB DataDirect OEM 5.1 Oracle Wire Protocol. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 Oracle Wire Protocol"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 Oracle Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBORA21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBORA21S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
PBIDP21.DLL PBIDP21R.DLL PBIDP21S.DLL PBFLT21.DLL PBFLT21R.DLL |
PB DataDirect OEM 5.1 Paradox. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 ParadoxFile (*.db)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 ParadoxFile (*.db)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBIDP21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBIDP21S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="1" "FileExtns"="*.db" "SQLLevel"="0" "CPTimeout"="60" |
PBPRO921.DLL PBPRO921R.DLL PBPRO921S.DLL |
PB DataDirect OEM 5.1 Progress 9. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 PROGRESS 9"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 PROGRESS 9] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBPRO921.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBPRO921S.DLL" "APILevel"="1" "ConnectFunctions"="YYN" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="0" "CPTimeout"="60" |
PBGUP21.DLL PBGUP21R.DLL PBGUP21S.DLL |
PB DataDirect OEM 5.1 SQLBase. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 SQLBase"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 SQLBase] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBGUP21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBGUP21S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
PBSS621.DLL PBSS621R.DLL PBSS621S.DLL |
PB DataDirect OEM 5.1 SQL Server 6.5. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 SQL Server 6.5"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 SQL Server 6.5] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBSS621.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBSS621S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
PBMSSS21.DLL PBMSSS21R.DLL PBMSSS21S.DLL DBNETLIB.DLL SQLSRV32.DLL SQLSRV32.RLL SQLUNIRL.DLL |
PB DataDirect OEM 5.1 SQL Server Wire Protocol. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 SQL Server Wire Protocol"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 SQL Server Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBMSSS21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBMSSS21S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
PBASE21.DLL PBASE21R.DLL PBASE21S.DLL PBASE21.HLP PBASE21.CNT |
PB DataDirect OEM 5.1 Sybase Adaptive Server Enterprise Wire Protocol. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 Sybase ASE Wire Protocol" = "Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 Sybase ASE Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBASE21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBASE21S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="0" "UsageCount"="1" "CPTimeout"="60" |
PBTXT21.DLL PBTXT21R.DLL PBFLT21.DLL PBFLT21R.DLL |
PB DataDirect OEM 5.1 Text File. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 5.1 TextFile (*.*)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 5.1 TextFile (*.*)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBTXT21.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBTXT21.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="1" "FileExtns"="*.*" "SQLLevel"="0" "CPTimeout"="60" |
Installed path \Program Files\Sybase\Shared\DataDirect
Deployment path Same directory as the application, in a directory on the system path, or in the App Path registry key.
Registry entries See table, and also “App Path registry key” and “Configuring ODBC data sources and drivers” on page §.
If your PowerBuilder application uses an Adaptive Server Anywhere database, you need to deploy the Adaptive Server Anywhere DBMS as well as Adaptive Server Anywhere’s ODBC database drivers. If your application uses a standalone database, you can deploy the Adaptive Server Anywhere Desktop Runtime System to users’ computers without incurring additional license fees. The runtime system allows the user to retrieve and modify data in the database, but does not allow modifications to the database schema. It does not support transaction logs, stored procedures, or triggers.
Restrictions
PowerBuilder includes Adaptive Server Anywhere for use during
the development process. However, this product cannot be deployed
royalty-free to your users.
If your application requires the data definition language (DDL), a transaction log, stored procedures, or triggers, see your Sybase sales representative.
For more information about deploying Adaptive Server Anywhere databases and applications, see the Adaptive Server Anywhere User’s Guide.
A full installation for the Adaptive Server Anywhere driver, runtime engine, and supporting files is available in the Support directory on the CD. Table 41-9 lists some of the files that are installed when you select Runtime Server in the install program. You can also choose to install Help files, SQL Anywhere 5.0/6.0 compatibility DLLs, and InstallShield templates.
Name |
Description |
|---|---|
DBODBC9.DLL |
ASA ODBC driver |
DBBACKUP.EXE |
ASA backup utility |
DBCON9.DLL |
Connection dialog box, required if you do not provide your own dialog box and your end users are to create their own data sources, if they need to enter user IDs and passwords when connecting to the database, or if they need to display the Connection dialog box for any other purpose |
DBISQLC.EXE |
Interactive SQL utility |
DBLGEN9.DLL |
Language-specific string library (EN indicates the English version) |
DBLIB9.DLL |
Interface library |
DBODTR9.DLL |
ODBC translator, required if your application relies on OEM to ANSI character set conversion |
DBTOOL9.DLL |
ASA database tools |
DBUNLOAD.EXE |
ASA unload utility |
DBVALID.EXE |
ASA validation utility |
RTENG9.EXE |
Restricted runtime engine |
DBCTRS9.DLL |
Performance utility |
DBSERV9.DLL |
Server utility |
Installed path \Program Files\Sybase\SQL Anywhere 9\win32
Deployment path Same directory as the application, in a directory on the system path, or in the App Path registry key.
Registry entries See “App Path registry key” and “Configuring ODBC data sources and drivers”.
Notes Supporting files should be installed in the same directory as DBODB9.DLL. If you are not using the English string library, make sure you deploy the appropriate version of the language-specific string library.
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 Adaptive Server Anywhere. Registry keys
are enclosed in square brackets and are followed by string values
for that key in the format "Name"="Value":
[HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\MyApp DB] "Driver"="C:\Program Files\Sybase\SQL Anywhere 9\ win32\dbodbc9.dll" "Start"="c:\program files\sybase\SQL Anywhere 9\win32\ rteng9.exe -c9m" "UID"="dba" "PWD"="sql" "Description"="Database for my application" "DatabaseFile"="C:\Program Files\myapps\myapp.db" "AutoStop"="Yes" [HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\ ODBC Data Sources] "MyApp DB"="Adaptive Server Anywhere 9.0"
ODBCINST.INI Your installation program needs to make two types of entry in the ODBCINST.INI key in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC for each driver that your deployed application uses:
Add a string value with the name of the driver and the data value "Installed" to the ODBC DRIVERS key in ODBCINST.INI
Add a new key for each driver to the ODBCINST.INI key with string values for Driver and Setup
Some drivers require additional string values in ODBCINST.INI.
If the ODBC database driver files are not located in a directory on the system path, you also need to add their location to the App Paths key for the executable file.
If you are using ODBC drivers obtained from a vendor, you can use the driver’s setup program to install the driver and create registry entries.
The following shows typical registry entries for Adaptive
Server Anywhere. A registry key is enclosed in square brackets and
is followed by string values for the key in the format "Name"="Value":
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\ CurrentVersion\App Paths\myapp.exe] "Default"="C:\Program Files\myapps\MYAPP.EXE" "Path"="Program Files\sybase\shared\PowerBuilder; c:\program files\sybase\SQL Anywhere 9\win32\; c:\program files\sybase\shared\DataDirectODBC;" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ ODBC Drivers] "Adaptive Server Anywhere 9.0"="Installed" "PB DataDirect OEM 3.60 32-BIT Sybase"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ Adaptive Server Anywhere 9.0] "Driver"="c:\program files\sybase\SQL Anywhere 9\ win32\dbodbc9.dll" "Setup"="c:\program files\sybase\SQL Anywhere 9\ win32\dbodbc9.dll"
For more information about the contents of the registry entries for ODBC drivers and data sources, see Connecting to Your Database.
