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.klaver@aklaver.com