karthik_p30
11 years agoNew Contributor
how to connect a jdbc driver
Hi,
I am new to TestComplete. We have a database(*.db) which was created using SqliteJDBC driver.
I need to add a test case to validate the database.
I tried using Database table checkpoint, where i tried with all OLE providers which came to failure.
Is there any ways to connect the database extension with .db
thanks in advance.
I am new to TestComplete. We have a database(*.db) which was created using SqliteJDBC driver.
I need to add a test case to validate the database.
I tried using Database table checkpoint, where i tried with all OLE providers which came to failure.
Is there any ways to connect the database extension with .db
thanks in advance.
- Hi Karthik,
I did not read in details everything that was returned by this Google query:
http://www.google.com.ua/search?q=how+to+access+sqlite+database+with+ODBC+driver
but it looks like that there is ODBC driver (http://www.ch-werner.de/sqliteodbc/) that might be used. Also it looks like that there is a way to link sqlite table(s) to MS Access database and access then this MS Access database via OLE DB or ODBC (http://sqlite.awardspace.info/syntax/sqliteodbc.htm and http://stackoverflow.com/questions/19658747/updating-an-sqlite-database-via-an-odbc-linked-table-in-access that, actually, use the abovementioned ODBC driver).
Hope this will help...
P.S. And my recommendation will be to use Access and ODBC driver(s) of the same bitness, namely - 32-bit even if your OS is 64-bit.