Why is the SQLite provider missing from the Server Explorer Add Connection dialogue?
Ensure the data tools for visual studio were installed correctly as per:
http://www.basarat.com/2010/05/sqlite-for-visual-studio-2010.html
There are various fixes listed, making sure there weren't older tools installed first, etc. I'm going to give it a try, but the article may help you out.