Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Database connections – PB Docs 90 – PowerBuilder Library

Database connections – PB Docs 90

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 9.0
  5. Database connections – PB Docs 90

Database connections

If you are deploying an executable or component that accesses
a database, your users need access to the DBMS and to the database
your application uses.

note.gif Where to install database connectivity files You do not need to deploy database connectivity
files with a client application that relies on a middle-tier
component on another computer to perform database transactions.
Database connectivity files must be deployed on the computer that
interacts with the database server.

You need to:

  • If necessary,
    install the DBMS runtime (client) files in the application directory
    or in a directory on the system path
    If your application uses a standalone Adaptive Server Anywhere
    database, you can install the Adaptive Server Anywhere Runtime Edition
    files on the user’s computer. For more information, see “Adaptive Server Anywhere
    files”    . Otherwise
    follow the instructions and licensing rules specified by the vendor.
  • Make sure each user has access to the database the
    application uses
    If your application uses a local database, install the database
    and any associated files, such as a log file, on the user’s
    computer.

    If your application uses a server database, make sure the
    user’s computer is set up to access the database. This
    may be the task of a database administrator.

  • Install any database interfaces your application
    uses on the user’s computer
  • If your application uses the ODBC interface, configure
    the ODBC database drivers and data sources, as described in “Configuring ODBC data
    sources and drivers”

For more information about database drivers, see:

Native database drivers

Table 39-5 lists
the native database drivers supplied with PowerBuilder. If an application
or component uses the database specified, the file is required on
the computer. The first two characters of the native database file
name are PB, the next three characters identify the database, and
the last two identify the version of PowerBuilder:

Table 39-5: PowerBuilder native database
drivers
Name Required for
PBIN990.DLL INFORMIX I-Net 9
PBMSS90.DLL Microsoft SQL Server 6 and 7
PBO7390.DLL Oracle 7.3
PBO8490.DLL Oracle 8.0.x and Oracle8i 8.1.x
PBO9090.DLL Oracle9i
PBDIR90.DLL Sybase DirectConnect
PBSYC90.DLL Sybase Adaptive Server Enterprise CT-LIB
PBSYJ90.DLL Sybase Adaptive Server Enterprise CT-LIB
for EAServer deployment only

Installed path Program FilesSybaseSharedPowerBuilder

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 When you deploy a PowerBuilder custom class user object to EAServer, you need to use the SYJ
database interface rather than SYC to connect to an Adaptive Server
Enterprise database. You cannot use SYJ in the PowerBuilder development
environment, but you can use the SYJ Database Profile Setup dialog
box to set the appropriate connection parameters. You can then copy
the syntax from the Preview tab into the script for your Transaction object.

ODBC database drivers and supporting files

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.

PowerBuilder ODBC interface

The following PowerBuilder ODBC interface files are required
if your application uses ODBC:

Table 39-6: PowerBuilder ODBC interface files
Name Description
PBODB90.DLL PowerBuilder ODBC interface
PBODB90.INI PowerBuilder ODBC initialization file

Installed path Program FilesSybaseSharedPowerBuilder

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 PBODB90 initialization file,
make sure you deploy the modified version.

Microsoft ODBC files

Table 39-7 lists
the Microsoft ODBC files that are required if your application uses
ODBC.

Table 39-7: Microsoft ODBC files
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.

Registry entries None.

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.

PB DataDirect ODBC drivers and supporting files

The PB DataDirect ODBC files in Table 39-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.

note.gif Optional Help files Help (.HLP and .CNT)
files need only be deployed if you expect users to perform database
administration tasks.

Table 39-8: PowerBuilder DataDirect ODBC
files
Name Driver and registry entry:
IVPB.LIC
PBBAS18*.DLL
PBUTL18*.DLL
PBTRN18.dll
PBDRV18.CNT
PBDRV18.HLP 		All PB DataDirect OEM 4.10 drivers. Registry
entry:
PBBTR18.DLL
PBBTR18R.DLL
PBBTR18S.DLL
PBBTR18.CNT
PBBTR18.HLP
PBFLT18.DLL
PBFLT18R.DLL		 PB DataDirect OEM 4.10 Btrieve. Registry
entry:
*.UCT
PBDB218.DLL
PBDB218R.DLL
PBDB218S.DLL
PBDB218.HLP
PBDB218.CNT
APPC18IV.DLL
BIND18IV.DLL
CLRT18IV.DLL
COSI18IV.DLL
DRDA18IV.DLL
LIBUNIC.DLL
MEMR18IV.DLL
PROT18IV.DLL
SOCK18IV.DLL
XCPG18IV.DLL
XDB2DB2.ERR
XDB2DRDA.ERR
XDBMF.ERR
XDBNET.ERR
XDBRES.ERR		 PB DataDirect OEM 4.10 DB2 Wire Protocol.
Registry entry:

