Hi,
I have a windows app that works great. I can run it on other machines and it still works great. I also wrote a web app that runs locally and displays html pages. I want my web app to read a value from the database (sqlite db) and display one of two start pages based on the value from the database.

So I have a datagrid and datasource on my web app that are set up like this:
<asp:GridView ID="GridView1" runat="server" DataSourceID="BEData" Visible="False">
</asp:GridView>
&nbsp;
<asp:SqlDataSource ID="BEData" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString3 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString3.ProviderName %>" SelectCommand="SELECT [is_run] FROM [personalize_info]">
</asp:SqlDataSource>

In my web.config file I have the following connection string defined:
<connectionStrings>
<add name="ConnectionString3" connectionString="Data Source=c:\Program Files\BE folder\myData.db"
providerName="System.Data.SQLite" />
</connectionStrings>

When my web app opens I look at the datagrid and load a page based on the value I find there.

This works great on my development machine using the development server.

I created an install package that puts the primary output from the windows app, the contents files from the web app and the database in the application folder. I installed it on my development machine and run it with the ultidev cassini server. It works perfectly.

If I install it on any other machine the web app acts like it cannot find the database. If I display the datagrid, it is always nothing. It should contain a 0 or a 1. It does on my development machine but not on any other machine - it is just nothing. I do not get any errors.

Does anyone know why this is happening and what I can do to read a value from my database on a machine that is not my development machine?

Thanks for any help.