Skip site navigation (1) Skip section navigation (2)

postgres odbc ms-project invalid page fault

From: jenny(at)infogenic(dot)net
To: pgsql-odbc(at)postgresql(dot)org
Cc: jenny(at)infogenic(dot)net
Subject: postgres odbc ms-project invalid page fault
Date: 2001-10-30 17:59:38
Message-ID: OF80534EC8.E3DFBB8B-ON86256AF5.0061A12F@infogenic.net (view raw or flat)
Thread:
Lists: pgsql-odbc
Summary:
I am trying to set up an ODBC data source for MS Project,
which uses the latest Postgres running on linux.  Connecting
to postgres works, and many of the MS-Project tables do get
copied in correctly; however, then it crashes with an
invalid page fault and closes MS-Project.

Here's a description of everything I've tried so far.  Also,
my driver log files are attached to this message as well.

Details:
I downloaded the latest postgres and installed it today; it
works great via JDBC on another system, so I have no doubts
of that setup.  After some initial troubles with the windows
driver manager, I set up pg_hba.conf to trust pretty much
everything on our network; that let it connect.  I then got an
error about object type 'lo' which I learned was large objects,
and I ran the following SQL on the relevant database, to create
its type:

create type lo (
 internallength=4, externallength=10,
 input=int4in, output=int4out,
 default='', passedbyvalue
);

My intent was to load an existing MS-Project file (with lots
of info already in it) and do a Save As to the odbc data source
that is postgres.  Once I got security and 'lo' set up, it seemed
happy to be saving there.

It got most of the way through saving (80% or more), and I can
see the resulting tables in postgres.  However, it then crashed in
Windows with an invalid page fault; the 'Details' info is as follows.

What do I need to do to get around this error?  Is it a problem with
the odbc driver, or something else?

I've tried cleaning out the database tables, rebooting, and doing
the whole process again from a clean boot; it crashes very
consistently at the same place every time.  The Project status
bar has just finished saying 'Verifying tables' and is switching
to 'Saving project'.

WINPROJ caused an invalid page fault in
module PJ9OD9.DLL at 0167:2d8a1917.
Registers:
EAX=00000000 CS=0167 EIP=2d8a1917 EFLGS=00010246
EBX=00000000 SS=016f ESP=0062605c EBP=00626060
ECX=c157b930 DS=016f ESI=00471054 FS=0e67
EDX=004f7810 ES=016f EDI=ffffffff GS=0000
Bytes at CS:EIP:
8b 10 8d 40 04 8b ca 81 ea 01 01 01 01 33 d1 81
Stack dump:
c157b930 00626074 2d8a18d3 00000000 004d8c10 00471054 006260b0 2d8d2d11
00000000 00000000 00471054 ffffffff 00000000 00000000 004c2240 2d8d282e



(See attached file: mylog_4294836925.log)(See attached file:
psqlodbc_4294836925.log)


Attachment: psqlodbc_4294836925.log
Description: application/octet-stream (34.3 KB)
Attachment: mylog_4294836925.log
Description: application/octet-stream (266.1 KB)

pgsql-odbc by date

Next:From: Randall PerryDate: 2001-10-30 18:15:53
Subject: Re: Access Bound Checkbox error for boolean field
Previous:From: Christian Dirk Samaniego RevillaDate: 2001-10-30 17:27:15
Subject: Problems to download ODBC Driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group