Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Random behaviour of my application

Posted on 1998-10-29
5
Medium Priority
?
193 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 200 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Introduction: Database storage, where is the exe actually on the disc? Playing a game selected randomly (how to generate random numbers).  Error trapping with try..catch to help the code run even if something goes wrong. Continuing from the seve…
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.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…

618 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