From: Nico Kretschmar <kretschmar@sag-gruessing.de>
To: pgsql-interfaces@postgresql.org
Subject: PostgreSQL via ODBC and Approach
Date: Mon, 11 Dec 2000 08:09:52 +0100
Message-ID: <006301c06341$5ba8ff40$6500000a@kretschmar> (raw)
Hi all,
exist any solution for the problem "PostgreSQL via ODBC and Approach" ???
I read many postings in many newsgroups, i read many questions to this
problem there, BUT i don't read a solution.
This problem is very difficult...
So i posting this problem...
When i open a odbc-source with approach 9.0 for database postgreSQL.
ODBC-Version: 6.50.0000
then can i see the login-window, i can connect to the database, i can see
the tables in the database, but when i open the table, i becomes a
message-windows:
"Database XXX can not open. (-7011)"
and then
"[MicroXXXX][ODBC Driver Manager][Driver not supported this Function]"
So I post the psqlodbc.log
cut on
------------------------------------------------------------
Global Options: Version='06.50.0000', 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
extra_systable_prefixes='dd_;', conn_settings=''
conn=57029120, query=' '
conn=57029120, query='set DateStyle to 'ISO''
conn=57029120, query='set geqo to 'OFF''
conn=57029120, query='set ksqo to 'ON''
conn=57029120, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=57029120,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=hicom;SERVER=server01;PORT=54
32;UID=kretschmar;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=
0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=57045120, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=kretschmar;PWD=;DATABASE=hicom;SERVER=server01;PORT=
5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;
SHOWSYSTEMTABLES=0;CONNSETTINGS=;', fDriverCompletion=0
DSN info:
DSN='PostgreSQL',server='server01',port='5432',dbase='hicom',user='kretschma
r',passwd=''
onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.50.0000', 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
extra_systable_prefixes='dd_;', conn_settings=''
conn=57045120, query=' '
conn=57045120, query='set DateStyle to 'ISO''
conn=57045120, query='set geqo to 'OFF''
conn=57045120, query='set ksqo to 'ON''
conn=57045120, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=57045120,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=hicom;SERVER=server01;PORT=54
32;UID=kretschmar;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=
0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
CONN ERROR: func=SQLSetConnectOption, desc='fOption=1041, vParam=1217316',
errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=57029104, conn=57045120, status=1, num_stmts=16
sock=57081920, stmts=57081968, lobj_type=-999
---------------- Socket Info -------------------------------
socket=148, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=57051456, buffer_out=57055560
buffer_filled_in=33, buffer_filled_out=0, buffer_read_in=32
conn=57029120, query='select relname, usename, relhasrules from pg_class,
pg_user where relkind = 'r' and relname !~ '^pg_|^dd_' and relname !~
'^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)order by relname'
[ fetched 10 rows ]
conn=57029120, query='select relname, usename, relhasrules from pg_class,
pg_user where relkind = 'r' and relname like 'amtsleitung' and relname !~
'^pg_|^dd_' and relname !~ '^xinv[0-9]+' and int4out(usesysid) =
int4out(relowner)order by relname'
[ fetched 1 rows ]
conn=57029120, query='select relname, usename, relhasrules from pg_class,
pg_user where relkind = 'r' and relname like 'amtsleitung' and relname !~
'^pg_|^dd_' and relname !~ '^xinv[0-9]+' and int4out(usesysid) =
int4out(relowner)order by relname'
[ fetched 1 rows ]
conn=57029120, query='select relname, usename, relhasrules from pg_class,
pg_user where relkind = 'r' and relname like 'amtsleitung' and relname !~
'^pg_|^dd_' and relname !~ '^xinv[0-9]+' and int4out(usesysid) =
int4out(relowner)order by relname'
[ fetched 1 rows ]
conn=57045120, SQLDisconnect
conn=57029120, SQLDisconnect
----------------------------------------------------------------------------
--
cut off
Can anybody help, to search a solution for this problem.
Please don't posted : "Update Lotus Approach from 9.0 to 9.5"
It's no solution!
With best regards
Nico Kretschmar
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: kretschmar@sag-gruessing.de
Subject: Re: PostgreSQL via ODBC and Approach
In-Reply-To: <006301c06341$5ba8ff40$6500000a@kretschmar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox