Link to home
Start Free TrialLog in
Avatar of Richard
RichardFlag for United States of America

asked on

Missing ADODB in VB6 program

I am working on a large VB6 project.  I am using Windows XP  as the development environment.  For various reasons, I moved had to a new Windows XP machine.  I have everything set up the same as the old machine (Win-XP SP3, VB6 SP-6 etc).  My program needs connects to an SQL database.  I have all the same references selected as on the old machine, however for some reason my connection to the Microsoft ActiveX Data Objects Recordset 2.8 Library isn't "connected".  I get a debug error the first time I use ADODB as in:
Set rsTable as ADODB.Recordset

Open in new window

There is no intellisense associated with ADODB.  I have the Microsoft ActiveX Data Objects Recordset 2.8 Library selected in the References.  I have reinstalled the MDAC28SDK.  I have also re-registered the MSADOR15.DLL file.

The program will run on the machine, connect to the SQL etc fine when run from the .EXE, but won't run in the development environment.

Anyone have any ideas about this?
thanks in advance
Richard
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

This MS article  which says

Select Microsoft ActiveX Data Objects x.x Library from the list. Verify that at least the following libraries are also selected:
Visual Basic for Applications
Microsoft Access 8.0 Object Library (or later)
Microsoft DAO 3.5 Object Library (or later)
may help.
ASKER CERTIFIED SOLUTION
Avatar of ScriptAddict
ScriptAddict
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Richard

ASKER

Hi Martin and ScriptAddict,
Martin - I have everything you mentioned except the Access 8.0 Object library - the original machine doesn't have it either, so I shouldn't need it.

ScriptAddict - I've done a 1 for 1 comparison of the References on both machines - they are the same - However not in the same order!

I reordered them to be in the same order and that solved the problem.  When I saw that the order was not the same, I remembered an issue I had about 10 years age on this project about the order of the list of References being an issue.  I don't remember what was affected at that time, but once I reordered the list to be the same as my original list everything started working.  I first moved the ActiveX Data Objects to be above all the rest of the Data Libraries.  That didn't help - I had to make the order of all the data references the same to make it work.

I don't thing the order issue is documented anywhere (that I have seen).  Martin, you have been around as long as I have (maybe longer) have your ever heard about the order of the Reference list?

Anyway, thank both of you for your quick response!  As usual, EE Rocks!
Avatar of Richard

ASKER

Hi Martin and ScriptAddict,
Martin - I have everything you mentioned except the Access 8.0 Object library - the original machine doesn't have it either, so I shouldn't need it.

ScriptAddict - I've done a 1 for 1 comparison of the References on both machines - they are the same - However not in the same order!

I reordered them to be in the same order and that solved the problem.  When I saw that the order was not the same, I remembered an issue I had about 10 years age on this project about the order of the list of References being an issue.  I don't remember what was affected at that time, but once I reordered the list to be the same as my original list everything started working.  I first moved the ActiveX Data Objects to be above all the rest of the Data Libraries.  That didn't help - I had to make the order of all the data references the same to make it work.