Database Checkpoint For MS Access 2016 Database
I'm attempting to create a Database Checkpoint in a TestComplete test.
The database is an MS Access 2016 accdb file and I'm running on Win7x64 as an unprivileged user on the corporate domain.
In the first dialog (yes, i hit the deck and slid on my face at the first prompt) it prompts for a connection string. I am feeding it:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\SharedData\AccessDatabase.accdb;Persist Security Info=False;
and getting error:
Unable to connect to the specified data source. The database engine reports: Provider cannot be found. It may not be properly installed.
I've had a bit of a dig around online but couldn't find the answer. Any tips guys?
What bit-ness of TestComplete are you running? By default, starting with TC 12.4x, TestComplete runs as 64-bit. If the provider/driver you're using is 32-bit, then TC as 64-bit can't see it. You can run the 32-bit version of TC by finding it at C:\Program Files (x86)\SmartBear\TestComplete 12\bin\testcomplete.exe. Try running that version with your code and see if it works.