[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-ports
Subject: [PORTS] RE: How to configure iodbc access to local postgres db?
From: Rob Yampolsky <Rob.Yampolsky () encodasystems ! com>
Date: 2001-04-24 14:39:55
[Download RAW message or body]
>> /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.yampolsky@encodasystems.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."
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-2022-jp">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>RE: How to configure iodbc access to local postgres db?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>>> /usr/lib/libpsqlodbc.so</FONT>
</P>
<P><FONT SIZE=2>>This is the driver for iODBC.</FONT>
</P>
<P><FONT SIZE=2>>> and</FONT>
<BR><FONT SIZE=2>>> /usr/lib/libodbcpsql.so</FONT>
<BR><FONT SIZE=2>>> </FONT>
</P>
<P><FONT SIZE=2>>This is the driver for unixODBC.</FONT>
</P>
<P><FONT SIZE=2>Well, not quite.</FONT>
</P>
<P><FONT SIZE=2>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).]</FONT></P>
<P><FONT SIZE=2>libpsqlodbc.so doesn't work for iODBC at all.</FONT>
</P>
<P><FONT SIZE=2>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.</FONT></P> <BR>
<P><FONT SIZE=2>R o b Y a m p o l s k y</FONT>
<BR><FONT SIZE=2>rob.yampolsky@encodasystems.com</FONT>
<BR><FONT SIZE=2>212-303-4250 (tel)</FONT>
<BR><FONT SIZE=2>212-688-2639 (fax)</FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT SIZE=2>"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."</FONT></P>
</BODY>
</HTML>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic