I have a spreadsheet with VBA code that is crashing on one of my laptops. It crashes at the "cnASC.Open" line and gives the following error message:
"System Error &H80004005 (-2147467259) unspecified error"
Dim cnASC As ADODB.Connection
cnASC.ConnectionString = "Provider=SQLOLEDB;Data Source=SAPPHIRE;Initial Catalog=asc_br;Integrated Security=SSPI;Auto Translate=False"
I have a sneaking suspicion that the provider might not exist on the laptop, and I've run MDAC_TYP.EXE on the laptop to try to remedy the situation, but to no avail.
I hope someone has a solution for me. Thanks!