Re: [HACKERS] Issue in Mapping varchar datatype of Postgre to Oracle

2006-03-29 Thread Jonah H. Harris
Here's my configuration which works just fine (using unixODBC). The postgres database was created UTF-8. Software: - SuSE 10 - PostgreSQL 8.1.3 - Oracle10g XE - psqlODBC 07.03.0260 (make sure to compile --with-unixODBC) - unixODBC 2.2.11 My /etc/unixODBC/odbcinst.ini: [PostgreSQL] Description =

Re: [HACKERS] Issue in Mapping varchar datatype of Postgre to

2006-03-29 Thread Simon Riggs
On Wed, 2006-03-29 at 11:02 +0530, [EMAIL PROTECTED] wrote: > CAUSE DETERMINATION > > VARCHAR datatype from PostgreSQL is translated by your ODBC driver in > an unsupported datatype for HSODBC. > > > CAUSE JUSTIFICATION > > In the trace file, you ge

Re: [HACKERS] Issue in Mapping varchar datatype of Postgre to Oracle

2006-03-29 Thread Joerg Hessdoerfer
Hi, On Wednesday 29 March 2006 07:32, [EMAIL PROTECTED] wrote: > Hi > > We are trying to fetch records from Postgre Tables. > > We are successfully able to build connectivity. We are Using Postgre ODBC > Driver (Unicode). > > But when I query the tables of Postgre it is unable to map the datatype

[HACKERS] Issue in Mapping varchar datatype of Postgre to Oracle

2006-03-28 Thread vidisha . shah
Hi We are trying to fetch records from Postgre Tables. We are successfully able to build connectivity. We are Using Postgre ODBC Driver (Unicode). But when I query the tables of Postgre it is unable to map the datatype varchar of source Table. We got following Reply from Oracle Support. -