[unixODBC-support] [Spam 3.00] Re: unixODBC not working with psqlodbc 08.04.0200 on Linux x64
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.
>> unixODBC-support mailing list
>> unixODBC-support at mailman.unixodbc.org
> 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
> 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
../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
> 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