PSQLODBC - Mailing list pgsql-interfaces
| From | Jose' Soares |
|---|---|
| Subject | PSQLODBC |
| Date | |
| Msg-id | 363ED482.134D2DF3@sferacarta.com Whole thread Raw |
| List | 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'
pgsql-interfaces by date: