INSERT syntax error

[Berend]

when I try to write to a database I get a syntax error
I made the code a simple as possible bur also the VS generated code
gives the same error. WHY?
private void button1_Click(o bject sender, System.EventArg s e)
{
string strSQL;
strSQL = "INSERT INTO Overwerk(datum , begin, eind, omschrijving)
VALUES('10-01-2004', '12:00', '16:00', 'Test')";

string strDSN = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=\\data\\ Uren.MDB";
OleDbConnection oleDbConnUren = new OleDbConnection (strDSN);
OleDbCommand myCmd = new OleDbCommand( strSQL, oleDbConnUren );
try
{
oleDbConnUren.O pen();
myCmd.ExecuteNo nQuery();
}
catch (Exception ex)
{
Console.WriteLi ne("Error:\n{0} ", ex.Message);
}
finally
{
oleDbConnUren.C lose();
}

}

[Ben Dewey]

Berend,

1. Where do you get the error, trying to open the connection or executing
the query?

2. Can you execute the query successfully in a microsoft access query
window?
<Berend> wrote in message news:N7******** *************** ***@4ax.com...

when I try to write to a database I get a syntax error
I made the code a simple as possible bur also the VS generated code
gives the same error. WHY?
private void button1_Click(o bject sender, System.EventArg s e)
{
string strSQL;
strSQL = "INSERT INTO Overwerk(datum , begin, eind, omschrijving)
VALUES('10-01-2004', '12:00', '16:00', 'Test')";

string strDSN = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=\\data\\ Uren.MDB";
OleDbConnection oleDbConnUren = new OleDbConnection (strDSN);
OleDbCommand myCmd = new OleDbCommand( strSQL, oleDbConnUren );
try
{
oleDbConnUren.O pen();
myCmd.ExecuteNo nQuery();
}
catch (Exception ex)
{
Console.WriteLi ne("Error:\n{0} ", ex.Message);
}
finally
{
oleDbConnUren.C lose();
}

}

[William Ryan eMVP]

Is this the actual code? If you are getting a syntax error the likely
causes are you are using a Reserved word (from Access in the field name
http://www.knowdotnet.com/articles/reservedwords.html) or you have an
apostrophe somehwere in there.

Put a breakpoint right before the executenonquery and lets see exactly
what's blowing up, the most likely causes are one of the two and since you
mention this isn't thequery used, it's the most likely.

HTH,

Bill
www.devbuzz.com
www.knowdotnet.com

<Berend> wrote in message news:N7******** *************** ***@4ax.com...

when I try to write to a database I get a syntax error
I made the code a simple as possible bur also the VS generated code
gives the same error. WHY?
private void button1_Click(o bject sender, System.EventArg s e)
{
string strSQL;
strSQL = "INSERT INTO Overwerk(datum , begin, eind, omschrijving)
VALUES('10-01-2004', '12:00', '16:00', 'Test')";

string strDSN = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=\\data\\ Uren.MDB";
OleDbConnection oleDbConnUren = new OleDbConnection (strDSN);
OleDbCommand myCmd = new OleDbCommand( strSQL, oleDbConnUren );
try
{
oleDbConnUren.O pen();
myCmd.ExecuteNo nQuery();
}
catch (Exception ex)
{
Console.WriteLi ne("Error:\n{0} ", ex.Message);
}
finally
{
oleDbConnUren.C lose();
}

}

[Berend]

William and Ben thanks for your quick respond

Adding brackets to the field names solved the problem
I wil look for the reserved word an change him

Berend
On Mon, 10 May 2004 14:13:01 -0400, "William Ryan eMVP"
<do********@com cast.nospam.net > wrote:

Is this the actual code? If you are getting a syntax error the likely
causes are you are using a Reserved word (from Access in the field name
http://www.knowdotnet.com/articles/reservedwords.html) or you have an
apostrophe somehwere in there.

Put a breakpoint right before the executenonquery and lets see exactly
what's blowing up, the most likely causes are one of the two and since you
mention this isn't thequery used, it's the most likely.

HTH,

Bill
www.devbuzz.com
www.knowdotnet.com

<Berend> wrote in message news:N7******** *************** ***@4ax.com...

when I try to write to a database I get a syntax error
I made the code a simple as possible bur also the VS generated code
gives the same error. WHY?
private void button1_Click(o bject sender, System.EventArg s e)
{
string strSQL;
strSQL = "INSERT INTO Overwerk(datum , begin, eind, omschrijving)
VALUES('10-01-2004', '12:00', '16:00', 'Test')";

string strDSN = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=\\data\\ Uren.MDB";
OleDbConnection oleDbConnUren = new OleDbConnection (strDSN);
OleDbCommand myCmd = new OleDbCommand( strSQL, oleDbConnUren );
try
{
oleDbConnUren.O pen();
myCmd.ExecuteNo nQuery();
}
catch (Exception ex)
{
Console.WriteLi ne("Error:\n{0} ", ex.Message);
}
finally
{
oleDbConnUren.C lose();
}

}

[William Ryan eMVP]

Glad it worked.

Cheers,

Bill

www.devbuzz.com
www.knowdotnet.com

<Berend> wrote in message news:es******** *************** ***@4ax.com...

William and Ben thanks for your quick respond

Adding brackets to the field names solved the problem
I wil look for the reserved word an change him

Berend
On Mon, 10 May 2004 14:13:01 -0400, "William Ryan eMVP"
<do********@com cast.nospam.net > wrote:

Is this the actual code? If you are getting a syntax error the likely
causes are you are using a Reserved word (from Access in the field name
http://www.knowdotnet.com/articles/reservedwords.html) or you have an
apostrophe somehwere in there.

Put a breakpoint right before the executenonquery and lets see exactly
what's blowing up, the most likely causes are one of the two and since youmention this isn't thequery used, it's the most likely.

HTH,

Bill
www.devbuzz.com
www.knowdotnet.com

<Berend> wrote in message news:N7******** *************** ***@4ax.com...

when I try to write to a database I get a syntax error
I made the code a simple as possible bur also the VS generated code
gives the same error. WHY?
private void button1_Click(o bject sender, System.EventArg s e)
{
string strSQL;
strSQL = "INSERT INTO Overwerk(datum , begin, eind, omschrijving)
VALUES('10-01-2004', '12:00', '16:00', 'Test')";

string strDSN = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=\\data\\ Uren.MDB";
OleDbConnection oleDbConnUren = new OleDbConnection (strDSN);
OleDbCommand myCmd = new OleDbCommand( strSQL, oleDbConnUren );
try
{
oleDbConnUren.O pen();
myCmd.ExecuteNo nQuery();
}
catch (Exception ex)
{
Console.WriteLi ne("Error:\n{0} ", ex.Message);
}
finally
{
oleDbConnUren.C lose();
}

}

[Joris Janssens]

Berend <> wrote in news:N7******** *************** ***@4ax.com:

when I try to write to a database I get a syntax error
I made the code a simple as possible bur also the VS generated code
gives the same error. WHY?
private void button1_Click(o bject sender, System.EventArg s e)
{
string strSQL;
strSQL = "INSERT INTO Overwerk(datum , begin, eind, omschrijving)
VALUES('10-01-2004', '12:00', '16:00', 'Test')";

string strDSN = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=\\data\\ Uren.MDB";

doesn't the date have to be surrounded by ## instead of '' when working
with Access?

#10-01-2004# or maybe #10/01/2004#
--
Joris "flotspe" Janssens
http://www.xhtml.be/inferno/
Don't wait for the Grim Reaper,
I'm going to mow you down!