Re: iODBC Postgres

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