Re: Failure to open database

Gary,

Thanks for responding to my post - it has been frustrating trying to solve
this on my own. Please see the specific responses to your questions.

> Based on my understanding, the problem is that your MFC program could not
> open an access database via DAO---it will crash when calling the
> "CDAODatabase.Open" to connect the datasource, please let me know if I
have

Yes - it crashes at the Open statement.

> First, do you get any error message while the program crashes? If you can
> provide the error message, it will be useful to isolate this problem.
>

Yes - Please see the error information below. If it is any use, I even have
a dump of the stack. This is how I was able to establish where exactly the
crash occurred.

> From your description, your program works alright on some other machines,
> except a Windows XP SP2 machine, so have you tested it in some other
> Windows XP SP2 machines, does the problem occur?
>
Yes - the program works on other machines (there are 100s of users). It
works on Win9x machines , Win2000 and Win XP machines both SP1 and SP2.
There were problems at the same place on Win9x machines about a year ago &
that is when I learnt about MDAC versions and I ask customers to get a
current MDAC (& JET dll ) from Microsoft and update their machines before
they use my program - have not had this problem again till this user.

I have an XP with SP2 machine that seem to have the same versions of the
other dlls as the user and it is working.

> Another thing you may take a try is downloading a MFC DAO sample form the
> MSDN(e.g. DAOVIEW sample) and running it in that Windows XP SP2 machine,
to
> see whether the sample works well or not?

This is really not practical - I do not even know where this user is and
have no access to the computer. While he is co-operative (thus the XML file
from the component checker), I cannot really ask him to download and run a
sample.

I cannot think of anything else to tell you - so please ask specific
questions.

Thanks

Here is the error information:
----------------------------------------------

Operating system: Windows XP (5.1.2600).
1 processor(s), type 586.
34% memory in use.
1024 MBytes physical memory.
668 MBytes physical memory free.
2929 MBytes paging file.
2679 MBytes paging file free.
2048 MBytes user address space.
1999 MBytes user address space free.

Read from location 00000008 caused an access violation.

Context:
EDI: 0x00f45e60 ESI: 0x00000001 EAX: 0x0000000f
EBX: 0x004293c4 ECX: 0x00000008 EDX: 0x004e2705
EIP: 0x73e2d6f4 EBP: 0x0012d938 SegCs: 0x0000001b
EFlags: 0x00210286 ESP: 0x0012d920 SegSs: 0x00000023

Bytes at CS:EIP:
8b 09 51 ff 71 f8 8d 4d f0 ff 75 0c 50 e8 c5 6c

----------------------------------------------------------------------------
--


"Gary Chang[MSFT]" <v-garych@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:owkgH1aOFHA.3136@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> Based on my understanding, the problem is that your MFC program could not
> open an access database via DAO---it will crash when calling the
> "CDAODatabase.Open" to connect the datasource, please let me know if I
have
> misunderstood anything.
>
> Before digging into the problem, please help to collect some detailed
> information about the problem:
>
> First, do you get any error message while the program crashes? If you can
> provide the error message, it will be useful to isolate this problem.
>
> From your description, your program works alright on some other machines,
> except a Windows XP SP2 machine, so have you tested it in some other
> Windows XP SP2 machines, does the problem occur?
>
> Another thing you may take a try is downloading a MFC DAO sample form the
> MSDN(e.g. DAOVIEW sample) and running it in that Windows XP SP2 machine,
to
> see whether the sample works well or not?
>
> If you have any further information related to this problem, please feel
> free to post here.
>
> Thanks very much and looking forward to hearing from you.
>
>
> Best regards,
>
> Gary Chang
> Microsoft Community Support
> --------------------
> Get Secure! ¡§C www.microsoft.com/security
> Register to Access MSDN Managed Newsgroups!
>
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
> &SD=msdn
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>


.

Relevant Pages

  • Access denied - "-2147024891" - cocreateinstance
    ... I have a Windows XP SP2 machine. ... "access denied" error message with the error value error value = ... permission anywhere? ...
    (microsoft.public.vc.mfc)
  • Re: XP SP2 kills SMS 2 Admin console
    ... Can you remote the XP SP2 machine from a Windows 2000 machine? ... >I applied your fix and the Admin Console works on our test computer. ...
    (microsoft.public.sms.admin)
  • Re: Detecting memory card/USB device insertion - how to?
    ... I have tried running this on my XP SP2 machine, ... a CompactFlash card via a multi-card USB reader? ... >> my PC - it seems to use a Windows Service called 'Adobe Active File ... >> removable devices, so I suspect that a bespoke polling component is ...
    (microsoft.public.dotnet.framework)
  • Re: WebDav problem maybe?
    ... Seems like for some reason your Win2003 SP2 machine cannot "see" or communicate with the program which is hosted on annother machine. ... Windows Server - File Storage ... This program uses the UNC path to get the documents. ...
    (microsoft.public.windows.server.general)
  • RE: Failure to open database
    ... the problem is that your MFC program could not ... open an access database via DAO---it will crash when calling the ... Windows XP SP2 machines, does the problem occur? ... DAOVIEW sample) and running it in that Windows XP SP2 machine, ...
    (microsoft.public.vc.database)
Loading