System.Data.SQLite

 Yeah, you are right.  You can still use System.Data.SQLite with Express 2008 as long as you don't need design time support.  I just built a temp app and it works fine. Just add the reference to it for the project and you are good to go.  JB 

Hi,  Unfortuately, that looks like the same error message myself and others have received when using Visual Basic 2008 Express. Robert (maintainer of the provider) has posted that Microsoft defeated the way he was able to get the provider to work with Design Time support.  It works fine in Visual Basic Express 2005, but not in ...

Hi Albert,  Does the green line tell you anything if your mouse pointer hovers over it?  Have you tried the following: Add a reference to System.Data.SQLite by going to  Project - Add Reference and choosing System.Data.SQLite? Then you can add your 'Imports' statement to the top of your class like: File name is Form1.vb ...

[quote user="Robert Simpson"] I still need to download an Express edition and test it there ... however, it appears as though MS plugged that little hole that allowed me to operate in Express Editions of Visual Studio.  I can confirm that on a Vista testbed with only VS2008 (full) installed, the SQLite provider works just fine in ...

Hello Robert and all, I'm getting the same thing with 1.0.47.2.  The exact error message I get is the following:Could not load file or assembly ‘Microsoft.VisualStudio.Data, Version=8.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxxxxxx' or one of its dependencies. The located assembly's manifest definition does not match ...

Yay!  I'm really looking forward to this.  Thanks for the hard work and being able to squeeze this project in where you can. Personally, your provider is what is keeping me away from SQL Server Compact Edition.  I love the speed of SQLite and the provider and it fits my needs to a 'T' JB

 Thanks for the response, Sam.  It's going to be just for display.  I want to show the user a column next to the 'LastDate' and show how many months it's been out.  I guess you can call this a calculated column.  The report itself is a html file with the data in a table.  I guess I can find it out ...

Hello all!  I'm trying to find the difference in months between a date column named DateCheckedOut and 'now'.  I've tried a few different things, but I haven't been able to get it right.  I've looked at the SQLite Wiki, but I either can't understand how to get what I want or it doesn't address ...

Just a FYI, I think I found something that will help eliminate the error message.  Like you said, it doesn't sound serious and this doesn't quite fit totally, but in principle, it close to the same issue.Taken from: http://msdn.microsoft.com/vstudio/express/support/issues/1.3 References to 32-bit COM components may not work in VB and C# ...

Cool.  Yeah, as far as I know, I'm referencing the right one.  Other than adding the reference under the 'Add Reference' dialog, is there any other place I can double check?  As I posted originally, it's looking at the .dll under the main 'bin' directory, not 'bin\x64'.Thanks very much!JB