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,
>It can only display the error the driver returns, so not more details.
>What is in your odbc.ini for the pgdb-cr entry?
>I would expect a
>database=dbname
>to direct the driver to the correct database.