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: (view raw or whole 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  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

Driver = /usr/local/pgsql/lib/
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=''

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=''
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, SQLDisconnect



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





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


pgsql-odbc by date

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

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