PBDBF18.DLL
PBDBF18R.DLL
PBFLT18.DLL
PBFLT18R.DLL
PBDBF18.HLP
PBDBF18.CNT		 PB DataDirect OEM 4.10 dBASE. Registry
entry:
PBXLWB18.DLL
PBXLWB18R.DLL
PBXLWB18.HLP
PBXLWB18.CNT
PBFLT18.DLL
PBFLT18R.DLL		 PB DataDirect OEM 4.10 Excel Workbook.
Registry entry:
PBINF18.DLL
PBINF18R.DLL
PBINF18S.DLL
PBINFDTC18.DLL
PBINF18.HLP
PBINF18.CNT		 PB DataDirect OEM 4.10 Informix. Registry
entry:
PBIFCL18.DLL
PBIFCL18R.DLL
PBIFCL18S.DLL
PBIFCL18.HLP
PBIFCL18.CNT		 PB DataDirect OEM 4.10 Informix Wire
Protocol. Registry entry:
PBOR818.DLL
PBOR818R.DLL
PBOR818S.DLL
PBOR8DTC18.DLL
PBOR818.HLP
PBOR818.CNT		 PB DataDirect OEM 4.10 Oracle. Registry
entry:

PBORA18.DLL
PBORA18R.DLL
PBORA18S.DLL
PBORA18.HLP
PBORA18.CNT		 PB DataDirect OEM 4.10 Oracle Wire Protocol.
Registry entry:
PBIDP18.DLL
PBIDP18R.DLL
PBIDP18S.DLL
PBIDP18.HLP
PBIDP18.CNT
PBFLT18.DLL
PBFLT18R.DLL		 PB DataDirect OEM 4.10 Paradox. Registry
entry:
PBPRO918.DLL
PBPRO918R.DLL
PBPRO918S.DLL
PBPRO918.HLP
PBPRO918.CNT		 PB DataDirect OEM 4.10 Progress 9. Registry
entry:
PBGUP18.DLL
PBGUP18R.DLL
PBGUP18S.DLL
PBGUP18.HLP
PBGUP18.CNT		 PB DataDirect OEM 4.10 SQLBase. Registry
entry:
PBSS618.DLL
PBSS618R.DLL
PBSS618S.DLL
PBSS618.HLP
PBSS618.CNT		 PB DataDirect OEM 4.10 SQL Server 6.5.
Registry entry:
PBMSSS18.DLL
PBMSSS18R.DLL
PBMSSS18S.DLL
PBMSSS18.HLP
PBMSSS18.CNT
DBNETLIB.DLL
SQLSRV32.DLL
SQLSRV32.RLL
SQLUNIRL.DLL
SQLSODBC.CHM
SQLSODBC.HLP		 PB DataDirect OEM 4.10 SQL Server Wire
Protocol. Registry entry:
PBASE18.DLL
PBASE18R.DLL
PBASE18S.DLL
PBASE18.HLP
PBASE18.CNT
PB DataDirect OEM 4.10 Sybase Adaptive
Server Enterprise Wire Protocol. Registry entry:
PBTXT18.DLL
PBTXT18R.DLL
PBTXT18.HLP
PBTXT18.CNT
PBFLT18.DLL
PBFLT18R.DLL		 PB DataDirect OEM 4.10 Text File. Registry
entry:

Installed path Program FilesSybaseSharedDataDirect

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 driverson page .

Adaptive Server Anywhere
files

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.

note.gif 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 39-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.

Table 39-9: Adaptive Server Anywhere files
Name Description
DBODBC8.DLL ASA ODBC driver
DBBACKUP.EXE ASA backup utility
DBCON8.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
DBLGEN8.DLL Language-specific string library (EN indicates
the English version)
DBLIB8.DLL Interface library
DBODTR8.DLL ODBC translator, required if your application
relies on OEM to ANSI character set conversion
DBTOOL8.DLL ASA database tools
DBUNLOAD.EXE ASA unload utility
DBVALID.EXE ASA validation utility
RTENG8.EXE Restricted runtime engine
DBCTRS8.DLL Performance utility
DBSERV8.DLL Server utility
DBWTSP8.DLL Tools support

