General information
Category:
COM/DCOM and OLE Automation
Title:
ADODB.connection: provider cannot be found
I am using the following code to work with Excel
oCon = CREATEOBJECT('ADODB.connection')
oCon.ConnectionString = "Provider=VFPOLEDB;Data Source= "+cDataLoc
One user has an error that says "OLE IDispatch exception code 0 from ADODB.connection: provider cannot be found".
I thought that I need VfpOleDB.dll to use the above code but I do not have thise DLL on my machine and it runs without a problem.
My question is what file I need to check for to make sure that the above connection will succeed?
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only