Kbase P55878: How to connect to Progress Oracle DataServer using SQL-89?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/11/2003 |
|
Status: Unverified
GOAL:
How to connect to Progress Oracle DataServer using SQL-89?
GOAL:
How to probuild _prooidv to include Oracle DataServer support?
FIX:
Progress does not distribute the OID/OIB with support for the Progress Oracle DataServer.
However, the OID may be probuilt to include TCP and Oracle library files which would provide the necessary files for the OID to connect to an Oracle DataServer using SQL-89.
To accomplish this, do the following:
1. Create an empty directory and make this the working directory for building a
new _prooidv for the Oracle DataServer.
2. Make sure ORALIB is set correctly pointing directly to the ORACLE shared library. If ORALIB is not set, set this variable to; $ORACLE_HOME/lib/libclntsh.xx.
Note that ORACLE does not support shared objects on all UNIX platforms. See the ORACLE documentation for more information.
3. Make sure ORACLE_HOME is set.
4. Make sure the PATH contains both $ORACLE_HOME, $ORACLE_HOME/bin and shared library environment variable, i.e., LD_LIBRARY_PATH, SHLIB_PATH, or LIBPATH.
5. Execute the probuild menu, $DLC/probuild/eucapp/probuild
Enter working directory for link script
Select Open Interface Driver from the Produce List
Accept Link Script and Executable Names.
Select Oracle_DataServer and TCP-IP under Configurable Elements.
6. Exit to command line.
7. Link script will be created, i.e., ldoidrvr. Review oraenv.log file to ensure that all correct variables are being used.
8. Generate the executable by running the linked script.
./ldoidrvr
If on a UNIX system, if the SETUID bit is on, make sure there is a soft link from /usr/lib to $ORACLE_HOME/lib directory.
The linker utility generates the customized executable (_prooidv) as specified in the link script. The customized executable is now ready for use.
9. For setting up the OIB/OID Broker reference solution 17204: How to setup a SQL-89 ODBC connection using the OIB/OID
10. For setting up the client's ODBC Datasource reference solution P16297 Step by step how to connect a third party software to PROGRESS database using
The client's datasource configuration will also require the Oracle connection information. This should be added within the ODBC Progress Driver Setup by selecting the Advanced tab and then Database Connection Options / Additional Options / and entering the DataServer connect information.
ie. -db dbname -ld ldname -dt ORACLE -U tiger -P tiger