If you try to install the 64 bit version of SQLite on your Windows 7 64 bit system, you’ll find that your code will break. It simply won’t work. You’ll also find that when you try to add a connection in “Server Explorer” inside of Visual Studio, that there’s no option for making a SQLite connection.
Click here to follow me on Google+.
Follow me on Twitter @CSharpner.
This is because, for some reason, none of the current versions have the install for a SQLite connector. For that, you’ll have to install the really old version 1.0.66.0 executable first. After that, you can install the latest 32bit version (the 64bit version doesn’t work). Once 1.0.66.0 is installed, you’ll have SQLite available in Visual Studio:
You can get v 1.0.66.0 from here:
You can download the 32bit DLLs here sqlite-netFx35-setup-bundle-x64-2008-1.0.77.0.zip:. It’s under the section titled “Precompiled binaries for Windows”.
See these images?
You’ll find an actual working versions of them at the top and bottom of this article. Please click the appropriate buttons in it to let your friends know about this article.
Check back later for updates too!
Click here to follow me on Google+.
Follow me on Twitter @CSharpner.
[poll id=”3″]
That’s it. Good luck!