| 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: 2522
|
| Posted: Mon Dec 23, 2024 10:22 am Post subject: |
|
|
At a first glance, the default port is 5432.
Also there's psql cli client, you don't need odbc for that.
Best Regards,
Georgi |
|
| Back to top |
|
|
|
Portage & Programming
