An unhandled exception of type 'system.data.oledb.oledbexception' occurred in system.data.dll invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

Question

0.00/5 (No votes)

See more:

code

DateTime d = DateTime.Now;
                string dd = d.Day + "," + d.Month;
                string dbname = textBox1.Text;
                OleDbConnection conn = new OleDbConnection();
                conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:/dipti/Data/ERPDB.accdb";
                conn.Open();
            //string str = "USE " + dbname + ";";
            string str1 = "backup database" + dbname + "to disk = 'E:\\database\\" + dbname + "_" + dd + ".bak";
            //OleDbCommand cmd1 = new OleDbCommand(str, conn);
            OleDbCommand cmd2 = new OleDbCommand(str1, conn);
            // cmd1.ExecuteNonQuery();
            cmd2.ExecuteNonQuery();
                MessageBox.Show("Successfully");
                conn.Close();

What I have tried:

please help

<pre>DateTime d = DateTime.Now;
                string dd = d.Day + "," + d.Month;
                string dbname = textBox1.Text;
                OleDbConnection conn = new OleDbConnection();
                conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:/dipti/Data/ERPDB.accdb";
                conn.Open();
            //string str = "USE " + dbname + ";";
            string str1 = "backup database" + dbname + "to disk = 'E:\\database\\" + dbname + "_" + dd + ".bak";
            //OleDbCommand cmd1 = new OleDbCommand(str, conn);
            OleDbCommand cmd2 = new OleDbCommand(str1, conn);
            // cmd1.ExecuteNonQuery();
            cmd2.ExecuteNonQuery();
                MessageBox.Show("Successfully");
                conn.Close();

Posted 31-Oct-19 21:10pm

Member 13659928

Updated 1-Nov-19 8:27am

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2019-10-31T21:21:00

Solution 1

You missed the closing quote:

C#

string str1 = "backup database" + dbname + "to disk = 'E:\\database\\" + dbname + "_" + dd + ".bak";

                                                      ^

Posted 31-Oct-19 21:21pm

OriginalGriff

Comments

Richard Deeming 1-Nov-19 14:19pm

I don't think that's going to help - the code is connecting to an Access database. :)

Richard Deeming · Answer 2 · 2019-11-01T08:28:00

BACKUP DATABASE is a SQL Server command. You are connecting to an MS Access database.

To backup an Access database, you just need to copy the database file.

C#

string sourceFile = @"F:\dipti\Data\ERPDB.accdb";
string destinationFile = @"E:\database\" + dbname + "_" + dd + ".bak";
System.IO.File.Copy(sourceFile, destinationFile, overwrite: true);

An unhandled exception of type 'system.data.oledb.oledbexception' occurred in system.data.dll invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

An unhandled exception of type 'system.data.oledb.oledbexception' occurred in system.data.dll invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us