1. Forums
  2. Support
  3. Installation
  4. Configuring psqlodbc

Configuring psqlodbc

1 post / 0 new
Log in or register to post comments
#1 Mon, 2016-07-18 15:12
endersonmaia
  • endersonmaia's picture
  • Offline
  • Last seen: 1 year 8 months ago
  • Joined: 2016-07-18

I'm trying to configure a connection to PostgreSQL via ODBC.

I've already installed the packages:

* unixodbc-2.3.4-r0
* psqlodbc-09.03.0400-r0

But when trying to configure odbcinst.ini like I do in other distributions, I'm missing the lib libodbcpsqlS.so.

Example :

[PostgreSQL]
Description	= ODBC for PostgreSQL
Driver		= /usr/lib/psqlodbcw.so
Setup		= /usr/lib/libodbcpsqlS.so
FileUsage	= 1

The file for the Driver variable, I can find with :

# apk info --who-owns /usr/lib/psqlodbcw.so 
/usr/lib/psqlodbcw.so is owned by psqlodbc-09.03.0400-r0

But I can't find the file for Setup :

# apk info -L unixodbc
unixodbc-2.3.4-r0 contains:
etc/odbc.ini
etc/odbcinst.ini
usr/bin/isql
usr/bin/slencheck
usr/bin/dltest
usr/bin/odbcinst
usr/bin/iusql
usr/bin/odbc_config
usr/lib/libodbc.so.2
usr/lib/libodbcinst.so.2
usr/lib/libodbcinst.so.2.0.0
usr/lib/libodbccr.so.2
usr/lib/libodbccr.so.2.0.0
usr/lib/libodbc.so.2.0.0

As I can find in other distros at the unixODBC package.