Hey Guyzz I really really need your help :=(
My objective is this, my application requires me to access Progress and ORACLE. I have found out earlier that the MERANT Progress SQL92 driver is not intended to connect to a foreign database.It is not supported. So my last option here is to make two connections, one to Progress another directly to ORACLE using the ORACLE ODBC driver.
After setting up the connectivity , I made some queries to access progress data. I am currently logon using ORACLE ODBC DRIVER. I have tried the syntax below but it prompted me a "Syntax Error" message. Pls Pls.. can anyone show me some sample script using ORACLE ODBC DRIVER in accessing Progress DATA.
this is the syntax Ive tried :=(
select * from jbcdatabase..pub.tablename;
My objective is this, my application requires me to access Progress and ORACLE. I have found out earlier that the MERANT Progress SQL92 driver is not intended to connect to a foreign database.It is not supported. So my last option here is to make two connections, one to Progress another directly to ORACLE using the ORACLE ODBC driver.
After setting up the connectivity , I made some queries to access progress data. I am currently logon using ORACLE ODBC DRIVER. I have tried the syntax below but it prompted me a "Syntax Error" message. Pls Pls.. can anyone show me some sample script using ORACLE ODBC DRIVER in accessing Progress DATA.
this is the syntax Ive tried :=(
select * from jbcdatabase..pub.tablename;