MSADO21 Error - please assist...

**rjlohan** · Feb 21st, 2002, 07:07 PM

I have been trying to install a package which references MSADO21.TLB - which is the Microsoft ActiveX Data Objects Library.

However I am consistently getting this error:

There was an error when trying to register C:\WINNT\SYSTEM32\MSADO21.TLB

I have also tried MSADO20.TLB (V 2.0) with the same result.

This was working fine the other day, but now I am consistently getting this error...

**rjlohan** · Feb 21st, 2002, 07:20 PM

This is the transcript of the install session from the .log file:

*** ERROR: No entrypoint for DllRegisterServer() was found in 'C:\WINNT\system32\MSADO21.TLB'
*** DURING THIS ACTION: DllSelfRegister: "C:\WINNT\system32\MSADO21.TLB"

*** ERROR: An error occurred while registering the file 'C:\WINNT\system32\MSADO21.TLB'
*** ERROR: (User Responded with 'Ignore')
*** DURING THIS ACTION: DllSelfRegister: "C:\WINNT\system32\MSADO21.TLB"

**rjlohan** · Feb 21st, 2002, 07:23 PM

I've also searched this site, and it seems over at least a year, various others have had similar if not identical problems, but no-one seems to have a solution...

**Hack** · Feb 21st, 2002, 07:27 PM

Can you manually register it useing regsvr32?

What OS are you running?

**rjlohan** · Feb 21st, 2002, 07:31 PM

It's WINNT. And I've tried in a network environment and just as a workstation. And no, I can't register it myself. It gives me:

*** ERROR: No entrypoint for DllRegisterServer() was found in 'C:\WINNT\system32\MSADO21.TLB'

as an error when I try that... (part of the same error report in the .log file...)

**Hack** · Feb 21st, 2002, 07:32 PM

Here is all I could find in MSDN on the subject. I hope it helps.

Referencing the ADO Libraries
As with any library that provides a type library, you must set a reference to the ADO library you want to use in your Visual Basic project. The type library for the current version of ADO is contained within the ADO DLL, msado15.dll. (To meet the needs of certain applications written with older versions, older versions of the type library can be referenced as well through the provided msado20.tlb, msado21.tlb, and msado25.tlb files.)

To reference the ADO library in your Visual Basic project, open the Project menu and click References. Scroll down and select Microsoft ActiveX Data Objects 2.7 Library. If an application compiled on a system with ADO 2.7 must run on a computer with a previous version of ADO installed, it needs to use one of the backwards compatibility type libraries. Add a reference to the appropriate .tlb file instead of to msado15.dll.

This link might help, but it didn't do anything for me.
http://msdn.microsoft.com/library/de...tml/mdac25.asp

**rjlohan** · Feb 21st, 2002, 07:35 PM

Ok, another piece of info: I noticed that when using the P&D wizard today, to try and rebuild the install, it couldn't find the dependancy info for MSADO21.TLB. I said keep going...blah...blah.

I'm trying again, and this time it didn't tell me that it couldn't find the dep info, so I'll see what happens this time...

**rjlohan** · Feb 21st, 2002, 07:36 PM

Hmmm.... no good on that front. I'll try your info now.

**Beacon** · Feb 21st, 2002, 07:43 PM

Hmmm sounds like you need to re-install mdac to me.
Else go to mdac 2.7.

**rjlohan** · Feb 21st, 2002, 07:47 PM

I'm in the process of getting MDAC2.7 now - just gotta free up 20MB on this computer's C: drive...

**rjlohan** · Feb 21st, 2002, 10:00 PM

Hmmm... still having troubles....

Initially I got a problem due to a lack of MSDART.DLL, which I have now included in my setup, so it all installs correctly, but then when I run the thing I get

Method ~~ of ~~ Failed

Thanks Microsoft.... reeeeaaallll helpful...

**rjlohan** · Feb 21st, 2002, 11:05 PM

I narrowed the problem down to run-time error 3706.
The detail from MSDN is this:

Provider cannot be found. It may not be properly installed.

What does this mean, and how do I solve it?

**Mega_Man** · Feb 24th, 2002, 07:33 PM

Post the code that you are using for your connection string. There may be a clue there.

Mega.

**rjlohan** · Feb 24th, 2002, 07:39 PM

Code:

