RE: How to configure iodbc access to local postgres db?

>> /usr/lib/libpsqlodbc.so

>This is the driver for iODBC.

>> and
>> /usr/lib/libodbcpsql.so
>>

>This is the driver for unixODBC.

Well, not quite.

libodbcpsql.so seems to work for both unixODBC and iODBC (with a few quirks
- the iODBC 'odbctest' program segfaults when I quit, but my app, which was
essentially cloned from 'odbctest', works okay).]

libpsqlodbc.so doesn't work for iODBC at all.

To get this working, I ran the postmaster in debug mode. When using
libpsqlodbc.so under iODBC, the postmaster didn't log anything. Using
libodbcpsql.so, it reported that I needed to set the UserName parameter in .
odbc.ini, and once I did, it worked.

R o b Y a m p o l s k y
rob(dot)yampolsky(at)encodasystems(dot)com
212-303-4250 (tel)
212-688-2639 (fax)

"The information in this e-mail is intended solely for the addressee.
Access to this e-mail by anyone else is unauthorized. If you are not the
intended recipient, or believe that you have received this communication in
error, please do not print, copy, retransmit, disseminate, or otherwise use
the information. Also, please indicate to the sender that you have received
this e-mail in error, and delete the copy you received. Thank you."