problems with DSN for MS Acess database
- From: kdv09@xxxxxxxxxx
- Date: 19 Dec 2005 21:02:12 -0800
Hi!
I'm looking for some help in fixing my screwup:
I've got C++ app which reads MDB database, using MFC CDatabase and
CRecordset derived classes. I had it working OK on development PC (Win
XP SP2) with MS Access 2000 installed (the app itself does not use MS
Access). I moved the app on another PC (also Win XP SP2) without MS
Access. After some poking around I've figured out that the app does not
work because DSN it is using was not available. So I created System DSN
for MS Access Database by hand and my app was working OK.
After that by silly mistake User DSN for MS Access Database was created
on the development PC (the one with existing and working MS Access).
This upset performance of database access very badly - it takes very
long time to read and move through the records.
I've (1) unrolled XP to earlier date, (2) reinstalled MS Access - still
have the problem.
MS Access itself seems to be OK, no noticeable degradation of speed,
but CDatabase.Open and ExecuteSQL, CRecordset::MoveFirst MoveNext, etc
take very long time. It also looks like increased disk activity during
those operations.
So, any hints on what's going on and how stop it from going on like
that?
Many thanks
kdv09
.
- Follow-Ups:
- Re: problems with DSN for MS Acess database
- From: Bernard Peek
- Re: problems with DSN for MS Acess database
- From: Steve Jorgensen
- Re: problems with DSN for MS Acess database
- From: Sky
- Re: problems with DSN for MS Acess database
- Prev by Date: Re: Can a variable hold 2 values simultaneously - a string value and a numeric?
- Next by Date: Re: problems with DSN for MS Acess database
- Previous by thread: Reading image files from a URL location
- Next by thread: Re: problems with DSN for MS Acess database
- Index(es):
Relevant Pages
|
