Invalid Page Fault in PSQLODBC.DLL

From: "David Zoll" <dzoll(at)nyscul(dot)org>
To: pgsql-odbc(at)postgresql(dot)org
Cc: julia(at)postgresql(dot)org
Subject: Invalid Page Fault in PSQLODBC.DLL
Date: 2001-02-05 17:06:35
Message-ID: 3A7EDD9B.73B420F7@nyscul.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


Whenever I try to access a Postgresql database from Visual Basic 6.0
with a Data Control or a Remote Data Control, the program crashes with
an invalid page fault error such as the one below.

USER caused an invalid page fault in
module PSQLODBC.DLL at 0247:10012923.
Registers:
EAX=00000090 CS=0247 EIP=10012923 EFLGS=00010297
EBX=00000088 SS=024f ESP=0063f5e4 EBP=00000000
ECX=00000028 DS=024f ESI=02cd7b8c FS=689f
EDX=00010022 ES=024f EDI=00000022 GS=0000
Bytes at CS:EIP:
8b 68 10 85 ed 7e 55 c6 44 24 20 01 55 57 68 90
Stack dump:
01eb092c 01eb028c 0063f62c 00000000 00000000 00000000 00000000
1f7e0fe2 02cd7b00 00010022 00000007 00000000 00000000 0063f676 0063f7bc
00000000

The server is Postgresql 7.0.2 running on Debian Woody. The same
problem appears with the psqlodbc.dll versions 6.50.0000 from
ftp.postgresql.org and version 7.01.00.01 from Great Bridge.

Accessing a non-psqlodbc DSN with the same data in the same table with
the exact same controls and settings works fine.

Below is the log file generated by the Great Bridge version of the
driver, using the Remote Data Control. I can post the other logs as
well if they would be useful, but they are quite similar, and they all
end after the last column is listed in the SQLColumns section.

Is there a bug in the driver, or am I doing something wrong? I would be
more than happy to do any further tests neeeded (I have both cygwin and
a full Visual Studio 6.0 installation on this machine).

Thank you very much in advance.

Sincerely,
-David Zoll, Programmer
NYS Credit Union League

-----

conn=103415928, SQLDriverConnect( in)='DSN=Testdb;PWD=;',
fDriverCompletion=3
DSN info:
DSN='Testdb',server='sqltest1',port='5432',dbase='testdb',user='dzoll',passwd=''

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='07.01.0001', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=0, ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=0, unknowns_as_longvarchar=0,
bools_as_char=0
extra_systable_prefixes='dd_;', conn_settings=''
conn=103415928, query=' '
conn=103415928, query='set DateStyle to 'ISO''
conn=103415928, query='set ksqo to 'ON''
conn=103415928, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=103415928, query='select version()'
[ fetched 1 rows ]
[ PostgreSQL version string = 'PostgreSQL 7.0.3 on
i586-pc-linux-gnu, compiled by gcc 2.95.2' ]
[ PostgreSQL version number = '7.0' ]
conn=103415928,
SQLDriverConnect(out)='DSN=Testdb;DATABASE=testdb;SERVER=sqltest1;PORT=5432;UID=dzoll;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=103415928, query='select * from tbl_cu_base'
[ fetched 672 rows ]
conn=103415928, query='select u.usename, c.relname, a.attname,
a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull,
c.relhasrules from pg_user u, pg_class c, pg_attribute a, pg_type t
where u.usesysid = c.relowner and c.oid= a.attrelid and a.atttypid =
t.oid and (a.attnum > 0) and c.relname like 'tbl_cu_base' order by
attnum'
[ fetched 40 rows ]
SQLColumns:
table='tbl_cu_base',field_name='charter_no',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='rt_number',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='cuna_id',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='census_track_nbr',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='fomfcc_code',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='axis_id',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='cu_name',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='cu_contact',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='contact_title',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='tel_areacode',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='tel_prefix',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='tel_suffix',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='tel_ext',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='altel_areacode',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='altel_prefix',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='altel_suffix',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='altel_ext',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='fax_areacode',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='fax_prefix',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='fax_suffix',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='fax_broadcast',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='phys_addr1',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='phys_addr2',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='phys_city',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='phys_state',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='phys_zip',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='phys_zip4',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='mail_addr1',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='mail_addr2',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='mail_city',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='mail_state',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='mail_zip',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='mail_zip4',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='county',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='district_code',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='region_code',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='seg',type=1042,sqltype=103025040,name='bpchar'
SQLColumns:
table='tbl_cu_base',field_name='cong_district',type=1700,sqltype=103025040,name='numeric'
SQLColumns:
table='tbl_cu_base',field_name='senate_district',type=1700,sqltype=103025040,name='numeric'
SQLColumns:
table='tbl_cu_base',field_name='assembly_district',type=1700,sqltype=103025040,name='numeric'

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Peter Eisentraut 2001-02-05 19:06:28 Re: build WIN32 ODBC using VC++, not Cygwin/gcc
Previous Message Fred Yankowski 2001-02-05 17:04:05 build WIN32 ODBC using VC++, not Cygwin/gcc