User-1314346660 posted
Hello Experts,
I have a web application that needs to push data to an SQLite db that is on the user machine. It is quite straight forward. It takes data from an Azure SQL db and pushes to the local SQLite db.
The SQLite db is here:
string ConnectionStringDestination = @"Data Source=C:\TestSQLite\Testdb.db;Version=3;";
And here is my code to push:
protected void Button1_Click(object sender, EventArgs e)
{
string connString = @"My Conn";
string ConnectionStringDestination = @"Data Source=C:\TestSQLite\Testdb.db;Version=3;";
var tblBatchNumbers = new DataTable();
using (var da = new SqlDataAdapter("exec spBatchNumbers", connString))
//using (var da = new SqlDataAdapter("SELECT BatchNumber,Programme FROM BatchNumbers", connString))
{
da.Fill(tblBatchNumbers);
}
SQLiteConnection cons = new SQLiteConnection(ConnectionStringDestination,true);
cons.Open();
SQLiteCommand Command = new SQLiteCommand("DELETE FROM BatchNumbers", cons);
Command.ExecuteNonQuery();
cons.Close();
using (SQLiteConnection con = new SQLiteConnection(ConnectionStringDestination,true))
{
con.Open();
using (SQLiteTransaction transaction = con.BeginTransaction())
{
foreach (DataRow row in tblBatchNumbers.Rows)
{
using (SQLiteCommand sqlitecommand = new SQLiteCommand("INSERT INTO BatchNumbers(RecordId,BatchNumber,ExpiryDate,Programme,Route,Dose) VALUES ('"
+ Convert.ToString(row[0]) + "','"
+ Convert.ToString(row[1]) + "','"
+ Convert.ToString(row[2]) + "','"
+ Convert.ToString(row[3]) + "','"
+ Convert.ToString(row[4]) + "','"
+ Convert.ToString(row[5]) + "')", con))
{
sqlitecommand.ExecuteNonQuery();
}
}
transaction.Commit();
}
}
}
It all works brilliantly when running in Local Host. However, once I deploy the app to Azure then the process fails. Here is the error:
[SQLiteException (0xe): unable to open database file]
System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) +644
System.Data.SQLite.SQLiteConnection.Open() +5579
HTML5OfflineApplication.BulkCopy_DataTableToSQLLite.Button1_Click(Object sender, EventArgs e) in C:\Users\Me\OneDrive - Me\Visual Studio\source\repos\Offline\Offline\Secure\BulkCopy_DataTableToSQLLite.aspx.cs:32
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +109
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +12
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +15
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +31
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3470
I think that the error is caused by the application not being able to reference/find the database. The file and folder has WRITE access.
Any ideas. I have drawn a blank on this now for 48hrs!!!!!!
Thanks very much always.
Billson3000
