Hello,
I'm trying to run a simple sql command
and always get an insert error!
syntax runs good in Access, but iis throws exeption.

code:

Sub button1_click1(ByVal Source As Object, ByVal E As EventArgs)

        Dim dbconn, dbcom
        dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("db.mdb"))
        dbconn.open()


        Dim sql As String = "INSERT INTO user([Fname[,[Lname],[email],[Country]) VALUES (nnnn,'T','[email protected]',us);"


        dbcom = New OleDbCommand(sql, dbconn)

        dbcom.ExecuteNonQuery()




[u]error</u>:

Syntax error in INSERT INTO statement.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.

Source Error:


Line 19: dbcom = New OleDbCommand(sql, dbconn)
Line 20:
Line 21: dbcom.ExecuteNonQuery


any suggestions?
thank u

Hi there.. Fname has a bad closing ].. and if nnnn and us are string, should be around '...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi there, thank you

i changed to this: but still "Insert Error" (IIS with .net engine)
 Dim dbconn, dbcom
        dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("db.mdb"))
        dbconn.open()


        Dim sql As String = "INSERT INTO user([Fname],[Lname],[email],[Country]) VALUES ('Doronnn','T','[email protected]','us');"


        dbcom = New OleDbCommand(sql, dbconn)

        dbcom.ExecuteNonQuery()

Did you try that exact query in the DB?

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

yes it works fine in db

User is a reserved word, so you can't "insert" into that .

Try renaming the table to SiteUsers or whatever users the table contains.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

thank you !!
it worked !

thanks alot