From: | sriparna(dot)mondal(at)ericsson(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14303: Issue in configuration of ODBC to connect PostGres |
Date: | 2016-08-30 09:49:06 |
Message-ID: | 20160830094906.15676.88789@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14303
Logged by: sriparna mondal
Email address: sriparna(dot)mondal(at)ericsson(dot)com
PostgreSQL version: 9.3.10
Operating system: CentOS release 6.7 (Final)
Description:
We are trying to configure ODBC to connect Postgre DB.
[root(at)dselilx4374 ~]# cat /etc/odbcinst.ini
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/local/lib/psqlodbcw.so
Setup = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
[root(at)dselilx4374 ~]# cat /etc/odbc.ini
------ /etc/odbc.ini file begin -----
;
; odbc.ini
;
[ODBC Data Sources]
test = PostgreSQL Test
[test]
Driver=PostgreSQL
Description=Sample PostgreSQL DSN
DSN=test
Servername=localhost
Username=postgres
Password=postgre
Database=test
ReadOnly=1
Servertype=postgres
Port=5432
FetchBufferSize=99
ServerOptions=
ConnectOptions=
Options=
ReadOnly=no
Trace=1
TraceFile=/tmp/odbc.trace
Debug=1
DebugFile=/tmp/odbc.debug
CommLog=1
[Default]
Driver = /usr/local/lib/psqlodbcw.so
[ODBC]
InstallDir = /usr/local/lib/psqlodbcw.so
------ /etc/odbc.ini file end -----
[root(at)dselilx4374 ~]# odbcinst -j
unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /etc/odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
But we are getting below error.
[root(at)dselilx4374 ~]# odbcinst -q -s
odbcinst: SQLGetPrivateProfileString failed with Unable to find component
name.
Can you pls help? Able to connect to DB using 'psql'.
Thanks,
Sriparna
From | Date | Subject | |
---|---|---|---|
Next Message | Karl O. Pinc | 2016-08-30 13:00:47 | Re: [BUGS] BUG #14299: initdb and man pages are not installed in the alternatives system |
Previous Message | Devrim Gündüz | 2016-08-30 08:32:54 | Re: BUG #14298: service upgrade not setting ports |