Problem with Oracle, ODBC and Postgresql

------_=_NextPart_001_01C9AED9.BBD10E2B
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Summarizing:

I have a dump of postgress data I must migrate to Oracle (a really =
complex project...really). The process must be iterative and repeatedly.

=20

The OS are linux for Oracle and odbc machines and postgresql is in =
windows.

=20

For this objective I want to access from oracle to postgresql via =
heterogeneous services and odbc. This integration, theoretically simple, =
cause problems in both sides.

=20

The oracle part was through dg4odbc and unixODBC.

=20

I use the standard driver for odbcposgres included in unixODBC =
"/usr/lib/libodbcpsql.so" (with isql I can connect to postgresql through =
unixodbc). But with dg4odbc an error affecting the types of SQLGetInfo =
arises.

=20

I am trying to build the last driver of psqlodbc-08-08-0400 but I obtain =
conflicts with installation of unixODBC.

=20

I try to avoid them renaming the with-unixodbc clauses, but I obtain =
more errors.

=20

Some idea?

=20

Ra=FAl

=20


------_=_NextPart_001_01C9AED9.BBD10E2B
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

charset=3Diso-8859-1">
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

Re: Problem with Oracle, ODBC and Postgresql

Hi.

----- Original Message -----
From: "Raul Orduna"

> I am trying to build the last driver of psqlodbc-08-08-0400 but I obtain conflicts
> with installation of unixODBC.

Please setup the odbc.ini
(for example.)
Driver = /usr/home/saito/PSQLODBC/psqlodbc/.libs/psqlodbcw.so

> I try to avoid them renaming the with-unixodbc clauses, but I obtain more errors.

What thing is an errors?

Regards,
Hiroshi Saito


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Problem with Oracle, ODBC and Postgresql

------_=_NextPart_001_01C9B117.4884AF59
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C9B117.4884AF59"


------_=_NextPart_002_01C9B117.4884AF59
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Finally I build the 08.03.0400 version of the postgress driver for ODBC but=
now I have a problem.

=20

From unixODBC I tried to use the new driver and I obtain the error attached.

=20

In the logs the error seems that the driver don't find other library of pgs=
ql.

"/usr/local/pgsql/lib/libpq.so.5.1"

=20

I check the privileges and I put the postgres lib directory in the path but=
the error is the same.

=20

Any idea? With this driver is always necessary to intall a postgresql servi=
ce?? (the final connection must be remote through unixODBC)

=20

Ra=FAl

=20

=20


------_=_NextPart_002_01C9B117.4884AF59
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">