Re: problems with DSN for MS Acess database
- From: Steve Jorgensen <nospam@xxxxxxxxxxxxx>
- Date: Mon, 19 Dec 2005 21:41:10 -0800
On 19 Dec 2005 21:02:12 -0800, kdv09@xxxxxxxxxx wrote:
>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
Did you accidentally turn SQL logging on for the DSN?
.
- Follow-Ups:
- Re: problems with DSN for MS Acess database
- From: kdv09
- Re: problems with DSN for MS Acess database
- References:
- problems with DSN for MS Acess database
- From: kdv09
- problems with DSN for MS Acess database
- Prev by Date: Re: problems with DSN for MS Acess database
- Next by Date: Run external application script from access?
- Previous by thread: Re: problems with DSN for MS Acess database
- Next by thread: Re: problems with DSN for MS Acess database
- Index(es):
Relevant Pages
|
