Ask a Question

"Provider cannot be found. It may not be properly installed"

SOLVED
lowens
New Contributor

"Provider cannot be found. It may not be properly installed"

Hello

  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=*********"

aCon.Open
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 & "'"
aCmd.Execute
aCon.Close
updateRecordAccess = returnvalue
end function

1 ACCEPTED SOLUTION

Accepted Solutions
tristaanogre
Community Hero

Re: "Provider cannot be found. It may not be properly installed"

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.

 

 


Robert Martin
[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
Extensions available

View solution in original post

2 REPLIES 2
tristaanogre
Community Hero

Re: "Provider cannot be found. It may not be properly installed"

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.

 

 


Robert Martin
[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
Extensions available

View solution in original post

lowens
New Contributor

Re: "Provider cannot be found. It may not be properly installed"

Yes that was it thanks

cancel
Showing results for 
Search instead for 
Did you mean: