keith_thomas
14 years agoNew Contributor
Unable to interact with Office 2010 on Windows 7 64bit
If I run a standalone VBScript I can access Excel just fine. However exactly the same code,
throws the following error,
An exception occurred in the "<my js source file>" unit at line xxx:
ADODB.Connection
Provider cannot be found. It may not be properly installed.
when running inside TestComplete 8.20.538.7
Set oCn =
CreateObject("ADODB.Connection")
Set oRS =
CreateObject("ADODB.RecordSet")
With
oCn
.Provider =
"Microsoft.ACE.OLEDB.12.0"
.ConnectionString = "Data Source=
" & CongfigFilePath & ";" & _
"Extended Properties=Excel 12.0"
.Open
End
With
throws the following error,
An exception occurred in the "<my js source file>" unit at line xxx:
ADODB.Connection
Provider cannot be found. It may not be properly installed.
when running inside TestComplete 8.20.538.7