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

Re: iODBC Postgres

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: iODBC Postgres
Date: 2001-04-13 01:58:59
Message-ID: 20010412205859.B24506@lerami.lerctr.org (view raw or flat)
Thread:
Lists: pgsql-odbc
I'm having similar issues talking from StarOffice 5.2 on a FreeBSD box
(under LINUX Emulation)...

Can someone who has these two talking on a real RH linux box send me
the appropriate incantations?

LER

* Shawn Bisgrove <shawn_bisgrove(at)yahoo(dot)com> [010412 06:59]:
> 
> 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.
-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

pgsql-odbc by date

Next:From: qspengDate: 2001-04-13 02:16:23
Subject: sorry, it's a test
Previous:From: Hiroshi InoueDate: 2001-04-13 01:43:34
Subject: Re: New ODBC psqlodbc-07_01_0004.zip

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