Re: How to configure iodbc access to local postgres db? - Mailing list pgsql-general

From Rob Yampolsky
Subject Re: How to configure iodbc access to local postgres db?
Date
Msg-id 3AE49298.DF98A63D@encodasystems.com
Whole thread Raw
In response to How to configure iodbc access to local postgres db?  (Rob Yampolsky <ryampols@cjds.com>)
List pgsql-general
Told you it was something stupid.  Turns out I was using the wrong
Postgres ODBC driver.  My MDK 7.2 installation had 2 things that looked
like the driver.

/usr/lib/libpsqlodbc.so
and
/usr/lib/libodbcpsql.so

The correct one seems to be libodbcpsql

I had tried both, and originally using libodbcpsql caused a segmentation
violation, so I had been concentrating my efforts on the other one.

Well, I ended up following the setup instructions in the unixODBC package
documentation to get it working under that package.  Once it worked
there, I was able to get it working with libiodbc (which my application
was using).

Hint- it wants you to specify a UserName in .odbc.ini (you'd think it
would default to the 'current user').

Thanks for listening,
Rob


pgsql-general by date:

Previous
From: Toy
Date:
Subject: general storage question
Next
From: Nils Zonneveld
Date:
Subject: Re: Newbie struggling to set $PGDATA