"Provider cannot be found. It may not be properly installed"
i installled Test Complete 12.5 on my workstationtoday, and converted a project from 11.3. in the new version of test complete the project gets the error "Provider cannot be found. It may not be properly installed" when it tries to open a ado database connection to an access database. i can still run the old version of test complete on the old source code and it works
here is the code (i aded an * over the name of the datbase and datbase password. the error happens on the acon.Open line
any idea why this would be happenning?
function updateRecordAccess (dbtable, dbcolumn, newvalue, wherecolumn, wherevalue)
Set aCon = ADO.CreateConnection
aCon.ConnectionString = "Provider=Microsoft.jet.oledb.4.0;Data Source=" & projectsuite.variables.PathToData & "\*****c.mdb;Jet OLEDB:database password=*********"
Set aCmd = ADO.CreateCommand
aCmd.CommandTimeout = 1000
Set aCmd.ActiveConnection = aCon
aCmd.CommandType = adCmdText
aCmd.CommandText = "update " & dbtable & " set " & dbtable & "." & dbcolumn & " = '" & newvalue & "' where " & wherecolumn & " = '" & wherevalue & "'"
updateRecordAccess = returnvalue
Solved! Go to Solution.
Starting with 12.40, TestComplete installs a 64-bit version and a 32-bit version of itself on the machine, defaulting all short-cuts to the 64-bit version. I'm guessing that the driver for your Access Database is a 32-bit driver. You may need to update the driver to include the 64-bit version on your worksation.
Additionally, you could change your TestComplete shortcut/execution to use the installed 32-bit driver. Go to C:\Program Files (x86)\SmartBear\TestComplete 12\Bin and run the copy found there.
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
Why automate? I do automated testing because there's only so much a human being can do and remain healthy. Sleep is a requirement. So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.
Mysterious Gremlin Master
Vegas Thrill Rider