CrecordSet with ODBC page faults in kernal32.dll
Stortroen Carl -- STORTROEN@corp.cmh.on.ca
Tuesday, October 01, 1996
Environment: win95, VC++ 4.1
Although I installed the patch (b) to vc4.1
when I use classwizard to create a Crecordset on a
sybase system 10 database ( I installed open/client & odbc
for win95 from sybase ) I get a page fault in kernal32.dll
in msdev when I click on a table to build the class.
My MSDEV.exe crashes.
I can ping the server...
I can open a CDatabase and send cmds to it through executeSQL
but recordsets always crash ( in odbc.dll, kernal32.dll or .exe
has anyone seen this and managed to use
CRecordSets through 32 bit odbc to a sybase system 10
database ? The net-library, odbc, and open/client are from sybase.
( I applied the b patch ) I have no Idea what to try next
Thanks....
Carl ( stortroen@ihis.cmh.on.ca)
programmer
CMH
Hamilton
Ont.
Jeff Shannon -- jshannon@southeast.net
Saturday, October 05, 1996
> Although I installed the patch (b) to vc4.1
> when I use classwizard to create a Crecordset on a
> sybase system 10 database ( I installed open/client & odbc
> for win95 from sybase ) I get a page fault in kernal32.dll
> in msdev when I click on a table to build the class.
> My MSDEV.exe crashes.
Have you tried connecting to the database via another application that uses
the same ODBC driver, like MSQuery or another query tool? You might also
want to try another ODBC driver. Doesn't Open/Client use a native
connection?
Brian Weeres -- bweeres@escape.ca
Tuesday, December 10, 1996
I have the exact problem except under NT 4.0 and Sybase System 11.
Does anyone successfully use Sybase ODBC drivers and developer
studio?
> From: "Jeff Shannon"
> To:
> Subject: Re: CrecordSet with ODBC page faults in kernal32.dll
> Date: Sat, 5 Oct 1996 03:08:37 -0400
> Reply-to: mfc-l@netcom.com
> > Although I installed the patch (b) to vc4.1
> > when I use classwizard to create a Crecordset on a
> > sybase system 10 database ( I installed open/client & odbc
> > for win95 from sybase ) I get a page fault in kernal32.dll
> > in msdev when I click on a table to build the class.
> > My MSDEV.exe crashes.
>
> Have you tried connecting to the database via another application that uses
> the same ODBC driver, like MSQuery or another query tool? You might also
> want to try another ODBC driver. Doesn't Open/Client use a native
> connection?
>
>
>
--------------------------------
Brian Weeres
Rescom Ventures Inc.
bweeres@rescom.com
Sailesh Panchal -- panchals@inteq.bhi-net.com
Friday, December 13, 1996
[Mini-digest: 2 responses]
Ditto,
VC++v4.2b, NT4.0, Sybase4.9, Sybase10.
The database has a 1058 tables
Same problem.
I have also had problems adding a tables to an existing CrecordSet.
I don't think its the drivers, because I can get a full list of table in VB.
Sailesh P.
>
> I have the exact problem except under NT 4.0 and Sybase System 11.
> Does anyone successfully use Sybase ODBC drivers and developer
> studio?
>
>
> > From: "Jeff Shannon"
> > To:
> > Subject: Re: CrecordSet with ODBC page faults in kernal32.dll
> > Date: Sat, 5 Oct 1996 03:08:37 -0400
> > Reply-to: mfc-l@netcom.com
>
> > > Although I installed the patch (b) to vc4.1
> > > when I use classwizard to create a Crecordset on a
> > > sybase system 10 database ( I installed open/client & odbc
> > > for win95 from sybase ) I get a page fault in kernal32.dll
> > > in msdev when I click on a table to build the class.
> > > My MSDEV.exe crashes.
> >
> > Have you tried connecting to the database via another application that uses
> > the same ODBC driver, like MSQuery or another query tool? You might also
> > want to try another ODBC driver. Doesn't Open/Client use a native
> > connection?
> >
> >
> >
> --------------------------------
> Brian Weeres
> Rescom Ventures Inc.
> bweeres@rescom.com
>
-----From: Mao Zhihong
Dear bweeres,
I'v ever use a Sybase ODBC driver succesfully, but that server is
runed on a IBM RS/6000 under AIX system.
Don't forget to run the script instcat.sql before you try to connect
it, ODBC driver need these stored procedures to access SQL Server. When
u setup M$ $QL $ERVER, it will automatically setup instcat.sql for you.
hope it helpful.
Yours
Mao
>I have the exact problem except under NT 4.0 and Sybase System 11.
> Does anyone successfully use Sybase ODBC drivers and developer
> studio?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Mao Zhihong DreamyRainbow Software Studio
Oooo.
( ) Voc/Fax : 86-25-5408086
) / E-Mail : maozhihong@hotmail.com mao@seu.edu.cn
(_/ URL : http://seic3.seu.edu.cn/~mao
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"We get to create only a few things in this life. We really have
such a short time here, some of us just want to make it count."
- Steven Jobs
Yves Monier -- Yves.Monier@grenoble.rxrc.xerox.com
Tuesday, December 17, 1996
[Mini-digest: 2 responses]
At 09:53 AM 12/13/96 GMT, Sailesh Panchal wrote:
>[Mini-digest: 2 responses]
>
>Ditto,
>
>VC++v4.2b, NT4.0, Sybase4.9, Sybase10.
>
>The database has a 1058 tables
>
>Same problem.
>I have also had problems adding a tables to an existing CrecordSet.
>
>I don't think its the drivers, because I can get a full list of table in VB.
>
>Sailesh P.
Environment: VC++ 4.0, NT 4.0
I had quite the same problem, working with CRecordset to access, via ODBC, an
mdb database, except that the error was an access violation in ntdll.dll.
Thanks to some people on the net, I got a workaround (you can find it on the MS
web site, knowledge base, article Q153897). Quite stange, but -at least for me-
it solved the problem...
I "just" had to override the Open method of my recordset classes. These new
Open methods :
1) call the base class Open method
2) call LoadLibrary("MSJT3032.DLL") to ensure it remains in memory during the
shutdown process - the fact is my crashes occured when I was closing or
deleting recordsets...
Hope this will help,
Yves Monier
----------------------------------------------------------------
Yves Monier Rank Xerox Research Centre
6 chemin de Maupertuis
38240 Meylan, France
From France: Tel. 04 76 61 50 10 - Fax. 04 76 61 51 99
Outside France: Tel. +33 4 76 61 50 10 - Fax. +33 4 76 61 51 99
-----From: Steve Boardman EOS
Environment: NT4.0, VC++4.2-flat.
Me too - I've had this problem with Access 7 and ODBC. I had to export
the Access table to an Excel spreadsheet
and use ClassWizard to derive my RecordSet class from that.
___________________________________________
Dr Steve Boardman,
Earth Observation Sciences Ltd.,
FARNHAM,
Surrey,
UK. GU9 8QL
Tel: +44 (0)1252 721444 Fax: +44 (0)1252 712552
___________________________________________
Jonathan Sass -- sass@sierra.net
Thursday, December 19, 1996
Environment: VC++ 4.2, NT 4.0
>
>I had quite the same problem, working with CRecordset to access, via ODBC,
>an
>mdb database, except that the error was an access violation in ntdll.dll.
I too have a similar problem. I am working on an application that uses
ODBC (CRecordset classes, Sybase SQL-Anywhere ) to get at its data, the
application calls a user dll that also uses ODBC (CRecordSet) to get at
its data (different data, Microsoft Foxpro). I successfully get the data
from one recordset into the other but when I call FreeLibrary on my
handle I crash with an access violation in NTDLL. NTDLL is the only thing
on my stack. When the recordset in the dll is closed there are two ODBC
exceptions (when freeing a statement handle) just before the access
violation.
After a few days of beating my head on this, I am looking for any
suggestions on how to track this bug down. I will remove my call to
FreeLibrary too.
Dan Kirby -- dkirby@accessone.com
Friday, December 20, 1996
You need to get the newer Jet DLL talked about in article Q151186 located
at http://www.microsoft.com/kb/articles/q151/1/86.htm
--dan
----------
> From: Yves Monier
> To: mfc-l@netcom.com
> Cc: mfc-l@netcom.com
> Subject: Re: CrecordSet with ODBC page faults in kernal32.dll
> Date: Monday, December 16, 1996 11:58 PM
>
> [Mini-digest: 2 responses]
>
> At 09:53 AM 12/13/96 GMT, Sailesh Panchal wrote:
> >[Mini-digest: 2 responses]
> >
> >Ditto,
> >
> >VC++v4.2b, NT4.0, Sybase4.9, Sybase10.
> >
> >The database has a 1058 tables
> >
> >Same problem.
> >I have also had problems adding a tables to an existing CrecordSet.
> >
> >I don't think its the drivers, because I can get a full list of table in
VB.
> >
> >Sailesh P.
>
> Environment: VC++ 4.0, NT 4.0
>
> I had quite the same problem, working with CRecordset to access, via
ODBC, an
> mdb database, except that the error was an access violation in ntdll.dll.
>
> Thanks to some people on the net, I got a workaround (you can find it on
the MS
> web site, knowledge base, article Q153897). Quite stange, but -at least
for me-
> it solved the problem...
>
> I "just" had to override the Open method of my recordset classes. These
new
> Open methods :
> 1) call the base class Open method
> 2) call LoadLibrary("MSJT3032.DLL") to ensure it remains in memory during
the
> shutdown process - the fact is my crashes occured when I was closing
or
> deleting recordsets...
>
> Hope this will help,
>
> Yves Monier
>
> ----------------------------------------------------------------
> Yves Monier Rank Xerox Research Centre
> 6 chemin de Maupertuis
> 38240 Meylan, France
>
> From France: Tel. 04 76 61 50 10 - Fax. 04 76 61 51 99
> Outside France: Tel. +33 4 76 61 50 10 - Fax. +33 4 76 61 51 99
>
> -----From: Steve Boardman EOS
>
>
>
> Environment: NT4.0, VC++4.2-flat.
>
> Me too - I've had this problem with Access 7 and ODBC. I had to export
> the Access table to an Excel spreadsheet
> and use ClassWizard to derive my RecordSet class from that.
>
> ___________________________________________
>
> Dr Steve Boardman,
> Earth Observation Sciences Ltd.,
> FARNHAM,
> Surrey,
> UK. GU9 8QL
>
> Tel: +44 (0)1252 721444 Fax: +44 (0)1252 712552
> ___________________________________________
>
| Вернуться в корень Архива
|