Link to home
Start Free TrialLog in
Avatar of trevor1940
trevor1940

asked on

How to connect to an SQLite database in Visual Studio

Hi
I have Visual Studio community 2015 Update1 running on windows 7 64bit


This page only seems to provide links to 2015 update 3

Once I've installed the correct extensions and added to my first DB project using a windows application
how do I show  the results of a query on a user form?
SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of trevor1940
trevor1940

ASKER

The link you provided points to a version of ADO no longer supported this  in turn points to the the download page in my opening remarks

I've attempted to  install sqlite-netFx46-setup-bundle-x64-2015-1.0.106.0.exe  from that page but don't have the required data connectors in visual studio

iUser generated image
Maybe I've not asked correctly

Which version of System.Data.SQLite do I need
I think you should use the latest version.
I think you should use the latest version.

I did and I'm no further forward
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
glad you got it. Cheers.
Avatar of sarabande
for me its the Setups for 32-bit Windows (.NET Framework 4.6)

Visual Studio itself is a 32-bit windows application. you can verify that it installs under 'Program Files (x86)'. nevertheless you could use VS to create 64-bit applications (a similar thing happened 25 years ago when vs went from 16-bit to 32-bit). so all tools and wizards and dll's around VS are 32-bit windows programs as well because 32-bit modules cannot be mixed with 64-bit and vice versa.

Sara
Expert solution didn't solve the problem  I did

In this context I'm being generous saying he assisted, read entire question for further details