Thread: unrecognized data type on dblink
Hi all, I have a problem with dblink from oracle to postgresql. I cannot read varchar colums from postgresql db, in the trace file the message is in the trace file is : unrecognized data type. How can I solve this problem Oracle version is 10.2.0.1 on windows 2003 machine and postgresql is 8.2.3 on Centos 4.4
On Fri, Jul 18, 2008 at 9:24 AM, Aynur SANCAKLI <aynur.sancakli@kamusm.gov.tr> wrote: > Hi all, > I have a problem with dblink from oracle to postgresql. > > I cannot read varchar colums from postgresql db, in the trace file the > message is in the trace file is : unrecognized data type. Which Postgres ODBC driver are you using with heterogeneous services? -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/
I use 8.03.02.00 version driver. > On Fri, Jul 18, 2008 at 9:24 AM, Aynur SANCAKLI > <aynur.sancakli@kamusm.gov.tr> wrote: >> Hi all, >> I have a problem with dblink from oracle to postgresql. >> >> I cannot read varchar colums from postgresql db, in the trace file the >> message is in the trace file is : unrecognized data type. > > Which Postgres ODBC driver are you using with heterogeneous services? > > -- > Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 > EnterpriseDB Corporation | fax: 732.331.1301 > 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com > Edison, NJ 08837 | http://www.enterprisedb.com/ >