asp.net c# oledbconnection InvalidOperationException

Question

Error: Unrecognised escape sequence.

Code:

    string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DriveBuy.accdb";
    OleDbConnection con = new OleDbConnection(ConnectionString);


    if (FileUpload1.HasFile) 
    {
        String sPath = MapPath(FileUpload1.FileName);
        FileUpload1.PostedFile.SaveAs(sPath); 

        con.Open();
        string mysql; 
        mysql = "INSERT INTO Cars(Make,Model,Price,Picture) VALUES (?,?,?,?)";
        OleDbCommand cmd = new OleDbCommand(mysql, con);
        cmd.Parameters.AddWithValue("@p1", tbMake.Text);
        cmd.Parameters.AddWithValue("@p2", tbModel.Text);
        cmd.Parameters.AddWithValue("@p3", Convert.ToDecimal(tbPrice.Text));
        cmd.Parameters.AddWithValue("@p4", FileUpload1.FileName);
        cmd.ExecuteNonQuery();
        con.Close();
    }
    else
    {
        lblError.Text = "Image was not uploaded";
    }

Any ideas? I'm simply trying to input the data into a access database. The error appears on the connection string, the "\"

Cheers

It might be from ConnectionString = "" and VALUES (?,?,?,?). — Win
– Win, Commented May 9, 2013 at 13:55

Dimitar Dimitrov · Accepted Answer · 2013-05-09 14:44:29Z

1

You're passing an empty connection string

 string ConnectionString = "";

In order to connect to your database you need to specify a valid connection string. This site might be helpful.

EDIT

Data directory is supposed to be the directory of your access db

// fix your data source to the correct directory
string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\DriveBuy.accdb";

EDIT2

Sorry your parameters are in fact correct as pointed in the comments by D Stanley, thanks.

edited May 9, 2013 at 14:44

answered May 9, 2013 at 13:39

Dimitar Dimitrov

15.2k9 gold badges55 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Chris Over a year ago

I forgot to put in my connection string, sorry. Updated still errors.

D Stanley Over a year ago

OleDb provider does not support named parameters. VALUES (?,?,?,?) should be correct.

Dimitar Dimitrov Over a year ago

Ooops you're right. Thanks for pointing it out. Also I hate how every provider uses parameters differently. It caused a lot of bloatware SQL stuff been written over the years.

Chris Over a year ago

Worked, thank you. Only problem is I'll have to edit the directory when moving between computers. Ah well it works.

Dimitar Dimitrov Over a year ago

Glad it did, ideally you should move the connection string in your config and change it there once your in another computer. Should be easier than recompiling your code.

Amit Mittal · Accepted Answer · 2013-05-09 14:34:41Z

0

Instead of:

string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DriveBuy.accdb";

Do this:

string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\DriveBuy.accdb";

or this:

string ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\DriveBuy.accdb";

The error is coming because in C# "\" is an escape sequence used for special meanings in the string. For eg, \n means newline etc. So we've to use double backslash so that compiler donot treat back slash as an escape sequence.

edited May 9, 2013 at 14:34

answered May 9, 2013 at 14:29

Amit Mittal

1,14711 silver badges31 bronze badges

Collectives™ on Stack Overflow

asp.net c# oledbconnection InvalidOperationException

Code:

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Code:

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related