Connction string lacks some options

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.