SQLite Asp.net Path

When using data source=|DataDirectory|\mydb.sqlite in Visual Studio 2008, I cannot see the tables in query builde开发者_StackOverflow社区r or in the Dataset designer. How can I fix this? It is a web application for .NET 3.5.

Thanks.

---

I have used relative path for local and |DataDirectory|\mydb.sqlite for web server. It works in this way