Class not registered

[mans]

Hello,<br><br>I am attempting to access a database on a new machine (non development) which is using the VB application I developed.&nbsp;&nbsp;When I attempt to access the database through the VB (Vers. 6, developed on Access2000) interface it comes up with the following error messages:<br><br>-ado could not find the specified provider (followed by):<br>-Run-time error '3633' (followed by):<br>-Class not registered looking for object with CLSID ;{00000010-0000-0010-8000-00AA006D2EA4}<br><br>I suspect that there is a problem with a DLL.<br><br>Can somebody please let me know what the problem may be in this case.<br><br>Thanks

 

[Karl Blessing]

are you using the ADO 2.1 reference, because if you are using anything lower than that, it will not be compatible with Access 2000 <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[MikeLacey]

Yep - it's a missing .dll<br><br>That CLSID refers to DAO.DBEngine.35 which is in the file DAO350.DLL<br><br>I searched through the registry for that CLSIS <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Please -- Don't send me email questions without posting them in Tek-Tips as well. Better yet -- Post the question in Tek-Tips and send me a note saying "Have a look at so-and-so in the thingy forum would you?"

 

[cnealy]

I'm having the same problem. How do I determine which file is missing? I'm using ADO 2.6 and Jet 4.0. Works fine on my development box, but bombs on the client PC.

I created the install package with the Package & Deployment Wizard.

 

[Rougy]

This is a common and consistant problem with VB6.

I've been having the same problems and searching for a solution myself for over two weeks now.

Microsoft's official solution is to go into the client computer and jimmy with the registry.

Gee, thanks, I paid over $500 for the program and another $60 for reference books but Microsoft is too lazy to make an *.exe to fix the problem themselves.

Bottom line is the package wiz isn't doing what it's supposed to do - my opinion.

Rougy

 

[mans]

You can do as MikeLeacy did above, on the dev. machine look up the CLSID value and trace it to the appropriate DLL OR alternatively, there is a file called modules.exe that I downloaded from the Crystal Decisions web site. I think you can go to crystaldecisions.com and download the zipped up file. You unzip it and run modules.exe after you attempt to run your VB application, it will show you all of the dll's that are currently running.

Good Luck.

 

[cnealy]

How do I search the registry for the CLSID?

Thanks for the tip about Crystal Decisions ... definitely going to check it out.

 

[mans]

You search by going to &quot;Start&quot; (bottom left hand corner of screen) then &quot;Run&quot; and type in regedit, go up to Edit then Find and put in the appropriate CLSID number (highlight &quot;My Computer&quot; first). It will then show you the appropriate dll.

As a side issue I guess, I used the P&D Wizard with VB6 for 2 yrs and it caused me no end of frustration. I have been using WISE Installation for a fair while now and it has proven to be an excellent packaging and installation tool.

 

[cnealy]

Thanks mans!

Hopefully, I can find the missing .dll quickly so that my tester can continue testing. But, prior to implementation, I think I'm going to use another packaging tool (maybe Visual Studio Installer, since it's free). I can only imagine what nightmares the P&D wizard will cause when I have to install this program on 13 client machines.

 

[cnealy]

Well, as luck would have it, the error message does not send the CSID. The user just sent me the exact message which reads:

Run-time error '-2147221164 (80040154)': Class not registered

I suppose I can install Visual Studio Installer and try to re-package the setup. Not sure what else I can do (short of spending $$ on a 3rd party Installer, which would be a last resort due to budgetary constraints).

 

[mans]

A 3rd party installation package may not necessarily resolve this issue, it is something that you should consider for the long term.

I have had your above error message a couple of times and from memory it was a missing dll.

You can resolve the issue as described above. In the P&D wizard, look at the dll's that are to be downloaded on the client machine then run the modules.exe file (as per instructions above) on the client machine and see which dll needs manual installation. Also, from memory I think my missing dll was dao350.dll or dao360.dll.

This is about all I can really tell you.

 

[cnealy]

Thanks so much for your input. It's comforting to know that many people have experienced the same problem and that it's not a result of my ineptitude! )

One more thing ...

I'm having trouble finding the modules.exe file on the crystaldecisions.com website. Can you post a link?

Again, many thanks.

 

[andja]

This CLSID is register for &quot;DAO.DBEngine.35&quot;.

To resolve this problem, you can install Microsoft Data Access Components 2.6 (ado and rdo object) and Jet 4.0 to use MS Access 2000 (search file mdac_typ.exe and jet40sp3_comp.exe in microsoft web site).

 

[reachali]

Hello Mans,

I m Ali here...

Myself into developing VB 6.0 applications with Access/SQL Server as Back End..
I m facing the same problem...So if u find any solution to it do kindly pass it to me at reachali@rediffmail.com
Any other discussions are welcomed..
Regards
Ali

 

[Norris68]

You may want to have a look at thread792-99494 in the VB Professional Development forum.