Global Const strConnection = "Driver={Microsoft Access Driver " & _
    "(*.mdb)};Provider=MSDASQL.1;Persist Security " & _
    "Info=False;Extended Properties='DBQ=" & CurriculumDirectory & _
    "courseDocs.mdb;DefaultDir=" & CurriculumDirectory & _
    ";DriverId=281;FIL=MS Access;MaxBufferSize=2048;" & _
    "PageTimeout=5;UID=admin;PWD=safety;Initial Catalog=" & _
    CurriculumDirectory & "courseDocs'"

That's pretty much it. I actually have it on one line, so I just split it up then.

As I may have mentioned, it was working, until the other day. I changed nothing at all in regards to the DB, and it wouldn't install properly after that. Now I've updated to MDAC2.7, and it installs OK, but then I get that nuisance error there, which I tracked down to

RunTime Error '3706' - Provider not installed correctly or something

See this thread also: http://www.vbforums.com/showthread.p...hlight=mdac2.7

**Mega_Man** · Feb 24th, 2002, 07:48 PM

Does it work on your machine okay and the problem lies with when you install it elewhere? or.. can you not get it to work now either?

Mega.

**rjlohan** · Feb 24th, 2002, 08:00 PM

MY machine is fine, it has VB on it, and various other things.
The problem on other machines isn't apparent if I had previously installed it on them either.

The initial install error still came up, but it didn't affect the program, as I guess there was correct stuff already on that machine, but when installing on a 'new' machine, It installs ok, but then doesn't work (as per error described)...

**Mega_Man** · Feb 25th, 2002, 04:21 AM

It is absolutely essential that MDAC is installed on the host machines and it must be the same (or higher) version that you used to compile the program.
I assume you have done this?

Mega.

**rjlohan** · Feb 25th, 2002, 05:39 PM

You'd think so wouldn't you...

No, I'm pretty sure that at the original installation it installed the MDAC, but this would have been when I was using V2.0 or 2.1. Now I've upped to 2.7 - how do I install that on the other machine?
I thought it was automatic, as part of the P&D setup.exe, but I am probably wrong...

**rjlohan** · Feb 26th, 2002, 04:30 AM

Ok, ta, I'll give that a burl.

**rjlohan** · Feb 26th, 2002, 04:31 PM

Yep, got that already. Now I'm in the process of downloading the Service Packs so I can install the latest IE, so I can install MDAC2.7...

**Mega_Man** · Feb 26th, 2002, 05:40 PM

LOL

I hope it works after all that.

**rjlohan** · Feb 26th, 2002, 05:56 PM

Mmm... me too...

Cheers.

**rjlohan** · Feb 26th, 2002, 07:43 PM

Far out... give me a break.... I've now installed all that stuff, and I'm getting an Error saying

"...[Microsoft ODBC Driver]...Could not open registry key (null)..."

or something.... ****ing hell - this thing just doesn't want to work does it...

Jethro · Feb 26th, 2002, 08:37 PM

Bummer

Have you tried....and this is a long shot...reinstalling vb itself. Almost sounds, if it was working, that something has corrupted itself somewhere...as l say long shot, but what the hey

Fixed a problem we were having with Excel by doing this, after of course spending a week scouring code, msdn, etc.....

Somethings just suck for no apparent reason, we feel your pain, and are only smiling slighty at it....in that phew it's not me dealing with it sort of way....

Hope it helps, or focuses or whatever...

**rjlohan** · Feb 26th, 2002, 08:41 PM

The thing is, the exact same install package will work on other machines on the same network... I am soon to test it on a fesh machine, as all the ones where it works are ones I had previously installed to (including MDAC), so I need to know if it is a corruption problem of some sort...

Still waiting though - getting things done, including obtaining resources - in here is a ****ing big slow hassle...

**Beacon** · Feb 26th, 2002, 08:51 PM

What was your problem again rj?

hhhhhahahahahehe

Ok you never said you were using sql!

Quote from MS: "Due to issues with clustering, this release is currently NOT supported on SQL 7.0 Clustered Servers or SQL 6.5 Clustered Servers"

Even if this isnt your case try what i mention below!

So 2 things you can do. Go back and try 2.5 or use the provider SQLOLEDB instead od MSDASQL!

Hope this is it!

Jethro · Feb 26th, 2002, 08:54 PM

If is working on other machines, then deffiantly corruption dude. Tried to answer in chit chat and went into some weird error...but...

