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.

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=FAl

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

<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>

<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DES link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Summarizing:<o:p></o:p>

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

<o:p> </o:p>

The OS =
are linux
for Oracle and odbc machines and postgresql is in =
windows.<o:p></o:p>

<o:p> </o:p>

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.<o:p></o:p>

<o:p> </o:p>

The =
oracle part
was through dg4odbc and unixODBC.<o:p></o:p>

<o:p> </o:p>

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.<o:p></o:p>

<o:p> </o:p>

I am =
trying to
build the last driver of psqlodbc-08-08-0400 but I obtain conflicts with
installation of unixODBC.<o:p></o:p>

<o:p> </o:p>

I try =
to avoid
them renaming the with-unixodbc clauses, but I obtain more =
errors.<o:p></o:p>

<o:p> </o:p>

Some =
idea?<o:p></o:p>

<o:p> </o:p>

Raúl<o:p></o:p>

<o:p> </o:p>

</div>

</body>

</html>

------_=_NextPart_001_01C9AED9.BBD10E2B--

Hi.

----- Original Message -----
From: "Raul Orduna" <rorduna [at] 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

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

------_=_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.

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 pgs=
ql.

"/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 servi=
ce?? (the final connection must be remote through unixODBC)

Ra=FAl

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

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

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DES link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

Finally I build the 08.03.0400 version of the postgress driver =
for
ODBC but now I have a problem.<o:p></o:p>

<o:p> </o:p>

From unixODBC I tried to use the new driver and I obtain the er=
ror
attached.<o:p></o:p>

<o:p> </o:p>

In the logs the err=
or
seems that the driver don't find other library of pgsql.<o:p></o:p><=
/font>

"/usr/local/pg=
sql/lib/libpq.so.5.1"<o:p></o:p>

<o:p> </o:p></=
span>

I check the privile=
ges
and I put the postgres lib directory in the path but the error is the same.=
<o:p></o:p>

<o:p> </o:p></=
span>

Any idea? With this
driver is always necessary to intall a postgresql service?? (the final
connection must be remote through unixODBC)<o:p></o:p>

<o:p> </o:p></=
span>

Ra=F Al<o:p></o:p></=
span>

<o:p> </o:p>

<o:p> </o:p>

</div>

</body>

</html>

------_=_NextPart_002_01C9B117.4884AF59--

------_=_NextPart_001_01C9B117.4884AF59
Content-Type: application/octet-stream; name="PostgreSQL_trace.log"
Content-Transfer-Encoding: base64
Content-Description: PostgreSQL_trace.log
Content-Disposition: attachment; filename="PostgreSQL_trace.log"

