iODBC Postgres - Mailing list pgsql-odbc

I am currently using the odbc interface that is included with postgres 7.1rc4 and iODBC 3.0.4.   I am also using the test odbc program from iODBC 2.5.0.3.  When I supply a dsn=Test where Test corresponds to an entry in my /usr/local/etc/odbc.ini file

; odbc.ini
;
[ODBC Data Sources]
Test = A test database

[Test]
Driver = /usr/local/pgsql/lib/libpsqlodbc.so
Description = test postgres database
Host = kermit
ServerType = sun4u
Port = 5432
Database = bisgrove
ReadOnly = 0
TraceFile = /tmp/odbc.trace
Trace = 1
DebugFile = /tmp/odbc.debug

Debug = 1
CommLog = 1

, the odbc manager finds that entry and utilizes the appropriate postgres odbc .so file.  However, the log looks like:

onn=148464, SQLDriverConnect( in)='DSN=test', fDriverCompletion=1
DSN info: DSN='test',server='',port='',dbase='',user='',passwd=''
          onfiltered='',protocol='',showoid='',fakeoidindex='',showsystable=''
          conn_settings=''
          translation_dll='',translation_option=''

However when I run it with "DSN=Test;HOST=kermit;PORT=5432;DATABASE=bisgrove;SERVER=kermit;UID=bisgrove" everything seems to work out fine and the log file looks like:

conn=148464, SQLDriverConnect( in)='DSN=Test;HOST=kermit;PORT=5432;DATABASE=bisgrove;SERVER=kermit;UID=bisgrove', fDriverCompletion=1
DSN info: DSN='Test',server='kermit',port='5432',dbase='bisgrove',user='bisgrove',passwd=''
          onfiltered='',protocol='',showoid='',fakeoidindex='',showsystable=''
          conn_settings=''
          translation_dll='',translation_option=''
Global Options: Version='07.01.0004', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
 &! nbsp;              extra_systable_prefixes='dd_;', conn_settings=''
conn=148464, query=' '
conn=148464, query='set DateStyle to 'ISO''
conn=148464, query='set geqo to 'OFF''
conn=148464, query='set ksqo to 'ON''
conn=148464, query='select oid from pg_type where typname='lo''
    [ fetched 0 rows ]
conn=148464, query='select version()'
    [ fetched 1 rows ]
    [ PostgreSQL version string = 'PostgreSQL 7.1rc4 on sparc-sun-solaris2.6, compiled by GCC 2.95.2' ]
    [ PostgreSQL version number = '7.1' ]
conn=148464, SQLDriverConnect(out)='DSN=Test;DATABASE=bisgrove;SERVER=kermit;PORT=5432;UID=bisgrove;PWD=;READONLY=1;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=148464, SQLDisconnect

Has anyone experienced this and if so, is there a work around?

s.

 

________________________________________
|shawn_bisgrove@partech.com
|http://www.geocities.com/shawn_bisgrove