i cannot use odbc with postgresql in linux

This is a multi-part message in MIME format.
--------------050605020603000703050307
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

i am using ubuntu 10.04, with self compiled unixodbc 2.2.11 from ubuntu repository (its build such way that SQL WCHARS are 2 bytes long). unixodbc is then installed to /opt/unixodbc

then i install postgresql from repository and pgsqlodbc-08.03.0200 from repository and build it with ./configure --with-unixodbc=/opt/unixodbc ; make; cp .libs/psqlodbcw.so /opt/unixodbc/lib

then i create .odbc.ini entry to test database which works using psql and I do
export LD_LIBRARY_PATH=/opt/unixodbc/lib
/opt/unixodbc/bin/isql -v psqltest

result is:
[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on
SQL_HANDLE_DBC failed
[ISQL]ERROR: Could not SQLConnect

i found many messages here about this problem, but no solution yet. any idea what i can do?
i tried to use newev official version (08.04.200), cvs version from http://pgfoundry.org/scm/?group_id=1000125, but result was always the same

i did the same things with mysql and their odbc driver and it works such way. i can use it both with isql and other programs. so i guess that how i build driver is not problem...or am i doing something
really wrong?

--

i tried to post this message using google groups but it seems it didn't got through. if it would be posted twice i am sorry...


--------------050605020603000703050307
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

i am using ubuntu 10.04, with self compiled unixodbc 2.2.11 from ubuntu repository (its build such way that SQL WCHARS are 2 bytes long). unixodbc is then installed to /opt/unixodbc



then i install postgresql from repository and pgsqlodbc-08.03.0200 from repository and build it with .
 class="moz-txt-slash">/configure --with-unixodbc=/opt
 class="moz-txt-tag">/unixodbc ; make; cp .libs/psqlodbcw.so /opt/unixodbc/lib



then i create .odbc.ini entry to test database which works using psql and I do

export LD_LIBRARY_PATH=/opt/unixodbc/lib

/opt/unixodbc/bin/isql -v psqltest



result is:

[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on

SQL_HANDLE_DBC failed

[ISQL]ERROR: Could not SQLConnect



i found many messages here about this problem, but no solution yet. any idea what i can do?

i tried to use newev official version (08.04.200), cvs version from
 class="moz-txt-link-freetext"

 href="http://pgfoundry.org/scm/?group_id=1000125"> http://pgfoundry.org/scm/?group_id=1000125, but result was always the same



i did the same things with mysql and their odbc driver and it works such way. i can use it both with isql and other programs. so i guess that how i build driver is not problem...or am i doing something

really wrong?



--



i tried to post this message using google groups but it seems it didn't got through. if it would be posted twice i am sorry...