Your users need access to the DBMS and to the database your application uses.
You need to:
-
If necessary, install the DBMS runtime files in the application directory or in a directory on the system path.
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 native 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 an ODBC driver.
You need to install the database interface drivers your application requires, such as the ODBC interface and other native database interfaces.
The files for the native database interfaces your application uses belong in the same directory as the application or in a directory on the system path. When you install InfoMaker, these files are installed in the %systemdrive%\Program Files (x86)\Appeon\Common\PowerBuilder\Runtime [version]\ directory. The first two characters of the file name are PB, the next three characters identify the database, and the last two identify the version of InfoMaker. For example, PBO90.dll is the Oracle9i database interface and PBSYC.dll is the SAP Sybase CT-LIB database interface.
If your application uses ODBC drivers, each user's machine needs three types of files:
-
PowerBuilder ODBC interface and driver syntax files
Install PBODB.dll and PBODB.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 PBODB initialization file, make sure you deploy the modified version.
For information about adding sections or functions to the PBODB 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 installation package to update users' systems if necessary.
-
ODBC database drivers and supporting files
SAP provides ODBC database drivers for SQL Anywhere as well as PB DataDirect drivers for several databases.
The PB DataDirect ODBC files in the following table 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.LICPBBAS19*.DLL PBUTL19*.DLL PBTRN19.dll |
All PB DataDirect OEM 4.2 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\\PBtrn19.dll" "Setup"="%SHARED%\\DataDirectODBC\\PBtrn19.dll" |
|
PBASE19.DLL PBASE19R.DLL PBASE19S.DLL PBASE19.HLP PBASE19.CNT |
PB DataDirect OEM 4.2 SAP Adaptive Server Enterprise Wire Protocol. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 Sybase ASE Wire Protocol" = "Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 Sybase ASE Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBASE19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBASE19S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="0" "UsageCount"="1" "CPTimeout"="60" |
|
PBBTR19.DLL PBBTR19R.DLL PBBTR19S.DLL PBFLT19.DLL PBFLT19R.DLL |
PB DataDirect OEM 4.2 Btrieve. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 Btrieve (*.dta)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 Btrieve (*.dta)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBBTR19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBBTR19S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="1" "FileExtns"="*.dta" "SQLLevel"="0" "CPTimeout"="60" |
|
*.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: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 DB2 Wire Protocol"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 DB2 Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBDB219.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBDB219S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="03.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
|
PBDBF19.DLL PBDBF19R.DLL PBFLT19.DLL PBFLT19R.DLL |
PB DataDirect OEM 4.2 dBASE. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 dBASEFile (*.dbf)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 dBASEFile (*.dbf)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBDBF19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBDBF19.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="1" "FileExtns"="*.dbf" "SQLLevel"="0" "CPTimeout"="60" |
|
PBGUP19.DLL PBGUP19R.DLL PBGUP19S.DLL |
PB DataDirect OEM 4.2 SQLBase. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 SQLBase"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 SQLBase] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBGUP19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBGUP19S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
|
PBIDP19.DLL PBIDP19R.DLL PBIDP19S.DLL PBFLT19.DLL PBFLT19R.DLL |
PB DataDirect OEM 4.2 Paradox. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 ParadoxFile (*.db)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 ParadoxFile (*.db)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBIDP19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBIDP19S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="1" "FileExtns"="*.db" "SQLLevel"="0" "CPTimeout"="60" |
|
PBIFCL19.DLL PBIFCL19R.DLL PBIFCL19S.DLL |
PB DataDirect OEM 4.2 Informix Wire Protocol. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 INFORMIX Wire Protocol"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 INFORMIX Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBIFCL19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBIFCL19S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
|
PBINF19.DLL PBINF19R.DLL PBINF19S.DLL PBINFDTC19.DLL |
PB DataDirect OEM 4.2 Informix. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 INFORMIX"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 INFORMIX] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBINF19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBINF19S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
|
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: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 SQL Server Wire Protocol"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 SQL Server Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBMSSS19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBMSSS19S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
|
PBOR819.DLL PBOR819R.DLL PBOR819S.DLL PBOR8DTC19.DLL |
PB DataDirect OEM 4.2 Oracle. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 Oracle"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 Oracle] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBOR819.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBOR819S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
|
PBORA19.DLL PBORA19R.DLL PBORA19S.DLL |
PB DataDirect OEM 4.2 Oracle Wire Protocol. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 Oracle Wire Protocol"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 Oracle Wire Protocol] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBORA19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBORA19S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
|
PBPRO919.DLL PBPRO919R.DLL PBPRO919S.DLL |
PB DataDirect OEM 4.2 Progress 9. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 PROGRESS 9"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 PROGRESS 9] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBPRO919.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBPRO919S.DLL" "APILevel"="1" "ConnectFunctions"="YYN" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="0" "CPTimeout"="60" |
|
PBSS619.DLL PBSS619R.DLL PBSS619S.DLL |
PB DataDirect OEM 4.2 SQL Server 6.5. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 SQL Server 6.5"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 SQL Server 6.5] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBSS619.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBSS619S.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="0" "SQLLevel"="1" "CPTimeout"="60" |
|
PBTXT19.DLL PBTXT19R.DLL PBFLT19.DLL PBFLT19R.DLL |
PB DataDirect OEM 4.2 Text File. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 TextFile (*.*)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 TextFile (*.*)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBTXT19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBTXT19.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="1" "FileExtns"="*.*" "SQLLevel"="0" "CPTimeout"="60" |
|
PBXLWB19.DLL PBXLWB19R.DLL PBFLT19.DLL PBFLT19R.DLL |
PB DataDirect OEM 4.2 Excel Workbook. Registry entry: [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "PB DataDirect OEM 4.2 ExcelWorkbook (*.xls)"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PB DataDirect OEM 4.2 ExcelWorkbook (*.xls)] "UsageCount"="1" "Driver"="%SHARED%\\DataDirectODBC\\PBXLWB19.DLL" "Setup"="%SHARED%\\DataDirectODBC\\PBXLWB19.DLL" "APILevel"="1" "ConnectFunctions"="YYY" "DriverODBCVer"="3.51" "FileUsage"="2" "FileExtns"="*.xls" "SQLLevel"="0" "CPTimeout"="60" |
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":
[HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\MyApp DB] "Driver"="C:\Program Files\SAP\SQL Anywhere 9\win32\dbodbc9.dll" "Start"="c:\program files\SAP\SQL Anywhere 9\win32\rteng9.exe -c8m" "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"="SQL Anywhere 9.0"
You might use one of the following ways to make the modifications to ODBC.INI:
-
Use Microsoft's ODBC Administrator control panel, if the control panel is available on the user's system.
-
Use a software distribution application that includes ODBC configuration instructions to do your installation.
For more information about the contents of the registry entries for ODBC drivers and data sources, see Connecting to Your Database.
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 in the registry.
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 SQL Anywhere. Registry keys are enclosed in square brackets and are followed by string values for that 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"="C:\Program Files\Appeon\Common\PowerBuilder\Runtime 2388\;c:\program files\SAP\SQL Anywhere 8\win32\; c:\program files\SAP\shared\DataDirectODBC;" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "SQL Anywhere 9.0"="Installed" "PB DataDirect OEM 3.60 32-BIT Sybase"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Anywhere 9.0] "Driver"="c:\program files\SAP\SQL Anywhere 9\win32\dbodbc9.dll" "Setup"="c:\program files\SAP\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.
Database profiles
Connecting to Your Database includes information about database profiles. Profiles, which are defined in the Windows registry, provide the information necessary to connect to data sources from the development environment. Your users do not need database profiles.
If your InfoMaker application has reports and forms that access an SQL Anywhere database, you need to deploy the SQL Anywhere DBMS as well as SQL Anywhere's ODBC database drivers. You can deploy the SQL Anywhere Desktop Runtime System 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. The runtime system is installed on your computer when you install the PB Demo DB or the tutorial.
Restrictions
InfoMaker includes SQL 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 Appeon sales representative.
In addition to deploying the runtime system, you need to do the following for your users:
-
Make your application's data source available
-
Configure ODBC to access the data source
For more information about deploying SQL Anywhere databases and applications, see the SQL Anywhere User's Guide.
A full installation for the SQL Anywhere driver, runtime engine, and supporting files is available in the Support directory on the installation package. The following table 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 |
SQL Anywhere ODBC driver |
|
DBBACKUP.EXE |
SQL Anywhere 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 |
SQL Anywhere database tools |
|
DBUNLOAD.EXE |
SQL Anywhere unload utility |
|
DBVALID.EXE |
SQL Anywhere validation utility |
|
RTENG9.EXE |
Restricted runtime engine |
|
DBCTRS9.DLL |
Performance utility |
|
DBSERV9.DLL |
Server utility |
|
DBWTSP9.DLL |
Tools support |
If your application uses OLE DB or ADO.NET 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 installation package to update users' computers. The Microsoft OLE DB providers, SQLOLEDB and MSDASQL, are installed when you run MDAC_TYP.EXE.
You must distribute PBOLE.dll with an application that uses OLE DB, and PBADO.dll and PBDATA.dll with an application that uses ADO.NET.
The following files are required if you use the PB DataDirect OLE DB data provider specified. When you install InfoMaker, they are installed in the Appeon\Shared\PowerBuilder\DataDirect folder. If your application uses an OLE DB data provider from another vendor, you must still deploy PBOLE.dll as well as the files specified by the vendor. You need to register PBADMINR.DLL, PBINF90R.DLL, PBOR709R.DLL, PBOR890R.DLL, PBSYB09R.DLL, and PBXML09R.DLL as shared DLLs.
Optional Help files
Help (.HLP and .CNT) files need only be deployed if you expect users to perform database administration tasks.
|
Name |
Required for |
|---|---|
|
PBOLE.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 SAP Adaptive Server Enterprise |
|
PBXML09.CNT PBXML09.DLL PBXML09.HLP PBXML09R.DLL |
PB DataDirect OEM 2.70 XML |
If your application includes a report that has a button that displays the Save As dialog box, you need to deploy some files that enable users to save as PDF or XSL-FO. To save as PDF using the distill method, users also need to download and install GNU Ghostscript. Distribution of Ghostscript files is restricted by GNU licensing.
For more information about saving as PDF and XSL-FO, see Saving the data as PDF and Saving as XSL-FO. For more information about assigning button actions, see Actions assignable to buttons in reports.
In order for users to use the Save As dialog box to save data as PDF with the distiller, they must first download and install GNU Ghostscript on their computers as described in the procedure that follows.
The use of GNU Ghostscript is subject to the terms and conditions of the GNU General Public License (GPL). Users should be asked to read the GPL before installing GNU Ghostscript on their computers. A copy of the GPL is available on the GNU Project Web server.
To install GNU Ghostscript:
-
Into a temporary directory on your computer, download gs705w32.exe from the gs705 directory, or gs706w32.exe from the gs706 directory, at ftp://mirror.cs.wisc.edu/pub/mirrors/ghost/gnu.
You can find a list of alternative mirror sites on the Ghostscript Web site at http://www.ghostscript.com/doc/gnu/gnu705.htm.
-
Run the executable file to install Ghostscript on your system.
The default installation directory is C:\gs. You can select a different directory and/or choose to install shortcuts to the Ghostscript console and readme file.
Location of files
When you save a report as PDF using the distill method, InfoMaker searches in the following locations for an installation of GNU Ghostscript:
-
The Windows registry
-
The relative path of the pbdwe.dll file (typically %systemdrive%\Program Files (x86)\Appeon\Common\PowerBuilder\Runtime [version]\)
-
The system PATH environment variable
If GNU Ghostscript is installed using either gs705w32.exe (for Ghostscript 7.05) or gs706w32.exe (for Ghostscript 7.06), the path is added to the Windows registry.
If the Ghostscript files are in the relative path of the pbdwe.dll file, they must be installed in this directory structure:
dirname\pbdwe.dll dirname\gs\gs7.0N dirname\gs\fonts
where dirname is the directory that contains the runtime DLLs and N is the minor release version number for Ghostscript.
You might not need to distribute all the fonts provided in the distribution. For information about fonts, see Fonts and font facilities supplied with Ghostscript at the Ghostscript web site.
You must also deploy the default PostScript printer driver and related files that are installed in %AppeonInstallPath%\InfoMaker [version]\IDE\drivers. These files can be copied to or installed on users' computers. They must be located in this directory structure:
dirname\pbdwe.dll dirname\drivers
