The issue is that it's searching out the OLE Automation reference in C:WindowsSysWOW64stdole2.tlb
That is first-rate for 64bit customers however now not for 32bit. How might I repair this?
How do I discover if the reference is used
Automation anywhere ? i'm afraid of virtually doing away with the reference then finding out it's being used someplace.
replace: underneath is where the error is triggered:
Error --> Set Cnxn = New ADODB.Connection
With Cnxn
.Provider = "MSDataShape"
.Properties("Data Provider").Value = "SQLOLEDB"
.Properties("Data Source").Value = dbserver
.Properties("User ID").Value = username
.Properties("Password").Value = password
.Properties("Initial Catalog").Value = dbname
.CommandTimeout = 120
.ConnectionTimeout = 120
.Open
End With
