Link to home
Start Free TrialLog in
Avatar of sahinman
sahinmanFlag for United States of America

asked on

WinXP VB6 run-time error 3706

I am installing a VB6SP6 app on WinXP Pro connected to SQL Server Express 2005. I installed on (5) machines without a problem. On the next pc, I get the error: Run-time error 3706 Provider cannot be found. I installed and tested the SQL Native Client the same on all machines and received 'Test Completed Successfully' so am thinking the database connection is working but not the ADO database connection. Have searched Google & EE for this error message but mostly get dead-end links. I need help fixing this error.
ASKER CERTIFIED SOLUTION
Avatar of Sethi
Sethi
Flag of India 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 sahinman

ASKER

I found and ran MS Component Checker, it identified MDAC 2.8 SP1, I downloaded the latest MDAC installer file but it gave the following error: MDAC 2.8 RTM is incompatible with this version of Windows. All of its features are currently part of Windows. How do I 'install MDAC again'?
Check this link:
https://www.experts-exchange.com/questions/21167315/MDAC-2-8-RTM-is-incompatible-with-this-version-of-Windows.html

I guess you will have to first remove Windows SP2 on that machine.
Is it working now?