Dear All,
We are working on set up of connectivity between Oracle and Progress databases. We have oracle gateway configured and select works fine when data is queried from Oracle side. However, it does not work when the where clause is inserted.
Please advise how to work around it. Also, if there is any sample code on how to push data from Progress to Oracle through ODBC, it would help a lot!
Please do share your inputs.
Thanks!
Hi,
I would recommend to open a Technical Support call on:
secure.progress.com/.../custsupport
the registration steps are described on
knowledgebase.progress.com/.../000033353
as this issue might involve more troubleshooting and research.
Some generic (non OpenEdge) instructions on Oracle Database Gateway are available on:
www.progress.com/.../oracle-database-gateway
Which version of OpenEdge is being used? which SQL query is failing? what is the error message received? Does the same SQL query succeed when executed through JDBC:
knowledgebase.progress.com/.../P15898
or ODBC:
knowledgebase.progress.com/.../how-to-test-an-odbc-connection-dsn-on-windows-using-powershell
directly on the OpenEdge database?
Kind regards,
Tinco
Dear Tinco,
Thank you for the response. We have OE11 installed. When we try to select data from oracle side through a link, it works.
However when we use insert into <table>@<link -name> (field-1, field-2) values (value-1,value2) the insert is successful (at times, not sure why). Update does not work at all.
I have granted "ALL" to the user on the connection.
Please do note, that we still have challenges pushing data from Progress to Oracle on a create and update. Even select from progress to oracle does not work and we are not sure how to get it through.
Appreciate the help. Thank you!
Regards,
Harshit