Solved

Random behaviour of my application

Posted on 1998-10-29
5
184 Views
Last Modified: 2013-11-20
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
Comment
Question by:s_subha_iyer
  • 2
  • 2
5 Comments
 

Author Comment

by:s_subha_iyer
ID: 1324031
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
 

Expert Comment

by:umarama
ID: 1324032
Hi !

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

0
 

Accepted Solution

by:
patrickm earned 100 total points
ID: 1324033
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
 

Author Comment

by:s_subha_iyer
ID: 1324034
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
 

Expert Comment

by:patrickm
ID: 1324035
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 Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction: Load and Save to file, Document-View interaction inside the SDI. Continuing from the second article about sudoku.   Open the project in visual studio. From the class view select CSudokuDoc and double click to open the header …
Introduction: Dialogs (1) modal - maintaining the database. Continuing from the ninth article about sudoku.   You might have heard of modal and modeless dialogs.  Here with this Sudoku application will we use one of each type: a modal dialog …
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now