From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Stefan Armbruster <sarmbruster(at)web(dot)de> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Unknown connect option while using IDL |
Date: | 2001-11-22 00:20:07 |
Message-ID: | 3BFC44B7.D701688D@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-11-22 02:16:49 | Re: Server Side Cursors. |
Previous Message | Stefan Armbruster | 2001-11-21 15:01:43 | Unknown connect option while using IDL |