Thread: Problem with Oracle, ODBC and Postgresql
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.
The OS are linux for Oracle and odbc machines and postgresql is in windows.
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.
The oracle part was through dg4odbc and unixODBC.
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.
I am trying to build the last driver of psqlodbc-08-08-0400 but I obtain conflicts with installation of unixODBC.
I try to avoid them renaming the with-unixodbc clauses, but I obtain more errors.
Some idea?
Raúl
Hi. ----- Original Message ----- From: "Raul Orduna" <rorduna@tracasa.es> > 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
Finally I build the 08.03.0400 version of the postgress driver for ODBC but now I have a problem.
From unixODBC I tried to use the new driver and I obtain the error attached.
In the logs the error seems that the driver don't find other library of pgsql.
"/usr/local/pgsql/lib/libpq.so.5.1"
I check the privileges and I put the postgres lib directory in the path but the error is the same.
Any idea? With this driver is always necessary to intall a postgresql service?? (the final connection must be remote through unixODBC)
Raúl