CODEWITHSUNDEEP
vb.netsqliteconnectionadoadodb
Pooh
Pooh

Reputation: 105

Connection string to a SQLite Database using ADODC/ADODB

Can ADODC/ADODB be used to connect to SQLite?

There is a reference that can be used? SYSTEM.DATA.SQLITE (It is not efficient)

Can you suggest me any other references (If not ADO)?

I want to use VB.NET to connect to a SQLite backend.

Upvotes: 0

Views: 4100

Answers (1)

Linken
Linken

Reputation: 122

I Use ADODB Recordset to connect on SQLite database. For that You need this provider and 

"DRIVER=SQLite3 ODBC Driver;Database=" & BasePath

for the connection string.

Beware of some restrictions : SQLite has no defined type for each field. Therefore if you misspell a date format or float, the provider with give you an error when you try to update the record.

Upvotes: 1

Related Questions