PSQLODBC

From: "Jose' Soares" <jose(at)sferacarta(dot)com>
To: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: PSQLODBC
Date: 1998-11-03 10:01:38
Message-ID: 363ED482.134D2DF3@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi,

I have this problem using MSACCESS and PSQLODBC:
--------------------------------------------------------
MSACCESS raised an invalid page error on PSQLODBC.DLL
module in 0137:03938831.
Registers:
EAX=03510001 CS=0137 EIP=03938831 EFLGS=00010246
EBX=0351185c SS=013f ESP=0062e558 EBP=0062e57c
ECX=00000000 DS=013f ESI=039964e8 FS=28d7
EDX=03511d90 ES=013f EDI=00000001 GS=0000
Bytes at address CS:EIP:
8b 06 85 c0 74 4f 56 50 e8 d2 e1 ff ff 83 c4 08
Stack's image:
03511a5c 6a98303d 039964e8 00000001 00d00000 03511614 1b481050 00000000
00000000 0062e5d8 6a982f71 03511a5c 00000001 00000010 00c9dac4 03511614
------------------------------------------------
This is my log:
----------PSQLODBC.LOG------------------
conn=86835320, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=;DATABASE=hygea;Marco;PWD=;',
fDriverCompletion=1
DSN info:

DSN='PostgreSQL',server='verde',port='5432',dbase='hygea',user='marco',passwd=''

readonly='0',protocol='',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='set ksqo to 'on';'
translation_dll='',translation_option=''
conn=86835320,

SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=hygea;SERVER=verde;PORT=5432;UID=marco;PWD=;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=1;SHOWSYSTEMTABLES=0;CONNSETTINGS=set+ksqo+to+%27on%27%3b'
Global Options: Version='06.30.0250', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings='

'
conn=86835320, query=' '
conn=86835320, query='set DateStyle to 'ISO''
conn=86835320, query='set geqo to 'OFF''
conn=86835320, query='

'
conn=86835320, query='set ksqo to 'on''
conn=86835320, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=86835320, query='SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: msysconf: Table does not
exist.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error
while
executing the query'

------------------------------------------------------------
hdbc=86835320, stmt=86849812, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT Config, nValue
FROM
MSysConf'
stmt_with_params='SELECT Config, nValue FROM MSysConf'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0,
cursor_type=0,
scroll_concurrency=1
cursor_name='SQL_CUR052D3914'
----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=10, errmsg='ERROR:
msysconf: Table does not exist.'

------------------------------------------------------------
henv=87887764, conn=86835320, status=1, num_stmts=16
sock=87887780, stmts=87883908, lobj_type=-999
---------------- Socket Info
-------------------------------
socket=58, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=86841612, buffer_out=86845712
buffer_filled_in=42, buffer_filled_out=0, buffer_read_in=42
conn=86835320, query='SELECT "codice" ,"nome_usl" ,"nome_distretto"
,"istat" ,"indirizzo" FROM "distretti" WHERE
NOT(("ordine_presentazione" = '' ) ) ORDER BY "ordine_presentazione" '
[ fetched 3 rows ]
conn=86920344, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=;DATABASE=hygea;Marco;PWD=;',
fDriverCompletion=1
DSN info:

DSN='PostgreSQL',server='verde',port='5432',dbase='hygea',user='marco',passwd=''

readonly='0',protocol='',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='set ksqo to 'on';'
translation_dll='',translation_option=''
conn=86920344,

SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=hygea;SERVER=verde;PORT=5432;UID=marco;PWD=;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=1;SHOWSYSTEMTABLES=0;CONNSETTINGS=set+ksqo+to+%27on%27%3b'
Global Options: Version='06.30.0250', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings='

'
conn=86920344, query=' '
conn=86920344, query='set DateStyle to 'ISO''
conn=86920344, query='set geqo to 'OFF''
conn=86920344, query='

'
conn=86920344, query='set ksqo to 'on''
conn=86920344, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=86920344, query='SELECT "ragione_sociale" FROM "utenti" WHERE
("azienda" = '006SR031' ) '
[ fetched 1 rows ]
conn=86920344, query='SELECT "prestazioni"."progressivo"
,"prestazioni"."azienda" ,"prestazioni"."data"
,"prestazioni"."operatore1" ,"prestazioni"."operatore2"
,"prestazioni"."operatore3" ,"prestazioni"."n_accessi"
,"prestazioni"."in_corso" ,"risanamento"."specie"
,"risanamento"."tipo_profilassi" ,"risanamento"."generale"
,"risanamento"."capi_negativi" ,"risanamento"."capi_dubbi"
,"risanamento"."capi_positivi" FROM "prestazioni","risanamento" WHERE
((("prestazioni"."azienda" = '006SR031' ) AND
("risanamento"."progressivo" = "prestazioni"."progressivo" ) ) AND (
'01' = "risanamento"."specie" ) ) '
[ fetched 9 rows ]
conn=86920344, query='SELECT "prestazioni"."progressivo"
,"prestazioni"."azienda" ,"prestazioni"."data"
,"prestazioni"."operatore1" ,"prestazioni"."operatore2"
,"prestazioni"."operatore3" ,"prestazioni"."n_accessi"
,"prestazioni"."in_corso" ,"risanamento"."specie"
,"risanamento"."tipo_profilassi" ,"risanamento"."generale"
,"risanamento"."capi_negativi" ,"risanamento"."capi_dubbi"
,"risanamento"."capi_positivi" FROM "prestazioni","risanamento" WHERE
((("prestazioni"."azienda" = '006SR031' ) AND
("risanamento"."progressivo" = "prestazioni"."progressivo" ) ) AND (
'01' = "risanamento"."specie" ) ) '
[ fetched 9 rows ]
conn=86835320, query='SELECT

