Random behaviour of my application

My application contains a few functions which access data from MS Access database. Each function fires atleast 5 queries each. when i run my application (which calls these functions repeatedly), it works for a couple of times but say after the third time it has successfully executed the function, it generates an exception something like this:
"General error. Driver Failed at SQLSetConnectAttr. General error. One of the library files is missing" . This is a CDBException error. Now my question is if the same set of queries work thrice why does this exception arise on the fourth time??
s_subha_iyerAsked:
Who is Participating?
 
patrickmConnect With a Mentor Commented:
It sounds like one of the msj*.dll's or other data access dll was overwritten by an older dll.  If your enviroment is MSVC5 or 6 run setup and choose reinstall.  This will replace the out of date dll.  

I hope this helps.

Pat...
0
 
s_subha_iyerAuthor Commented:
I tried my best to rectify this error. Now i have decided to minimise the number of queries fired. But in anycase this is not a solution. So please let me know the solution as early as possible.
0
 
umaramaCommented:
Hi !

With DAO objects, things run O.K. for me. Wonder if u tried that. Or is it that you cannot use DAO.

0
 
s_subha_iyerAuthor Commented:
The same problem occurs when i run the application from some other machine where VC5 was installed fresh. So does this mean that the CD i am using to install VC5 itself is corrupted??Please clarify
0
 
patrickmCommented:
NO. After installing MSVC, you or someone else, has probably installed a program with a brain dead install program that overwrites the msjet dlls with an older version.  Unfortunately this happens frequently.

I hope this helps.

Pat...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.