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!

Oracle 11g dg4odbc OpenLink postgres odbc driver for Linux... Integer issue

Kodali.SSep 29 2010 — edited Oct 7 2010

We were using scuccessfully the openlink driver for postgres odbc driver to connect oracle and postgres in solaris and oracle 10g hsodbc

we are migrating to Linux Oracle 11g and installed linux psotgres odbc driver and configured oracle 11g dg4odbc gateway.

We could connect from oracle and retrive the data from postgres.

Issue we have is

The integer data is not showing correctly…
For example in the postgres the value is 1 and in oracle its shown as 4294967297.

thanks,
Sirisha

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2010

Added on Sep 29 2010

#heterogeneous-connectivity

21 comments

2,347 views