File .CSV Error :System.Data.Odbc.OdbcErrorCollection Help!!!!!!!!!!!

Last post 12-02-2008 4:26 PM by luisbragagnolo@hotmail.com. 0 replies.

Sort Posts:

  • File .CSV Error :System.Data.Odbc.OdbcErrorCollection Help!!!!!!!!!!!

    12-02-2008, 4:26 PM

     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!!!!!!!!!!!!!!!!!!!!!!!!!!

Page 1 of 1 (1 items)