troubleshooting Question

Method ' open ' of object '_Connection' failed

Avatar of clutcher3
clutcher3 asked on
Visual Basic Classic
11 Comments1 Solution1109 ViewsLast Modified:
This is the scenario:

Xp Professional and VB6 SP4. An application of mine that has run for months. Source in error follows.

Set ConnAS400 = New ADODB.Connection
ConnAS400.ConnectionString = "DSN=AS400;UID=PC;PWD=S"

This application query a lot of different ODBC sources (including IBM Client Access Express) and analyze and write results in a xls file.

For reason due to secondary hd swap on my pc, IBM Client Access V4R4M0 seems to stop working. So I upgrade it to V4R5M0.

After this I get the error in the title usinig *ANY* ADO ODBC connection in VB or by a compiled exe. This and other application of mine still continue to work fine on any other pc. But I cannot develop anymore.

Searching the web I found that XP has MDAC 2.7 inside and so no rollback is allowed and reinstalling 2.7 doesn't fix. VB6 SP5 did not fix either.

A person in NG says that he work out this issue disinstalling Ca and reinstalling sp2 on w2k... on w2k, and I have XP.

A part from waiting for next week Xp SP1 has anyone any suggestion?

(I start from 200 but I think this is quite hard and I will increase)



Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros