Sender: Hannes.Fremann@consol.de
Message-ID: <36B9749F.DBD71C56@consol.de>
Date: Thu, 04 Feb 1999 10:21:19 +0000
From: Hans-Georg Fremann <Hannes.Fremann@consol.de>
Reply-To: Hannes.Fremann@consol.de
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Problems with Access 97
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

Hi,

I'm using MS-Access 97 on a Windows 95 PC to connect 
via PostODBC 0.21 to a postgres database running on my 
Linux box.

When I connect and I'd set the MS-Access Flag dbdriverPrompt,
there seems to be no problems. The popup box to chose
a DSN file comes up and if I click OK, the SQL query
works fine.

The following Log is done:

>more psqlodbc_4293942981.log

conn=93388920, SQLDriverConnect(
in)='DRIVER={PostgreSQL};UID=hg;PWD=;DATABASE=test;CONNSETTINGS=;SHO
WSYSTEMTABLES=0;ROWVERSIONING=0;SHOWOIDCOLUMN=0;FAKEOIDINDEX=0;PROTOCOL=6.3;READONLY=0;PORT=5432;SERV
ER=192.168.228.10;DATABASE=test;', fDriverCompletion=2
Global Options: Version='06.40.0002', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, 
max_longvarchar_size=4094
                disable_optimizer=1, ksqo=1, unique_index=0,
use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings=''
conn=93388920, query=' '
conn=93388920, query='set DateStyle to 'ISO''
conn=93388920, query='set geqo to 'OFF''
conn=93388920, query='set ksqo to 'ON''
NOTICE from backend during send_query: 'NOTICE:  Unrecognized variable
ksqo
'
conn=93388920, query='select oid from pg_type where typname='lo''
    [ fetched 0 rows ]
conn=93388920,
SQLDriverConnect(out)='DRIVER={PostgreSQL};DATABASE=test;SERVER=192.168.228.10;PORT=54
32;UID=hg;PWD=;READONLY=0;PROTOCOL=6.3;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLE
S=0;CONNSETTINGS='
conn=93388920, query='select * from weather'
    [ fetched 7 rows ]
conn=93388920, SQLDisconnect

When I'd set the MS-Access Flag dbdriverNoPrompt the query doesen't
work.

I'm using the following dsn-file:

[ODBC]
DRIVER=PostgreSQL
UID=hg
CONNSETTINGS=
SHOWSYSTEMTABLES=0
ROWVERSIONING=0
SHOWOIDCOLUMN=0
FAKEOIDINDEX=0
PROTOCOL=
READONLY=0
PORT=5432
SERVER=192.168.228.10
DATABASE=test

Does anybody know if there are a few examples somewhere in the net,
or does anybody have the same problems ?
-- 
-------------------------------------------------------
Hans-Georg Fremann
ConSol GmbH                          Tel: 089/45841-131
Franziskanerstr. 38                  Fax: 089/45841-139
81669 Muenchen