Re: Unknown connect option while using IDL

Stefan Armbruster wrote:
>
> Hi all,
> I'm a newbie to PostgreSQL and ODBC, so I hope this question is not
> too stupid....
> We're using a tool for data analysis called IDL (nothing in common with
> Corba, btw.). It offers a ODBC interface. When trying a connection I get an
> error:
>
> IDL>  objDB = OBJ_NEW('IDLdbDatabase')
> % Loaded DLM: DATAMINER.
> IDL> objDB->Connect,datasource='PostgreSQL'
> % IDLDBDATABASE::CONNECT: ODBC Unknown connect option (Set)
> % Execution halted at: $MAIN$
> This occurs when using both, the libpsqlodbc.so from PostgreSQL 7.1.3 and
> 7.2b2.
> The package unixODBC (www.unixodbc.org) also contains a version of the
> PostgreSQL driver. When specifying this lib in .odbc.ini, the error above
> does *not* occur. But I can't use this driver because it limits the maximum
> length of text fields.

The standalone psqlodbc driver is hard to use.
In 7.2, you could specify the option --with-unixodbc
at configure time and make the driver libodbcpsql.so
for unixODBC. Note that you have to install unixODBC
to compile the driver.

regards,
Hiroshi Inoue