Connction string lacks some options - Mailing list pgsql-odbc

I am having trouble making DSN for psqlodbcw.so driver.

When I try to test it with iodbctest I get error (I can connect openlink
drivers but I cannot use them because they do not support mxODBC):

Driver Manager: 03.52.0709.0909

Enter ODBC connect string (? shows list): ?

DSN                              | Driver
------------------------------------------------------------------------------
DSNana                           | psqlDriver
DSNopen                          | OpenLink PostgreSQL Lite Driver v6.0
DSNopen2                         | OpenLink PostgreSQL Lite Driver (Unicode)
v6.0

Enter ODBC connect string (? shows list): DSNana
1: SQLDriverConnect = connction string lacks some options (202)
SQLSTATE=08001

Have a nice day.

---------

*ODBC.ini*

[ODBC Data Sources]
DSNana  = psqlDriver
DSNopen = OpenLink PostgreSQL Lite Driver v6.0
DSNopen2 = OpenLink PostgreSQL Lite Driver (Unicode) v6.0


[DSNana]
Driver     = /Library/PostgreSQL/psqlODBC/lib/psqlodbcw.so
ServerName = localhost
Database   = ANA
UserName   = matevzmrak
Port       = 5432


[DSNopen]
Driver     = /Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver
v6.0.bundle/Contents/MacOS/pgr7_mt_lt.so
ServerName = localhost
Port       = 5432
Database   = ANA
Username   = matevzmrak
Debug      = 1


[DSNopen2]
Driver     = /Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode)
v6.0.bundle/Contents/MacOS/pgr7_mt_lu.so
ServerName = localhost
Port       = 5432
Database   = ANA
Username   = matevzmrak
Debug      = 1

*ODBCINST.ini*

[ODBC Drivers]
psqlDriver                                     = Installed
OpenLink PostgreSQL Lite Driver v6.0           = Installed
OpenLink PostgreSQL Lite Driver (Unicode) v6.0 = Installed

[psqlDriver]
Driver = /Library/PostgreSQL/psqlODBC/lib/psqlodbcw.so

[OpenLink PostgreSQL Lite Driver v6.0]
Driver = /Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver
v6.0.bundle/Contents/MacOS/pgr7_mt_lt.so
Setup  = /Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver
v6.0.bundle/Contents/MacOS/OpenLink PostgreSQL Lite ODBC Driver v6.0

[OpenLink PostgreSQL Lite Driver (Unicode) v6.0]
Driver = /Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode)
v6.0.bundle/Contents/MacOS/pgr7_mt_lu.so
Setup  = /Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode)
v6.0.bundle/Contents/MacOS/OpenLink PostgreSQL Lite ODBC Driver (Unicode)
v6.0

*Specs:*


Postgres server: Postgres app 9.3.4.2 (http://postgresapp.com/)
ODBC manager: iODBC Data Source Manager (OpenLink)
ODBC driver: http://www.postgresql.org/ftp/odbc/versions/src/ (latest) -
psqlodbc-09.03.0300.tar.gz
OSX version: 10.9.3
UCS: UCS2
Eclipse: Eclipse Standard/SDK - Kepler Service Release - Build id:
20140224-0627
Python: 2.7.6 - 64bit
mxBase version: egenix-mx-base-3.2.7-py2.7_ucs2-macosx-10.5-x86_64-prebuilt
mxODBC version: egenix-mxodbc-3.1.2.macosx-10.5-x86_64-py2.7_ucs2.prebuilt

Thank you for your answers.

Best regards, Matevz



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Connction-string-lacks-some-options-tp5810410.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.