cancel
Showing results for 
Search instead for 
Did you mean: 

Database Checkpoint For MS Access 2016 Database

SOLVED
Occasional Contributor

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?

3 REPLIES
Community Hero

Re: Database Checkpoint For MS Access 2016 Database

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.


Robert Martin
[Community Expert Group]
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
Extensions available
Occasional Contributor

Re: Database Checkpoint For MS Access 2016 Database

Sorry I forgot to respond.   It was an access database created in a 32bit version of access 2013.   Ran it up in the 32bit version of TestComplete and it's working like a charm.   Thanks for the advice Smiley Happy

Community Hero

Re: Database Checkpoint For MS Access 2016 Database

Hi,

 

>  It was an access database created in a 32bit version of access 2013.

Just to make things clear: It does not matter what version and what bitness of Access was used to create the file.

What does matter is the bitness of TestComplete and OLEDB provider (ODBC driver) used to access the file (database). Bitnesses must correspond. This is the OS requirement and it is caused by the fact that TestComplete uses OLEDB COM engine to access databases and COM communication requires that COM server and client are of the same bitness.

 

P.S. https://support.smartbear.com/viewarticle/63975/ describes one possible workaround, but the article dates back to the times when only 32-bit flavor of TestComplete existed. Nowadays it is usually more convenient to use TestComplete of the appropriate bitness.

 

Regards,
Alex
[Community Expert Group]
____
[Community Expert Group] members are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Postings made by [Community Expert Group] members
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
[Community Expert Group] signature is used with permission by SmartBear Software.
http://smartbear.com/forums/f83/t86934/community-experts/
================================
2018 NEWS
Top Kudoed Authors