Solved

ODBC  error

Posted on 2000-04-25
12
542 Views
Last Modified: 2008-03-10
I have a Visual Basic application that doesn't work. I use Odbc, file dsn, and an Access Database in the Application.

The error when I try to run is:

Connect:  Application-defined or object-defined error. 40002 IM003: Specified driver could not be loaded due to
system error 1157 (Microsoft Access Driver (*.mdb)). D due to system error 1157 (Microsoft Access Driver
(*.mdb)).


Please let me know if you have the anwer, thanks.
0
Comment
Question by:tinman1412
12 Comments
 
LVL 1

Accepted Solution

by:
lochiano earned 100 total points
ID: 2749551
Application-defined or object-defined error is a very generalized error in that if the DLL that you are calling does something stupid (as in not knowing what driver to use to see the DB) then that is one of the generalized messages that VB can get back.  There is another error that is inside of the DLL but normally you do not see that.

The first thing that I would do if I was you and that is to see if this is isolated to one PC or is this all over the place.

Next, make sure that the PC is up to date.  For example is this is a Windows 95 box then is DCOM and MDAC up to date?  Have you loaded all of the VB service packs.

If that does not do it then I would try to see if the problem can be reproduced in some other application.  What does Excel do when you try to access the same file?  VB has a good wizard for connecting into ODBC files and that could show you the connect string that it is using.

Try another connection method.  IF CreateObject() is giving you problems, then try creating an  (dim RS as new ADODB.Recordset) ADO object.  If VB does not work and Excel can see the file correctly then use ODBC to go to excel, then to the database.  It will be slow but you can see how it is being done there.

Go into the ODBC manager and drop the name and put it back in.  If the object created is an Oracle object then be sure to make a SQLPlus connection to verify that you can bet to the database in question.

Watch enviroment varables.  You can kill a Oracle session by not having the path statement set correctly.

Bottom line.  There may not be an easy answer to your question.



0
 
LVL 3

Expert Comment

by:jjmartin
ID: 2749553
Download Microsofts component checker.  Component Checker checks installed version and diagnoses installation issues with Microsoft Data Access Components.  This should identify and correct your problem.  It is available at:


http://www.microsoft.com/downloads/release.asp?ReleaseID=15754
0
 
LVL 1

Expert Comment

by:lochiano
ID: 2751197
I agree that the program offered is very good, but do not overlook a little good common sense.
0
 

Author Comment

by:tinman1412
ID: 2755924
I've installed a setup that updates the Microsoft Access Components, and it works, but it messes up my odbc setting for other applications. Does anyone know why?

system I'm running this on is Win 95,if this makes a difference
0
 
LVL 1

Expert Comment

by:lochiano
ID: 2755992
Which version MDAC and did you install or reinstall DCOM95?
0
 

Author Comment

by:tinman1412
ID: 2756053
I only installed MDAC version 2.1
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 1

Expert Comment

by:lochiano
ID: 2756062
I have seen several issues  with MDAC version 1.5 to MDAC version 2.5. Programs run with one or the other but not both.

I am guessing that you have some programs that were compiled with the older version and some that were compiled with the newer copy.  If that is the cane then the only solution is to recompile the old stuff using the newer stuff.

0
 

Author Comment

by:tinman1412
ID: 2756102
Well, I've tested my application on 2 other computers and they both work, it's just one in particular does not and I'm confused as to why.

All 3 computers are win 95
0
 
LVL 1

Expert Comment

by:lochiano
ID: 2756348
We have several hundred VB programs. All of them use MDAC.  3 would not work when we went from 1.5 to 2.15 The operating did not make any difference)  From 2.15 to 2.5 we have had not known errors.

We did not persue it much because at the same time we were interesting in making some other changes but I would half to guess it was the version of one of the dependent objects of the MDAC driver that did not like something else.
0
 

Author Comment

by:tinman1412
ID: 2756673
If MDAC mess up my other odbc settings, would a newer version of DCOM do the same?
0
 
LVL 1

Expert Comment

by:lochiano
ID: 2756702
We have never seen that. DCOM95 seems to be DCOM95.
0
 

Expert Comment

by:JamesADaly
ID: 3323714
I've been pulling my hair out over a similiar problem. The error  that would come up on certain machines during installation of a vb app I had written would be, "specified driver could not be loaded...system error...microsoft access driver.."

In the end we managed to fix it by copying ODBCJT32.dll from a machine the application worked on to the problem machine and this fixed it.

On the problem machine it was version 3.xx and on a machine that worked okay it was 4.xxx

James
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

743 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