If your application uses ODBC drivers, each user’s machine needs three types of files:
PowerBuilder ODBC interface and driver syntax files Install PBODB105.DLL and PBODB105.INI in the application directory or a directory on the system path. 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.
For information about adding sections or functions to the PBODB105 initialization 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. You can use the redistributable MDAC_TYP.EXE setup file in the Support directory on the CD to update users’ systems if necessary.
ODBC database drivers and supporting files Sybase provides ODBC database drivers for Adaptive Server Anywhere as well as PB DataDirect drivers for several databases.
The PB DataDirect ODBC files in Table 22-3 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.
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"
|
