Skip site navigation (1) Skip section navigation (2)

Unknown connect option while using IDL

From: Stefan Armbruster <sarmbruster(at)web(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Unknown connect option while using IDL
Date: 2001-11-21 15:01:43
Message-ID: E166YtB-0007Md-00@smtp.web.de (view raw or flat)
Thread:
Lists: pgsql-odbc
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 .odbc.ini used is:
<snip>
[ODBC Data Sources]
PostgreSQL=PostgreSQL 7.1.3
 
[PostgreSQL]
Driver=/home/stefan/packages/postgresql-7.2b2/src/interfaces/odbc/libpsqlodbc.so
Description    = PostgreSQL
Database    = testdb
Servername     = db01
UserName    = bi
Password    = pw
 
[ODBC]
Trace=1
TraceFile=odbctrace.out
TraceDll=/home/stefan/packages/idl/idl_5.5/bin/bin.linux.x86/dm/lib/odbctrac.so
InstallDir=/home/stefan/packages/idl/idl_5.5/bin/bin.linux.x86/dm
</snip>
The tracefile "odbctrace.out" is attached.
So I need a driver that does not cause the error above and is capable of 
handling large text fields.

Thanks in advance
Stefan

Attachment: odbctrace.out
Description: text/plain (3.4 KB)

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-11-22 00:20:07
Subject: Re: Unknown connect option while using IDL
Previous:From: Endys LabarcaDate: 2001-11-20 14:33:32
Subject: Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group