Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread SQLite
Sun, Feb 3 2019 7:14 PMPermanent Link

DFL

I am trying to access a SQLite database for some quick testing I am doing.  I presume I should select Type ADO on the general tab in the database manager?  If so, does anyone know what Provider I should use?  My choices are attached.



Attachments: ProviderCapture.JPG
Mon, Feb 4 2019 8:10 PMPermanent Link

Raul

Globestar Systems

Team Elevate Team Elevate

On 2/3/2019 7:14 PM, DFL wrote:
> I am trying to access a SQLite database for some quick testing I am doing.  I presume I should select Type ADO on the general tab in the database manager?  If so, does anyone know what Provider I should use?  My choices are attached.

You do not appear to have a sqlite provider installed.

Have not used one personally to recommend but quick shows number of them
available

Raul

Sat, Feb 9 2019 12:29 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< I am trying to access a SQLite database for some quick testing I am doing.  I presume I should select Type ADO on the general tab in the database manager?  If so, does anyone know what Provider I should use?  My choices are attached. >>

I've used the SQLite ODBC Driver (via the OLEDB Provider for ODBC Drivers) before without issue.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Mar 20 2019 7:48 AMPermanent Link

DFL

Thank you. I ended up using the Devart SQLite ODBC driver as I use their LiteDac package with Delphi and was able to access my encyrpted databases directly through the Devart ODBC driver.  It seems to work well so far.



Tim Young [Elevate Software] wrote:


<< I am trying to access a SQLite database for some quick testing I am doing.  I presume I should select Type ADO on the general tab in the database manager?  If so, does anyone know what Provider I should use?  My choices are attached. >>

I've used the SQLite ODBC Driver (via the OLEDB Provider for ODBC Drivers) before without issue.

Tim Young
Elevate Software
www.elevatesoft.com
Image