W09EQkNdWzU5NjVdWzEyMzc5ODE1NTkuMDI0MjU1XVtfX2hhbmRsZXMuY11b
NDUwXQoJCUV4aXQ6W1NRTF9TVUNDRVNTXQoJCQlFbnZpcm9ubWVudCA9IDB4
ODI3ZmYxMApbT0RCQ11bNTk2NV1bMTIzNzk4MTU1OS4wMjQzNjhdW1NRTEFs
bG9jSGFuZGxlLmNdWzM2NF0KCQlFbnRyeToKCQkJSGFuZGxlIFR5cGUgPSAy
CgkJCUlucHV0IEhhbmRsZSA9IDB4ODI3ZmYxMApbT0RCQ11bNTk2NV1bMTIz
Nzk4MTU1OS4wMjQ0MTddW1NRTEFsbG9jSGFuZGxlLmNdWzQ4Ml0KCQlFeGl0
OltTUUxfU1VDQ0VTU10KCQkJT3V0cHV0IEhhbmRsZSA9IDB4ODI4MDZhMApb
T0RCQ11bNTk2NV1bMTIzNzk4MTU1OS4wMjQ0NzddW1NRTENvbm5lY3QuY11b
MzYxNF0KCQlFbnRyeTogICAgICAgICAgICAKCQkJQ29ubmVjdGlvbiA9IDB4
ODI4MDZhMCAgICAgICAgICAgIAoJCQlTZXJ2ZXIgTmFtZSA9IFtQb3N0Z3Jl
U1FMXVtsZW5ndGggPSAxMCAoU1FMX05UUyldICAgICAgICAgICAgCgkJCVVz
ZXIgTmFtZSA9IFtQT1NUR1JFUzJdW2xlbmd0aCA9IDkgKFNRTF9OVFMpXSAg
ICAgICAgICAgIAoJCQlBdXRoZW50aWNhdGlvbiA9IFsqKioqKioqKipdW2xl
bmd0aCA9IDkgKFNRTF9OVFMpXQoJCVVOSUNPREUgVXNpbmcgZW5jb2Rpbmcg
QVNDSUkgJ0lTTzg4NTktMScgYW5kIFVOSUNPREUgJ1VDUy0yTEUnCgpbT0RC
Q11bNTk2NV1bMTIzNzk4MTU1OS4wMjc5MTFdW1NRTENvbm5lY3QuY11bMTA2
M11DYW4ndCBvcGVuIGxpYiAnL3Vzci9sb2NhbC9saWIvcHNxbG9kYmNhLnNv
JyA6IGxpYnBxLnNvLjU6IGNhbm5vdCBvcGVuIHNoYXJlZCBvYmplY3QgZmls
ZTogTm8gc3VjaCBmaWxlIG9yIGRpcmVjdG9yeQpbT0RCQ11bNTk2NV1bMTIz
Nzk4MTU1OS4wMjgwMjFdW1NRTEVycm9yLmNdWzQzMF0KCQlFbnRyeTogICAg
ICAgICAgICAgICAgCgkJCUNvbm5lY3Rpb24gPSAweDgyODA2YTAgICAgICAg
ICAgICAgICAgCgkJCVNRTFN0YXRlID0gMHhiZmUzMjc1YSAgICAgICAgICAg
ICAgICAKCQkJTmF0aXZlID0gMHhiZmUzMjc2NCAgICAgICAgICAgICAgICAK
CQkJTWVzc2FnZSBUZXh0ID0gMHhiZmUzMjU2NSAgICAgICAgICAgICAgICAK
CQkJQnVmZmVyIExlbmd0aCA9IDUwMCAgICAgICAgICAgICAgICAKCQkJVGV4
dCBMZW4gUHRyID0gMHhiZmUzMjc2YQpbT0RCQ11bNTk2NV1bMTIzNzk4MTU1
OS4wMjgxMDRdW1NRTEVycm9yLmNdWzQ2N10KCQlFeGl0OltTUUxfU1VDQ0VT
U10gICAgICAgICAgICAgICAgICAgIAoJCQlTUUxTdGF0ZSA9IDAxMDAwICAg
ICAgICAgICAgICAgICAgICAKCQkJTmF0aXZlID0gMHhiZmUzMjc2NCAtPiAw
ICAgICAgICAgICAgICAgICAgICAKCQkJTWVzc2FnZSBUZXh0ID0gW1t1bml4
T0RCQ11bRHJpdmVyIE1hbmFnZXJdQ2FuJ3Qgb3BlbiBsaWIgJy91c3IvbG9j
YWwvbGliL3BzcWxvZGJjYS5zbycgOiBsaWJwcS5zby41OiBjYW5ub3Qgb3Bl
biBzaGFyZWQgb2JqZWN0IGZpbGU6IE5vIHN1Y2ggZmlsXQpbT0RCQ11bNTk2
NV1bMTIzNzk4MTU1OS4wMjg0NjhdW1NRTEVycm9yLmNdWzQzMF0KCQlFbnRy
eTogICAgICAgICAgICAgICAgCgkJCUNvbm5lY3Rpb24gPSAweDgyODA2YTAg
ICAgICAgICAgICAgICAgCgkJCVNRTFN0YXRlID0gMHhiZmUzMjc1YSAgICAg
ICAgICAgICAgICAKCQkJTmF0aXZlID0gMHhiZmUzMjc2NCAgICAgICAgICAg
ICAgICAKCQkJTWVzc2FnZSBUZXh0ID0gMHhiZmUzMjU2NSAgICAgICAgICAg
ICAgICAKCQkJQnVmZmVyIExlbmd0aCA9IDUwMCAgICAgICAgICAgICAgICAK
CQkJVGV4dCBMZW4gUHRyID0gMHhiZmUzMjc2YQpbT0RCQ11bNTk2NV1bMTIz
Nzk4MTU1OS4wMjg0NzVdW1NRTEVycm9yLmNdWzQ2N10KCQlFeGl0OltTUUxf
Tk9fREFUQV0KW09EQkNdWzU5NjVdWzEyMzc5ODE1NTkuMDI4NjI4XVtTUUxF
cnJvci5jXVs1MTBdCgkJRW50cnk6ICAgICAgICAgICAgICAgIAoJCQlFbnZp
cm9ubWVudCA9IDB4ODI3ZmYxMCAgICAgICAgICAgICAgICAKCQkJU1FMU3Rh
dGUgPSAweGJmZTMyNzVhICAgICAgICAgICAgICAgIAoJCQlOYXRpdmUgPSAw
eGJmZTMyNzY0ICAgICAgICAgICAgICAgIAoJCQlNZXNzYWdlIFRleHQgPSAw
eGJmZTMyNTY1ICAgICAgICAgICAgICAgIAoJCQlCdWZmZXIgTGVuZ3RoID0g
NTAwICAgICAgICAgICAgICAgIAoJCQlUZXh0IExlbiBQdHIgPSAweGJmZTMy
NzZhCltPREJDXVs1OTY1XVsxMjM3OTgxNTU5LjAyODY3Ml1bU1FMRXJyb3Iu
Y11bNTQ3XQoJCUV4aXQ6W1NRTF9OT19EQVRBXQpbT0RCQ11bNTk2NV1bMTIz
Nzk4MTU1OS4wMjg4MzRdW1NRTEZyZWVIYW5kbGUuY11bMjc5XQoJCUVudHJ5
OgoJCQlIYW5kbGUgVHlwZSA9IDIKCQkJSW5wdXQgSGFuZGxlID0gMHg4Mjgw
NmEwCltPREJDXVs1OTY1XVsxMjM3OTgxNTU5LjAyODg5NV1bU1FMRnJlZUhh
bmRsZS5jXVszMzBdCgkJRXhpdDpbU1FMX1NVQ0NFU1NdCltPREJDXVs1OTY1
XVsxMjM3OTgxNTU5LjAyODk0N11bU1FMRnJlZUhhbmRsZS5jXVsyMTJdCgkJ
RW50cnk6CgkJCUhhbmRsZSBUeXBlID0gMQoJCQlJbnB1dCBIYW5kbGUgPSAw
eDgyN2ZmMTAK

------_=_NextPart_001_01C9B117.4884AF59
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

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

------_=_NextPart_001_01C9B117.4884AF59--

Problem with Oracle, ODBC and Postgresql

Re: Problem with Oracle, ODBC and Postgresql

Re: Problem with Oracle, ODBC and Postgresql