Libodbcpsql.so

Asterisk Asterisk Support
1

Hi every1,
I am trying to use Asterisk 1.6.1.0 along with PostgreSQL 8.3 on ubuntu server 9.04.
I have installed postgresql server, odbc-postgresql, unixodbc, unixodbc-dev, unixodbc-bin; psqlodbc-08.03.0400 but still I got an error during '$ echo “select 1” | isql -v asterisk-connector ':

[01000][unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/odbc/libodbcpsql.so’ : file not found
[ISQL]ERROR: Could not SQLConnect

It is because I don’t have libodbcpsql.so file and I can’t find it anywhere in my system. Do you know which package contains this file ?

P.S.
I have ‘libodbcpsqlS.so’ in /usr/lib/odbc/ .

Cheers

2

and where it is going to be written ?

3

OK, I found the solution. There is no such file like libodbcpsql.so. You have to use psqlodbca.so instead.