[unixODBC-support] [Spam 3.00] Re: unixODBC not working with psqlodbc 08.04.0200 on Linux x64

Luke Coldiron luke at cedarstump.com
Sun Feb 14 20:26:42 GMT 2010

Nick Gorham wrote:
> Luke Coldiron wrote:
>> I am trying to get unixODBC version 2.2.12 to work with psqlodbc 
>> version 08.04.0200.  Has anyone been able to get this to work?  I am 
>> running on Linux x64.  I could not get unixODBC version 2.2.14 or 
>> 2.2.15pre to compile but I was able to get 2.2.12 to compile.  I can 
>> connect to my Postgres 8.4.2 database using the Postgres 7.1 driver 
>> that comes with unixODBC but I am not able to with the psqlodbc 
>> 08.04.0100 or 08.04.0200 drivers.  These are the only others that I 
>> tried.  I tried turning on sql logging but it does not seem to get to 
>> the point where it actually logs anything.  So I am wondering if 
>> there is anything that I have overlooked in theory that would prevent 
>> the psqlodbc driver from working with unixODBC.  Any help would be 
>> much appreciated.
>> Luke
>> _______________________________________________
>> unixODBC-support mailing list
>> unixODBC-support at mailman.unixodbc.org
>> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
> Hi,
> Not that I can think of, did you build the postgres drivers with the 
> --with-unixODBC flag so it used the ini libs?
I went ahead and re-compiled again to see if I forgot that, its possible 
I did.
> The only area of problem is/was with the size of unicode characters, 
> but I think thats resolved now.
> What problem was there getting2.2.15pre to compile?
I tried it again and it worked this time.  Go figure, I must have not 
had a clean dist to start from. Oh, wait:

When I compile the psqlodbc driver with unixODBC 2.2.15pre I am getting 
an error.

../configure --enable-static --enable-unicode=no 

../odbcapi.c: At top level:
../odbcapi.c:1115: error: expected declaration specifiers or '...' 
../odbcapi.c:1120: error: conflicting types for 'SQLExtendedFetch'
/usr/local/include/sqlext.h:1927: error: previous declaration of 
'SQLExtendedFetch' was here
../odbcapi.c: In function 'SQLExtendedFetch':
../odbcapi.c:1133: error: 'pcrow' undeclared (first use in this function)
../odbcapi.c:1133: error: (Each undeclared identifier is reported only once
../odbcapi.c:1133: error: for each function it appears in.)

Any ideas? I would like to use the lastest of both driver if possible.

However compiling psqlodbc with unixODBC 2.2.12 I do not get an error.
And now that I tried it again I able able to get a connection via isql.  
I used the -v and it told me I didn't give it a password. After I 
supplied the password all was good. I tried both the ANSI and Unicode 
versions of the psqlodbc driver and they both seemed to connect properly.
> Does the driver you are trying to use need the postgres client libs?
It does, It should be picking them up from my LD_LIBRARY_PATH that I 
have defined.
> Do you get any error back when you use
> isql -v dsn
> The -v enables displaying errors.
> ------------------------------------------------------------------------
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 9.0.733 / Virus Database: 271.1.1/2687 - Release Date: 02/13/10 23:35:00

More information about the unixODBC-support mailing list