ORA-28500, but no error returned from postgreSQL
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