insert into error not recognized

[Antonio D'Ottavio]

Good morning,
I've the following error
Syntax error in INSERT INTO statement
But I do not found any error in this code

OleDbconn = new OleDbConnection(sConnessioneDb);
string insertCmd = "insert into Organizzatori (NomeUtente, Password,
Nome, Cognome, IndirizzoPostaElettronica, Telefono) values ('eta' , 'eco' ,
'Antonioff' , 'ferfe' , 'p*********@etantonio.it' , '333333')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, OleDbconn);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException ex)
{
lblMsg1.Text = ex.Message ;
}
myCommand.Connection.Close();

Can you help me to discover the problem, I'm using an Access DB.

Many thanks

Antonio D'Ottavio

[James Jenkins]

"Antonio D'Ottavio" <po********@etantonio.it> wrote in message
news:eN**************@TK2MSFTNGP14.phx.gbl...

Good morning,
I've the following error
Syntax error in INSERT INTO statement
But I do not found any error in this code

OleDbconn = new OleDbConnection(sConnessioneDb);
string insertCmd = "insert into Organizzatori (NomeUtente, Password,
Nome, Cognome, IndirizzoPostaElettronica, Telefono) values ('eta' , 'eco'
,
'Antonioff' , 'ferfe' , 'po********@etantonio.it' , '333333')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, OleDbconn);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException ex)
{
lblMsg1.Text = ex.Message ;
}
myCommand.Connection.Close();

Can you help me to discover the problem, I'm using an Access DB.

Many thanks

Antonio D'Ottavio

Hi Antonio,
Have you checked the value types - e.g: is the '333333' a string or a long
value within database?

[Siva M]

I think 'password' is a reserved word in Jet. Try enclosing it in square
brackets ([]).

"Antonio D'Ottavio" <po********@etantonio.it> wrote in message
news:eN**************@TK2MSFTNGP14.phx.gbl...
Good morning,
I've the following error
Syntax error in INSERT INTO statement
But I do not found any error in this code

OleDbconn = new OleDbConnection(sConnessioneDb);
string insertCmd = "insert into Organizzatori (NomeUtente, Password,
Nome, Cognome, IndirizzoPostaElettronica, Telefono) values ('eta' , 'eco' ,
'Antonioff' , 'ferfe' , 'po********@etantonio.it' , '333333')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, OleDbconn);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException ex)
{
lblMsg1.Text = ex.Message ;
}
myCommand.Connection.Close();

Can you help me to discover the problem, I'm using an Access DB.

Many thanks

Antonio D'Ottavio

[Antonio D'Ottavio]

I've changed the password filed with a pwd file, but I've again the error
....
Thanks the same

"Siva M" <sh******@online.excite.com> ha scritto nel messaggio
news:eI**************@TK2MSFTNGP14.phx.gbl...

I think 'password' is a reserved word in Jet. Try enclosing it in square
brackets ([]).

"Antonio D'Ottavio" <po********@etantonio.it> wrote in message
news:eN**************@TK2MSFTNGP14.phx.gbl...
Good morning,
I've the following error
Syntax error in INSERT INTO statement
But I do not found any error in this code

OleDbconn = new OleDbConnection(sConnessioneDb);
string insertCmd = "insert into Organizzatori (NomeUtente, Password, Nome, Cognome, IndirizzoPostaElettronica, Telefono) values ('eta' , 'eco' , 'Antonioff' , 'ferfe' , 'po********@etantonio.it' , '333333')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, OleDbconn);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException ex)
{
lblMsg1.Text = ex.Message ;
}
myCommand.Connection.Close();

Can you help me to discover the problem, I'm using an Access DB.

Many thanks

Antonio D'Ottavio

[Antonio D'Ottavio]

The field phone is a string ... I think is it right in this way, hope so
"James Jenkins" <Ja***@noSPAMtamarsolutions.co.uk> ha scritto nel messaggio
news:uZ*************@TK2MSFTNGP15.phx.gbl...

"Antonio D'Ottavio" <po********@etantonio.it> wrote in message
news:eN**************@TK2MSFTNGP14.phx.gbl...

Good morning,
I've the following error
Syntax error in INSERT INTO statement
But I do not found any error in this code

OleDbconn = new OleDbConnection(sConnessioneDb);
string insertCmd = "insert into Organizzatori (NomeUtente, Password, Nome, Cognome, IndirizzoPostaElettronica, Telefono) values ('eta' , 'eco' ,
'Antonioff' , 'ferfe' , 'po********@etantonio.it' , '333333')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, OleDbconn);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException ex)
{
lblMsg1.Text = ex.Message ;
}
myCommand.Connection.Close();

