Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

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??
0
s_subha_iyer
Asked:
s_subha_iyer
  • 2
  • 2
1 Solution
 
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
 
patrickmCommented:
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:
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now