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 100 – PowerBuilder Library

Database connections – PB Docs 100

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 10.0
  5. Database connections – PB Docs 100

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 and interfaces,
see:

Native database drivers

Table 41-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 41-5: PowerBuilder native database
drivers
Name Required for
PBIN9100.DLL INFORMIX I-Net 9
PBO84100.DLL Oracle 8.0.x and Oracle8i 8.1.x
PBO90100.DLL Oracle9i
PBO10100.DLL Oracle 10g
PBDIR100.DLL Sybase DirectConnect
PBSYC100.DLL Sybase Adaptive Server Enterprise CT-LIB
PBSYJ100.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 files

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

Table 41-6: PowerBuilder ODBC interface files
Name Description
PBODB100.DLL PowerBuilder ODBC interface
PBODB100.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 PBODB100 initialization file,
make sure you deploy the modified version.

Microsoft ODBC files

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

Table 41-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 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.

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

Table 41-8: PowerBuilder DataDirect ODBC
files
Name Driver and registry entry:
IVPB.LIC
PBBAS19*.DLL
PBUTL19*.DLL
PBTRN19.dll 		All PB DataDirect OEM 4.2 drivers. Registry
entry:
PBBTR19.DLL
PBBTR19R.DLL
PBBTR19S.DLL
PBFLT19.DLL
PBFLT19R.DLL		 PB DataDirect OEM 4.2 Btrieve. Registry
entry:
*.UCT
PBDB219.DLL
PBDB219R.DLL
PBDB219S.DLL
APPC19IV.DLL
BIND19IV.DLL
CLRT19IV.DLL
COSI19IV.DLL
DRDA19IV.DLL
LIBUNIC.DLL
MEMR19IV.DLL
PROT19IV.DLL
SOCK19IV.DLL
XCPG19IV.DLL
XDB2DB2.ERR
XDB2DRDA.ERR
XDBMF.ERR
XDBNET.ERR
XDBRES.ERR		 PB DataDirect OEM 4.2 DB2 Wire Protocol.
Registry entry:

PBDBF19.DLL
PBDBF19R.DLL
PBFLT19.DLL
PBFLT19R.DLL		 PB DataDirect OEM 4.2 dBASE. Registry
entry:
PBXLWB19.DLL
PBXLWB19R.DLL
PBFLT19.DLL
PBFLT19R.DLL		 PB DataDirect OEM 4.2 Excel Workbook.
Registry entry:
PBINF19.DLL
PBINF19R.DLL
PBINF19S.DLL
PBINFDTC19.DLL 		PB DataDirect OEM 4.2 Informix. Registry
entry:
PBIFCL19.DLL
PBIFCL19R.DLL
PBIFCL19S.DLL 		PB DataDirect OEM 4.2 Informix Wire Protocol.
Registry entry:
PBOR819.DLL
PBOR819R.DLL
PBOR819S.DLL
PBOR8DTC19.DLL 		PB DataDirect OEM 4.2 Oracle. Registry
entry:

PBORA19.DLL
PBORA19R.DLL
PBORA19S.DLL 		PB DataDirect OEM 4.2 Oracle Wire Protocol.
Registry entry:
PBIDP19.DLL
PBIDP19R.DLL
PBIDP19S.DLL
PBFLT19.DLL
PBFLT19R.DLL		 PB DataDirect OEM 4.2 Paradox. Registry
entry:
PBPRO919.DLL
PBPRO919R.DLL
PBPRO919S.DLL		 PB DataDirect OEM 4.2 Progress 9. Registry
entry:
PBGUP19.DLL
PBGUP19R.DLL
PBGUP19S.DLL 		PB DataDirect OEM 4.2 SQLBase. Registry
entry:
PBSS619.DLL
PBSS619R.DLL
PBSS619S.DLL 		PB DataDirect OEM 4.2 SQL Server 6.5.
Registry entry:
PBMSSS19.DLL
PBMSSS19R.DLL
PBMSSS19S.DLL
DBNETLIB.DLL
SQLSRV32.DLL
SQLSRV32.RLL
SQLUNIRL.DLL 		PB DataDirect OEM 4.2 SQL Server Wire
Protocol. Registry entry:
PBASE19.DLL
PBASE19R.DLL
PBASE19S.DLL
PBASE19.HLP
PBASE19.CNT
PB DataDirect OEM 4.2 Sybase Adaptive
Server Enterprise Wire Protocol. Registry entry:
PBTXT19.DLL
PBTXT19R.DLL
PBFLT19.DLL
PBFLT19R.DLL		 PB DataDirect OEM 4.2 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 drivers on 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 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.

Table 41-9: Adaptive Server Anywhere files
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 FilesSybaseSQL
Anywhere 9win32

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.

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 41-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 PBOLE100.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 41-10: PowerBuilder DataDirect OLE DB
files
Name Required for
PBOLE100.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 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”.

ADO.NET database interface

The PowerBuilder ADO.NET interface supports the OLE DB and
Microsoft SQL Server .NET data providers. If you use ADO.NET, you
must deploy PBADO100.DLL, PBDATA100.DLL,
and the OLE DB data provider.

The file PBADO100.DLL is a standard DLL
file, and you can deploy it in the same way as other PowerBuilder
DLLs. However, PBDATA100.DLL is a .NET assembly.
You can use one of three techniques to deploy this file:

  • Deploy PBDATA100.DLL in the
    same directory as the executable file that calls the ADO.NET driver.
  • Use a .NET application configuration file to assign
    the path of PBDATA100.DLL. The file contains
    configuration settings that the common language runtime (CLR) reads
    as well as settings that the application reads. For an executable
    file, the configuration file has the same name as the executable
    file with the extension .config. The pb100.exe.config file
    in your PowerBuilder 10.0 directory is an example.
    For more information about configuration files, see the section
    on application configuration files in the .NET Framework Developer’s Guide
    .
  • Add the PBDATA100.DLL assembly
    to the Global Assembly Cache (GAC). Use this technique only when
    the assembly must be shared by several applications. You can no
    longer install an application using xcopy if
    one of the assemblies it uses is in the GAC.
    For more information about the GAC, see the section on the
    Global Assembly Cache in the .NET Framework Developer’s Guide
    .

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 41-11: PowerBuilder JDB files
Name Description
PBJDB100.DLL PowerBuilder JDBC Driver (JDB) for JRE
1.2 or later
pbjdbc12100.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 pbjdbc12100.jar file. For example:

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

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