Re: Connction string lacks some options

On 07/03/2014 07:03 AM, matevzm wrote:
> 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

A common template for Postgres seems to be:

http://www.unixodbc.org/odbcinst.html

[PostgreSQL]
Description = Test to Postgres
Driver = /usr/local/lib/libodbcpsql.so
Trace = Yes
TraceFile = sql.log
Database = nick
Servername = localhost
UserName =
Password =
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =

Given you are on Postgres 9.3 you could use Protocol 7.4.
See if the above supplies the needed options.

> 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.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com