Solved

Random behaviour of my application

Posted on 1998-10-29
5
186 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
how to you can convert your project to a Maven project and the Maven plugin should download the source 1 42
sum13 challenge 24 90
haveThree challenge 22 112
Problem to event 3 75
Here is how to use MFC's automatic Radio Button handling in your dialog boxes and forms.  Beginner programmers usually start with a OnClick handler for each radio button and that's just not the right way to go.  MFC has a very cool system for handli…
If you use Adobe Reader X it is possible you can't open OLE PDF documents in the standard. The reason is the 'save box mode' in adobe reader X. Many people think the protected Mode of adobe reader x is only to stop the write access. But this fe…
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.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

932 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

11 Experts available now in Live!

Get 1:1 Help Now