Can you help me to discover the problem, I'm using an Access DB.

Many thanks

Antonio D'Ottavio
Hi Antonio,
Have you checked the value types - e.g: is the '333333' a string or a

long value within database?

[Rick Lones]

Antonio D'Ottavio wrote:

Good morning,
I've the following error
Syntax error in INSERT INTO statement
But I do not found any error in this code

OleDbconn = new OleDbConnection(sConnessioneDb);
string insertCmd = "insert into Organizzatori (NomeUtente, Password,
Nome, Cognome, IndirizzoPostaElettronica, Telefono) values ('eta' , 'eco' ,
'Antonioff' , 'ferfe' , 'p*********@etantonio.it' , '333333')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, OleDbconn);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException ex)
{
lblMsg1.Text = ex.Message ;
}
myCommand.Connection.Close();

Can you help me to discover the problem, I'm using an Access DB.

Many thanks

Antonio D'Ottavio

Antonio,

Have you tried using the .Net debugger to simply pick up your insertCmd string
at the point you are ready to send it and pasting it exactly as built into the
Access SQL window? Does that work? If not, your problem is indeed with the
syntax, not a .Net problem at all.

HTH,
-rick-

[Yosh]

try removing the '@' in the email and see if it works. for grins.

"Antonio D'Ottavio" <po********@etantonio.it> wrote in message
news:eN**************@TK2MSFTNGP14.phx.gbl...

Good morning,
I've the following error
Syntax error in INSERT INTO statement
But I do not found any error in this code

OleDbconn = new OleDbConnection(sConnessioneDb);
string insertCmd = "insert into Organizzatori (NomeUtente, Password,
Nome, Cognome, IndirizzoPostaElettronica, Telefono) values ('eta' , 'eco'
,
'Antonioff' , 'ferfe' , 'po********@etantonio.it' , '333333')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, OleDbconn);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException ex)
{
lblMsg1.Text = ex.Message ;
}
myCommand.Connection.Close();

Can you help me to discover the problem, I'm using an Access DB.

Many thanks

Antonio D'Ottavio

[William \(Bill\) Vaughn]

You will be fighting with this block of code from now until the water's
pumped out of New Orleans if you don't convert it to a Parameter-based
Command. The Parameters handle the framing issues (some of which you have
not encountered yet) and other issues that you have seen.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Antonio D'Ottavio" <po********@etantonio.it> wrote in message
news:eN**************@TK2MSFTNGP14.phx.gbl...

Good morning,
I've the following error
Syntax error in INSERT INTO statement
But I do not found any error in this code

OleDbconn = new OleDbConnection(sConnessioneDb);
string insertCmd = "insert into Organizzatori (NomeUtente, Password,
Nome, Cognome, IndirizzoPostaElettronica, Telefono) values ('eta' , 'eco'
,
'Antonioff' , 'ferfe' , 'po********@etantonio.it' , '333333')";
OleDbCommand myCommand = new OleDbCommand(insertCmd, OleDbconn);
myCommand.Connection.Open();
try
{
myCommand.ExecuteNonQuery();
}
catch (OleDbException ex)
{
lblMsg1.Text = ex.Message ;
}
myCommand.Connection.Close();

Can you help me to discover the problem, I'm using an Access DB.

Many thanks

Antonio D'Ottavio