Invalid Page Fault in PSQLODBC.DLL

Поиск
Список
Период
Сортировка
От David Zoll
Тема Invalid Page Fault in PSQLODBC.DLL
Дата
Msg-id 3A7EDD9B.73B420F7@nyscul.org
обсуждение исходный текст
Ответы Re: Invalid Page Fault in PSQLODBC.DLL  ("Johann Zuschlag" <zuschlag2@online.de>)
Список 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'

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: ODBC Installation woes
Следующее
От: Fred Yankowski
Дата:
Сообщение: build WIN32 ODBC using VC++, not Cygwin/gcc