Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-28500, but no error returned from postgreSQL

Dave SchleisJun 27 2002
I am running and oracle 8.1.6 on Win2K.
I am attempting to create a db link to a postgreSQL (pgsql) database using ODBC.
I have created a system DSN for the pgsql database and have tested it using MS access.
I then created a system DSN and an oracle db link for the MS Access db.
I have successfully tested the db link from oracle to the Access db, and can even view tables from the pgsql database via the MS Access link, but when I attempt to use the pgsql link created in oracle I get the following:

SQL> create database link LIMS
2 CONNECT TO "user" identified by "pass"
3 using 'TEST';

Database link created.

SQL> SELECT * FROM "tt"@LIMS;
SELECT * FROM "tt"@LIMS
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from LIMS

When I remove the quotes around the table name, I get the following:

SQL> select * from tt@TESTLIMS;
select * from tt@TESTLIMS
*
ERROR at line 1:
ORA-00942: table or view does not exist
[Transparent gateway for ODBC]393330(0,0,1[[]])
ORA-02063: preceding 2 lines from TESTLIMS

So, it appears that the connection has been made. Has anyone else run into a similar situation, with postgreSQL or any other database? Any suggestions would be appreciated.
Thank you
-- dave


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2002
Added on Jun 27 2002
5 comments
956 views