Re: "Object library not registered" error.

"JohnJohn" <JohnJohn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0DF6C7D5-AE94-4EB7-BFD4-6D9AE211060B@xxxxxxxxxxxxxxxx
> Hello. I am receiving the error in the subject line at compilation on the
> following declaration within a form file:
>
> Dim rsBanks as ADODB.Recordset.
>
> I have a reference in the project to the Microsoft ActiveX Data Objects
> 2.7
> Library. Meanwhile, an earlier-created executable from this project
> continues to run properly using this library. There have been no updates
> to
> MDAC.
>
> Frustrated, I created a brand new project identical to the one that is
> failing with the "Object library not registered" error, and it too, had
> the
> same error. I can however, create a brand new project, add a reference to
> the library, create an ADODB.Recordset object successfully. Moreover, I
> can
> add the very same form file that receives the error to a new project, and
> there will be no error.
>
> For what it's worth, I also receive a "Method '~' of object '~' failed"
> error upon loading the project. I know this may not be enough
> information,
> but if you can point me to what information you might need to help me
> resolve
> this, I will love you forever and ever, amen. I will also copy and paste
> the
> .vbp file after I sign my name.
>
> Thanks!
> John
>
> Type=Exe
> Reference=*\G{00020430-0000-0000-C000-000000000046}#2.0#0#..\..\WINNT\system32\stdole2.tlb#Standard
> OLE Types
> Object={6ADEA5C6-D7A2-11D3-AA59-00105A6F87AB}#1.0#0; dXDBInsp.dll
> Object={6A24B331-7634-11D3-A5B0-0050044A7E1A}#1.7#0; DXDBGrid.dll
> Object={BDDD132C-614B-11D3-B85E-85ADB7D07209}#1.0#0; dXSBar.dll
> Object={7C801DC0-ECC8-11D2-9C5C-00500411B995}#1.2#0; dXTList.dll
> Object={15B168B0-AD3C-11D1-A8D8-00A0C9200E61}#1.0#0; r2axctrl.ocx
> Object={5664FAD6-05FD-11D4-AABA-00105A6F87AB}#1.0#0; dXEditrs.dll
> Reference=*\G{2F6AAE3C-937F-11D2-8165-00105AA30B21}#1.0#0#..\..\WINNT\system32\PageSet.dll#PageSet
> Reference=*\G{1DF3AFED-47E0-4474-9900-954B8FD24E86}#1.0#0#..\..\WINNT\system32\ChilkatMail.dll#Chilkat
> Mail 5.1.4
> Reference=*\G{246241C8-3F53-42D3-AF90-9FF544117B99}#1.0#0#..\..\WINNT\system32\ChilkatUtil.dll#Chilkat
> Util 2.5.0
> Reference=*\G{0B5158B1-B8FF-11D3-804D-0050044A7DB1}#1.0#0#..\..\Program
> Files\Developer Express Inc\XpressPrinting
> System\dXPSystm.dll#XpressPrinting
> System 1.5 by Developer Express
> Reference=*\G{EF53050B-882E-4776-B643-EDA472E8E3F2}#2.7#0#..\..\WINNT\system32\msado27.tlb#Microsoft
> ActiveX Data Objects 2.7 Library

<snip>

You might try changing the following line...

> Reference=*\G{EF53050B-882E-4776-B643-EDA472E8E3F2}#2.7#0#..\..\WINNT\system32\msado27.tlb#Microsoft
> ActiveX Data Objects 2.7 Library

to...

Reference=*\G{EF53050B-882E-4776-B643-EDA472E8E3F2}#2.7#0#C:\Program
Files\Common Files\system\ado\msado27.tlb#Microsoft ActiveX Data Objects 2.7
Library

in your .vbp file. Don't for get to make a backup copy first.

ADO is normally installed in the Program Files\Common Files\system\ado
folder not the System32 folder. This may be the fault of some other
software you installed or something to that effect. If that does not help
the only other thing I can think of is to use this instead...

Reference=*\G{2A75196C-D9EB-4129-B803-931327F72D5C}#2.8#0#C:\Program
Files\Common Files\system\ado\msado15.dll#Microsoft ActiveX Data Objects 2.8
Library

Do not let the name fool you, this could also be the dll v2.7 just depends
on the latest MDAC installed. If you do not have 2.8 installed then create
a new project and cut and paste that reference instead as the GUID should be
different.

--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.


.

Relevant Pages