adodc/DLL loading problem problem

[Ralph8]

My dev context is VB 6 and SQL Server 7 (MSDE).

My problem is:

After building a "release" of my project and then loading it on a "user" machine I get these results:

The program appears to load fine. On first execution, I get the message that the program linked successfully to the DB.BUT, when I select and process any of the child forms, every adoDC causes a message "[ADODC}: Unknown error. [ADO]:". After I get the last of those, there is a Run Time Error '48': Error loading DLL.

I assume that a DLL effecting the adoDCs is corrupted or missing, but there is no indication of what that DLL is.

This has been working in the past on both local (Server) and remote client machines. The current results are hard and consistent. I have not found a way past them.

Can any one help?


TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[NaiLBoMB]

if you know theres a dll missing, have u tried looking at what libraries are ticked for use in tour IDE?
that might give u a shortlist of possible dlls to transfer to the "user" machine to enable the prog 2 work

 

[NaiLBoMB]

typo sorry,
"your" IDE (not tour, lol!)

 

[CCLINT]

What are you using to package your application?

Prior to doing so, is your VB6 updated to SP5?

 

[Ralph8]

I am using the P&D Wizard in VS 6.

VS SP5 and SQL Server SP4 are loaded.

Thanks

Ralph

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[Ralph8]

Further update:

Using MS Comcheck program to analyze MDAC it appears that at some time in the past, that 2.5 had been upgraded to 2.6 and then overlaid again with 2.5 which left a group of file errors.

From what I read, it seems that nothing over 2.5 should be used in the SQL Server 7 environment. Maybe I would be all right if I could cleanly delete the MDAC and re install 2.5 from scratch.

The new problem: The Comcheck delete function does not seem to work. I have tried it with the /D and /NR switches and it just does another analysis.

Does any one know of a way to cleanly delete the MDAC?


TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[Ralph8]

Belay that last! I got the Comcheck.exe /D to work as advertised. I apparently had read the instructions with a forked eye.

I am doing further testing to see where I am with my Dev machine and my test machines all on MDAC 2.5

I will give an update ASAP.


TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[Ralph8]

That seemed to solve the basic problem. I have a few other things now that I may have created going down rabbit trails in my ignorance of the real problem.

Hopefully, it will be straightened out shortly.

Thanks for the responses guys.

TIA

Ralph D. Meredith

http://www.merecosoftware.com

 

[CCLINT]

Thanks for keeping us informed...