Forum Discussion

simonaferrara's avatar
simonaferrara
Frequent Contributor
2 years ago
Solved

Database connection - Provider not found

Hi,

 

I'm trying to access to a SQLLite database, by following the instructions and the examples explained within the page:

https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/databases/ado-components.html

so, for example, I'm using the following code to open the connection:

 

var Conn = getActiveXObject("ADODB.Connection");
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Users\\Public\\Documents\\TestComplete 15 Samples\\Desktop\\Checkpoints\\XML\\DataGridViewSample\\OrdersDB.mdb";
Conn.Open();

 

But the Open connection function returns the following error: "Provider cannot be found. It may not be properly installed" .

 

I've tried to resolve by installing the "Microsoft Office Access database engine 2007", "Microsoft Office Access database engine 2010" (both x64 and x32 bit), but there is still the same error.

 

Can you please help me to understand what I've to install to make the provider found?

 

Thanks

Simona