Installed path Program FilesSybaseSQL
Anywhere 8win32

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 DBODB8.DLL. If you are not using the English
string library, make sure you deploy the appropriate version of
the language-specific string library.

Configuring ODBC data
sources and drivers

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“:

ODBCINST.INI Your installation program needs to make two types of entry
in the ODBCINST.INI key in HKEY_LOCAL_MACHINESOFTWAREODBC 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“:

For more information about the contents of
the registry entries for ODBC drivers and data sources, see Connecting
to Your Database
.

OLE DB database providers

If your application uses OLE DB to access data, you must install
Microsoft’s Data Access Components software on each user’s
computer if it is not installed already.

You can use the MDAC_TYP.EXE setup
file in the Support directory on the CD to
update users’ computers. The Microsoft OLE DB providers,
SQLOLEDB and MSDASQL, are installed when you run MDAC_TYP.EXE.

The files listed in Table 39-10 are required if you use the PB DataDirect
OLE DB data provider specified. If your application uses an OLE
DB data provider from another vendor, you must still deploy PBOLE90.DLL as
well as the files specified by the vendor.

note.gif Optional Help files Help (.HLP and .CNT)
files need only be deployed if you expect users to perform database
administration tasks.

Table 39-10: PowerBuilder DataDirect OLE DB
files
Name Required for
PBOLE90.DLL PowerBuilder OLE DB interface required
for all OLE DB connections
401COMUPD.EXE
IVODBC.LIC
PBADMIN.CNT
PBADMIN.EXE
PBADMIN.HLP
PBADMINR.DLL 		License and help files and administration
utilities required for all PB DataDirect OEM 2.70 OLE DB data providers
PBINF09.CNT
PBINF09.DLL
PBINF09.HLP
PBINF09R.DLL 		PB DataDirect OEM 2.70 Informix 7.x and
9.x
PBOR709.CNT
PBOR709.DLL
PBOR709.HLP
PBOR709R.DLL 		PB DataDirect OEM 2.70 Oracle 7
PBOR809.CNT
PBOR809.DLL
PBOR809.HLP
PBOR809R.DLL 		PB DataDirect OEM 2.70 Oracle 8
PBSYB09.CNT
PBSYB09.DLL
PBSYB09.HLP
PBSYB09R.DLL 		PB DataDirect OEM 2.70 Sybase Adaptive
Server Enterprise
PBXML09.CNT
PBXML09.DLL
PBXML09.HLP
PBXML09R.DLL 		PB DataDirect OEM 2.70 XML

Installed path Program FilesSybaseSharedDataDirectOLEDB

Deployment path Same directory as the application, in a directory on the system
path, or in the App Path registry key.

Registry entries Register PBADMINR.DLL, PBINF90R.DLL, PBOR709R.DLL, PBOR890R.DLL, PBSYB09R.DLL,
and PBXML09R.DLL as shared DLLs. See also“App Path registry key”.

JDBC database interface

The PowerBuilder JDB interface supports the Sun Java Runtime
Environment (JRE) versions 1.2 and later.

If your application or component uses JDBC connections, you
must deploy the JDB driver as well as the appropriate Java package
for the Java VM you are using. The Java virtual machine and a vendor-supplied
JDBC-compliant driver, such as Sybase jConnect® for JDBC,
must also be installed and configured on the computer that accesses
the data source.

To specify which Java VM the driver should load, use the JavaVM
DBParm. You should use the same setting for this DBParm in the development
and deployment environments. See Connecting to Your Database
for
more information.

For more information about the Java VM, see “Java support”.

Table 39-11: PowerBuilder JDB files
Name Description
PBJDB90.DLL PowerBuilder JDBC Driver (JDB) for JRE
1.2 or later
pbjdbc1290.jar Java package for PowerBuilder JDB driver
and JRE 1.2 or later

Installed path Program FilesSybaseSharedPowerBuilder

Deployment path Same directory as the application, in a directory on the system
path, or in the App Path registry key.

Registry entries Make sure the CLASSPATH environment variable includes the
PowerBuilder pbjdbc1290.jar file. For example:

Notes See “PowerBuilder component on
EAServer “ and “Web DataWindow on EAServer “.

Document get from Powerbuilder help
Thank you for watching.
Powerbuilder Documentation 9.0
PB Docs 90 Powerbuilder Documentation Powerbuilder Documentation 9.0 Powerbuilder Documentation Older Powerbuilder User Guide
August 3, 2023
Was this article helpful?
6
8
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x