| View previous topic :: View next topic |
| Author |
Message |
ONEEYEMAN
Advocate
Joined: 01 Mar 2005
Posts: 3657
|
 Posted: Mon Dec 23, 2024 6:16 am Post subject: Configuring PostgreSQL with unxODBC |
 |
|
Hi,
I did successfully install PostgreSQL ODBC on top of unixOODBC DM.
My configuratioon is as follows:
| Code: |
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: |
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. |
|
| Back to top |
|
 |
logrusx
Advocate
Joined: 22 Feb 2018
Posts: 2525
|
| Posted: Mon Dec 23, 2024 10:22 am Post subject: |
|
|
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 |
|
| Back to top |
|
|
|
Portage & Programming
