Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client
От | Nick Gorham |
---|---|
Тема | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client |
Дата | |
Msg-id | 55A90B50.6080601@lurcher.org обсуждение исходный текст |
Ответ на | Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client ("Stefan Viljoen" <viljoens@verishare.co.za>) |
Ответы |
Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client
|
Список | pgsql-odbc |
On 17/07/15 14:02, Stefan Viljoen wrote: > Hi Nick > > Here is my odbc.ini entry for the pgdb-cdr data source: > > --- > [pgdb-cdr] > Driver = /usr/pgsql-9.4/lib/psqlodbc.so > ServerName = localhost > Port = 5432 > UserName = dbuser > Password = dbpassword > Database = dbname > ReadOnly = No > Protocol = 9.4 > Trace = No > TraceFile = sql.log > ConnSettings = > --- > > I have tried to > > - Replace ServerName with 127.0.0.1 and ::1 > - Changing the protocol to 9.3, 9.2., 9.1 > - Making ReadOnly yes > - Deliberately mis-spelling the Database name but the error remains the same > > - Omitting the password, error remains the same > - Removing the port, error remains the same. > > The only thing I can conclude at this point is that 9.4 Postgres ODBC driver > is in fact incompatible with the Centos 6.5 ODBC package version? > > As far as I can tell isql does not get any response from Postgres ODBC > driver - given that I can corrupt the pgdb-cdr entry however I like, even > severe errors or gaps in it is just ignored and the same error is returned > each time. > > I have run strace on isql and I can see that it DOES parse the above file > though - so I'm reasonable sure that the 9.4 Postgres driver is completely > incompatible with the ODBC version supplied with Centos 6.5? > > Again, THANK YOU for your assistance :) > > Kind regards, Another thing to check is that the driver is reading the same ini file as the driver manager. What error do you get from isql -v pgdb-cdr dbuser password It may be the driver (the folks on this list will know better that I do) is reading the ini file itself, so it may be lookingelsewhere (instead of using the libodbcinst.so helper lib). Try setting export ODBCINI=/path/to/odbc.ini That may help. also try removing the white space before and after the = [pgdb-cdr] Driver=/usr/pgsql-9.4/lib/psqlodbc.so ServerName=localhost Port=5432 UserName=dbuser Password=dbpassword Database=dbname ReadOnly= No Protocol=9.4 Trace=No TraceFile=sql.log ConnSettings= -- Nick
В списке pgsql-odbc по дате отправления: