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

iODBC Postgres

From: Shawn Bisgrove <shawn_bisgrove(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: iODBC Postgres
Date: 2001-04-12 11:55:28
Message-ID: 20010412115528.36207.qmail@web11205.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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(at)partech(dot)com
|http://www.geocities.com/shawn_bisgrove


---------------------------------
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.

Responses

pgsql-odbc by date

Next:From: Keith ToddDate: 2001-04-13 01:26:46
Subject: New ODBC psqlodbc-07_01_0004.zip
Previous:From: Shawn BisgroveDate: 2001-04-12 11:50:39
Subject: iODBC

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