Solved

ODBC  error

Posted on 2000-04-25
12
544 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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
 
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 is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

810 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