Kbase P22693: Can I use the Merant Progress SQL92 driver to connect a Prog
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/12/2003 |
|
Status: Verified
GOAL:
Can I use the Merant Progress SQL92 driver to connect a Progress schema holder in order to access data from the Oracle db?
GOAL:
Can I use Progress SQL Explorer to connect to a schema holder and access Oracle tables?
GOAL:
Can I use Progress SQL-92 JDBC driver to connect to a schema holder and access Oracle tables?
FACT(s) (Environment):
Oracle
FIX:
The MERANT Progress SQL92 driver will not allow you to connect to ORACLE or any other foriegn database. By using this driver, you will only be able to connect to the Progress schema holder, however you will not be able to see nor access the foreign database's schema definitions. You will only be able to see Progress metaschema information, _file tables.
The Merant Progress SQL92 driver is not intended to connect to a foriegn database. What you are doing is not only not possible but also unsupported.
If your application requires you to access Progress and ORACLE, you will need to make two connections, one to Progress and another directly to ORACLE using the ORACLE ODBC driver.