From: | "Schleis, David" <dave(at)mail(dot)slh(dot)wisc(dot)edu> |
---|---|
To: | "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Problems with ORACLE |
Date: | 2003-07-29 14:00:52 |
Message-ID: | 816EFCC70BCAD411B44D0090278F184101152333@slhmailehd.slh.wisc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Using Oracle 8.1.6 I was never successful in accessing a PostgreSQL database.
Examination of the log files revealed that the Oracle ODBC driver uses double
quotes "" inconsistently creating and then calling a table alias. There was no
way around this, so it was impossible to access the PostgreSQL database from
Oracle. I posted these findings on the OTN Heterogeneous Services discussion
group and was told I needed to contact Oracle support. I moved on to other
projects and I have not tried again with later versions of the Oracle ODBC
driver. If you find a way to get Oracle to talk to PostgreSQL please let me
know.
-- dave
David Schleis
Wisconsin State Laboratory of Hygiene
and Occupational Health Laboratory
email: dave(at)mail(dot)slh(dot)wisc(dot)edu <mailto:dave(at)mail(dot)slh(dot)wisc(dot)edu>
snail: Madison WI 53707-7996
ups/fedx: 2601 Agriculture Dr
Madison WI 53718
voice: 608.224.6227
fax: 608.224.6267
-----Original Message-----
From: Alejandro Fuentes González [mailto:alejandro(dot)fuentes(at)SSP(dot)DF(dot)GOB(dot)MX]
Sent: Monday, July 28, 2003 7:08 PM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] Problems with ORACLE
Hi, when I use the psqlODBC with MS-Access I´ve got not problems but when I try
to use it with Oracle the next message appears:
SELECT * FROM "ORACLE"."TABLITA"@POSGRES
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC]Record &SQLREC has no fields. Loading failed
ORA-02063: preceding 2 lines from POSGRES
Altougth I´ve got already fields in the tables, I´ve tried with differnt kind of
datatypes varchar char int numeric....but the problem persist
Any Idea???
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Amanjit Gill | 2003-07-30 20:06:11 | ODBC + Dynamic cursors |
Previous Message | Alejandro Fuentes González | 2003-07-29 00:08:12 | Problems with ORACLE |