Configuring PostgreSQL with unxODBC

[ONEEYEMAN]

Hi,
I did successfully install PostgreSQL ODBC on top of unixOODBC DM.

My configuratioon is as follows:

Code: Select all

IgorsGentoo /home/igor/dbhandler_new/Debug # cat /etc/unixODBC/odbcinst.ini 
[PostgreSQL]
Description=PostgreSQL drver
Driver=/usr/lib64/psqlodbcw.so

IgorsGentoo /home/igor/dbhandler_new/Debug # cat /etc/unixODBC/odbc.ini 
[Postgres Test]
Driver=PostgreSQL
Server=localhost
PORT=3306
DATABASE=draft
OOPTION=3
USER=postgres
PASSWORD=********

Trying to connect I'm getting:

Code: Select all

IgorsGentoo /home/igor/dbhandler_new/Debug # isql -v postgres
[IM002][unixODBC][Driver Manager]Data source name not found and no default driver specified
[ISQL]ERROR: Could not SQLConnect

Thank you.

[logrusx]

At a first glance, the default port is 5432.

Also, have you need to disable minimal use flag if you haven't done so.

Also there's psql cli client, you don't need odbc for that.

Best Regards,
Georgi