Which version of NT service packs etc on this machine and one that it does work on. Am finding allsorts of problems with NT 4 SP 6, so that may be it. Currently moding a vb5 app, adding a few tables and sorting routines, the program works at work, but here l can't even get the original code to run

**rjlohan** · Feb 26th, 2002, 08:55 PM

But it works on other virtually identical machines...

Why would changing the provider make a difference?

But I shall keep it in mind...

As for 2.5, I don't know if I even have that anymore - when I installed MDAC2.7, I lost references to earlier versions...

And anyway, 2.5 was always giving me stupid problems when distributing...

**rjlohan** · Feb 26th, 2002, 08:57 PM

Originally posted by Jethro
If is working on other machines, then deffiantly corruption dude. Tried to answer in chit chat and went into some weird error...but...

Which version of NT service packs etc on this machine and one that it does work on. Am finding allsorts of problems with NT 4 SP 6, so that may be it. Currently moding a vb5 app, adding a few tables and sorting routines, the program works at work, but here l can't even get the original code to run

It had SP5, but in a vain effort to improve it (by installing MDAC 2.7) I installed SP6, and then IE6... no change on that machine...

The machines it works on are either SP5 or SP6. My testing machine is SP6, everything works on it - my dev. machine is SP5 - everything works on that...

Anyway, still waiting on tester number 2...

Jethro · Feb 26th, 2002, 09:04 PM

Real bummer

Sounding awfully like a rebuild to me. Was msdn any help at all? Could go and check the error number if you like, have membership (hopefully if SK has got off his ass and done it like he promised)...

**rjlohan** · Feb 26th, 2002, 09:07 PM

The new error number is about 10 digits long...

I'll have to get it...

Jethro · Feb 26th, 2002, 09:15 PM

Another suggestion, which might be lamer than the first, but then why not cut out all the simple answers. On the machine with the problems try network neighbourhood to ensure you have access to the database...who knows stranger things have happened

**rjlohan** · Feb 26th, 2002, 09:21 PM

Geez, this is a pain...
I put in error handling stuff, and now the error number isn't displayed...
The worst bit is that the offending machine is 50m up the hall...

**rjlohan** · Feb 26th, 2002, 09:22 PM

Originally posted by Jethro
Another suggestion, which might be lamer than the first, but then why not cut out all the simple answers. On the machine with the problems try network neighbourhood to ensure you have access to the database...who knows stranger things have happened

Access is fine - it's in the general shared area. That machine doesn't have Access anyway, so I can't open it up.

Jethro · Feb 26th, 2002, 09:32 PM

Originally posted by rjlohan
Geez, this is a pain...
I put in error handling stuff, and now the error number isn't displayed...
The worst bit is that the offending machine is 50m up the hall...

*Jethro waiting for rj to get back.....oh and the error text as well would be helpful

50m up the hall...not a novell network you got there is it

Have had problems with that stuff, that could cause this....something about distance, and couldn't we move the machine according to the novell tech....like right, and that's why novell ain't selling partner

**rjlohan** · Feb 26th, 2002, 09:34 PM

Originally posted by Jethro

*Jethro waiting for rj to get back.....oh and the error text as well would be helpful

50m up the hall...not a novell network you got there is it Have had problems with that stuff, that could cause this....something about distance, and couldn't we move the machine according to the novell tech....like right, and that's why novell ain't selling partner

Well, now that you mention it.........

**rjlohan** · Feb 26th, 2002, 09:36 PM

NEed more time - gotta recompile minus the error 'handling'...

Jethro · Feb 26th, 2002, 09:42 PM

Originally posted by rjlohan

Well, now that you mention it.........

Would be talking to novell then rj, their networks suck over any distance...and may be the cause of your problem

**rjlohan** · Feb 26th, 2002, 09:45 PM

Ok, here it is.
It occurs identically twice, when I attempt to make a DB connection...

Err: -2147467259
[Microsoft][ODBC Microsoft Access 97 Driver]General Error. Unable to open registry key '(null)'.

**rjlohan** · Feb 26th, 2002, 09:46 PM

Originally posted by Jethro

Would be talking to novell then rj, their networks suck over any distance...and may be the cause of your problem

Yeah right - like I'm gonna get them to change their network...they won't even upgrade from Internet Explorer 2.3 without a fuss...

Thread: MSADO21 Error - please assist...

Thread Tools

Display

MSADO21 Error - please assist...

Posting Permissions