"FrmPrestazioni"."distretto","FrmPrestazioni"."progressivo","FrmPrestazioni"."specie","FrmPrestazioni"."tipo_profilassi"
FROM "risanamento" "FrmPrestazioni" WHERE (("distretto" = '' ) AND
("progressivo" = NULL ) ) '
[ fetched 0 rows ]
conn=86835320, query='SELECT "contatore" FROM "contatori" WHERE
("tipologia" = 'SOPRA' ) '
[ fetched 1 rows ]
conn=86835320, query='SELECT
"prestazioni"."distretto","prestazioni"."progressivo" FROM
"prestazioni"
WHERE ("progressivo" = 137 ) '
[ fetched 0 rows ]
conn=86835320, query='SELECT "azienda" ,"ragione_sociale" FROM
"utenti"
WHERE ("dpr317" = 'S' ) ORDER BY "ragione_sociale" '
[ fetched 765 rows ]
conn=86962288, SQLDriverConnect(

in)='DSN=PostgreSQL;UID=marco;PWD=;DATABASE=hygea;SERVER=verde;PORT=5432;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=set+ksqo+to+%27on%27%3b;',
fDriverCompletion=0
DSN info:

DSN='PostgreSQL',server='verde',port='5432',dbase='hygea',user='marco',passwd=''

readonly='0',protocol='',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='set ksqo to 'on';'
translation_dll='',translation_option=''
conn=86962288,

SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=hygea;SERVER=verde;PORT=5432;UID=marco;PWD=;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=set+ksqo+to+%27on%27%3b'
Global Options: Version='06.30.0250', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings='

'
conn=86962288, query=' '
conn=86962288, query='set DateStyle to 'ISO''
conn=86962288, query='set geqo to 'OFF''
conn=86962288, query='

'
conn=86962288, query='set ksqo to 'on''
conn=86962288, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=86962288, query='SELECT

"FrmPrestazioni"."distretto","FrmPrestazioni"."progressivo","FrmPrestazioni"."specie","FrmPrestazioni"."tipo_profilassi"
FROM "risanamento" "FrmPrestazioni" WHERE (("distretto" = 'RA10' ) AND
("progressivo" = 137 ) ) '
[ fetched 0 rows ]
conn=86962288, SQLDisconnect
conn=86962288, SQLDriverConnect(

in)='DSN=PostgreSQL;UID=marco;PWD=;DATABASE=hygea;SERVER=verde;PORT=5432;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=set+ksqo+to+%27on%27%3b;',
fDriverCompletion=0
DSN info:

DSN='PostgreSQL',server='verde',port='5432',dbase='hygea',user='marco',passwd=''

readonly='0',protocol='',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='set ksqo to 'on';'
translation_dll='',translation_option=''
conn=86962288,

SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=hygea;SERVER=verde;PORT=5432;UID=marco;PWD=;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=set+ksqo+to+%27on%27%3b'
Global Options: Version='06.30.0250', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings='

'
conn=86962288, query=' '
conn=86962288, query='set DateStyle to 'ISO''
conn=86962288, query='set geqo to 'OFF''
conn=86962288, query='

'
conn=86962288, query='set ksqo to 'on''
conn=86962288, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=86962288, query='SELECT "contatore" FROM "contatori" WHERE
("tipologia" = 'SOPRA' ) '
[ fetched 1 rows ]
conn=86962288, SQLDisconnect
conn=86962288, SQLDriverConnect(

in)='DSN=PostgreSQL;UID=marco;PWD=;DATABASE=hygea;SERVER=verde;PORT=5432;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=set+ksqo+to+%27on%27%3b;',
fDriverCompletion=0
DSN info:

DSN='PostgreSQL',server='verde',port='5432',dbase='hygea',user='marco',passwd=''

readonly='0',protocol='',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='set ksqo to 'on';'
translation_dll='',translation_option=''
conn=86962288,

SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=hygea;SERVER=verde;PORT=5432;UID=marco;PWD=;READONLY=0;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=set+ksqo+to+%27on%27%3b'
Global Options: Version='06.30.0250', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=1, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=1,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings='

'
conn=86962288, query=' '
conn=86962288, query='set DateStyle to 'ISO''
conn=86962288, query='set geqo to 'OFF''
conn=86962288, query='

'
conn=86962288, query='set ksqo to 'on''
conn=86962288, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=86962288, query='BEGIN'
conn=86962288, query='UPDATE "contatori" SET contatore=137 WHERE
("tipologia" = 'SOPRA' ) '
conn=86962288, query='COMMIT'
conn=86962288, SQLDisconnect
------------------------------------------------------------------
Any ideas ?

Thanks, Jose'

Browse pgsql-interfaces by date

  From Date Subject
Next Message Giuseppe Tanzilli 1998-11-03 12:12:26 access -> odbc 250 -> pgsql 64b5
Previous Message Sergio 1998-11-02 23:19:08 mOdbc proyect