Hi There, I Have this error when I Uploaded the page in my Host, but in my computer work excellent. (Error :System.Data.Odbc.OdbcErrorCollection)
What I do is Copy the data from a .csv file to a database in MS SQL , in Godaddy.com
This is the Code:
protected void Cargar_Click(object sender, EventArgs e)
{
if (Uploader.PostedFile.FileName == "")
{
lblInfo.Text = "No file specified.";
}
else
{
#region cargar datos
string NomArchivo = "Dsn=" + Uploader.FileName +";";
string DBQ = "dbq=" + Path.GetDirectoryName(Uploader.FileName) + ";";
string defaultdir = "dafaultdir=" + Path.GetDirectoryName(Uploader.FileName);
string camino = NomArchivo + DBQ + defaultdir + ";driverid=27;fil=text;maxbuffersize=2048;pagetimeout=5";
OdbcConnection DbConnection = new OdbcConnection(camino);
string LeerOdbc = "SELECT StoreID, OrderID, CustomerFirst, CustomerLast, OrderDate, SubTotal, ItemNumber FROM ["+ Uploader.FileName +"]";
OdbcCommand Odbccmd = new OdbcCommand(LeerOdbc, DbConnection);
OdbcDataReader reader;
SqlConnection con = new SqlConnection(connectionString);
commisionrate = Int32.Parse(txtComision.Text);
try
{
DbConnection.Open();
reader = Odbccmd.ExecuteReader();
while (reader.Read())
{
string insertSQL;
insertSQL = "INSERT INTO DataVendedor(";
insertSQL += "StoreID, OrderID, CustomerFirst, CustomerLast, OrderDate, SubTotal, ItemNumber, ";
insertSQL += "CommisionRate) VALUES (";
insertSQL += "@StoreID, @OrderID, @CustomerFirst, @CustomerLast, @OrderDate, @SubTotal, @ItemNumber, ";
insertSQL += "@CommisionRate)";
SqlCommand cmd = new SqlCommand(insertSQL, con);
cmd.Parameters.AddWithValue("@StoreID", reader["StoreID"].ToString());
cmd.Parameters.AddWithValue("@OrderID", reader["OrderID"].ToString());
cmd.Parameters.AddWithValue("@CustomerFirst", reader["CustomerFirst"].ToString());
cmd.Parameters.AddWithValue("@CustomerLast", reader["CustomerLast"].ToString());
cmd.Parameters.AddWithValue("@OrderDate", reader["OrderDate"].ToString());
cmd.Parameters.AddWithValue("@SubTotal", reader["SubTotal"].ToString());
cmd.Parameters.AddWithValue("@ItemNumber", reader["ItemNumber"].ToString());
cmd.Parameters.AddWithValue("@CommisionRate", commisionrate);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception err)
{
lblInfo.Text += "Error inserting record. " + err.Message;
}
finally
{
con.Close();
}
}
}
catch (OdbcException ex)
{
lblInfo.Text += "Error :" + ex.Errors;
lblInfo.Text += "<br />" + camino;
}
finally
{
DbConnection.Close();
Response.Redirect("~/Default.aspx");
lblInfo.Text = " Database Update ";
}
#endregion
}
}
I tried everything, always is working good in my computer, but not when I Publish the Web Site.
Even I tried to fix the file in one specific place, still nothing!!!!!!!!!!!!
Help!!!!!!!!!!!!!!!!!!!!!!!!!!