error: insert into

[Fry]

i fellowed the tutorial from ADO tutiral. in one chapter it teaches how to insert value to the table. i use the following code, but i got error: 3708, can anyone help?i have give permission to the account so that it is allowed to modify the mdb file. set conn = Server.CreateObject("ADODB.Connection")conn.Provider = "Microsoft.Jet.OLEDB.4.0"conn.Open "C:\Inetpub\wwwroot\test\test.mdb"sql = "INSERT INTO userAccount (user, password) value (" sql = sql & "'" & Request.Form("user")& "'"sql = sql & ", '" & request.Form("password") & "')"'on error resume nextconn.Exceute sql, recaffectedif err<>0 then response.Write("no update permissions!") response.Write(err)else response.Write(recaffected & " recorded added")end ifconn.close

[Jack McKalling]

I don't know ADO, but shouldn't the mdb file be located at the server instead of your computer? Just a guess

[Sh89]

Try Thistempuser=Request.Form("user")temppass=Request.Form("password")sql="INSERT INTO userAccount (user, password) values ('"&tempuser&"', '"&temppass&"')"This will definitely help you!

[pulpfiction]

Hi Fry,Just to make sure that we have the correct SQL statement, print the statement once and check...sql = "INSERT INTO userAccount (user, password) value (" sql = sql & "'" & Request.Form("user")& "'"sql = sql & ", '" & request.Form("password") & "')"response.write(sql)With this you can make sure that you have a correct statement....

[Fry]

tried all the suggestion from above. the query was fine. there must be something else that prevent me from added data to database.Note: i could read the database. but i can't write, and i have configure the file so then it is allowed to write by internet user.

[jojay]

tried all the suggestion from above. the query was fine. there must be something else that prevent me from added data to database.Note: i could read the database. but i can't write, and i have configure the file so then it is allowed to write by internet user.

<{POST_SNAPBACK}>

Right click on the folder where the database file is residing, then click Security tab, and give permission for Internet Guest Account - you may give (modify, read, write) or Full Control which includes all these....as you wish, and I think that should help this issue.

[Fry]

Right click on the folder where the database file is residing, then click Security tab, and give permission for Internet Guest Account - you may give (modify, read, write) or Full Control which includes all these....as you wish, and I think that should help this issue.

<{POST_SNAPBACK}>

tried that, the internet user has full control over the file, but still doens't work.do u use ms acess as database or mySQL or SQL server or Oracle?

[jojay]

tried that, the internet user has full control over the file, but still doens't work.do u use ms acess as database or mySQL or SQL server or Oracle?

<{POST_SNAPBACK}>

MS Access....It worked for me then what OS are you using? based on that, do a search in google. What is the error msg u r getting? Can you post the error msg?

[Fry]

MS Access....It worked for me then what OS are you using? based on that, do a search in google. What is the error msg u r getting? Can you post the error msg?

<{POST_SNAPBACK}>

i am using win xp, ms access 2003, this is the error: **Error Type: ADODB.Connection (0x800A0E7C) Parameter object is improperly defined. Inconsistent or incomplete information was provided /test/sqlAddRow.asp, line 12**any clue?

[pulpfiction]

are you using exactly the code you posted in the post#1, if thats true then there's a spelling mistake. just check this, i guess that would throw different error..you have written ["Exceute" for "Execute"]conn.Exceute sql, recaffected

[jojay]

If you still get error message, try to response.write and see .below the sql statement, write the code after sql statement:response.write sql

[jojay]

Where is your recordset object? shouldn't you have like this:

set conn = Server.CreateObject("ADODB.Connection")conn.Provider = "Microsoft.Jet.OLEDB.4.0"conn.Open "C:\Inetpub\wwwroot\test\test.mdb"sql = "INSERT INTO userAccount (user, password) value (" sql = sql & "'" & Request.Form("user")& "'"sql = sql & ", '" & request.Form("password") & "')"Set rs = Server.CreateObject("ADODB.Recordset")rs.open sql, conn,3,3

[Fry]

..

[pulpfiction]

I guess you dont need a Recordset object for an INSERT command, Hey Fry try this,conn.Execute SQL instead of [remove recaffected] conn.Exceute sql, recaffectedThen goto the DB and check if a row is added.

[Fry]

thanks everyone for all the great help. especially thanks to pulpfiction for detecting my spelling mistake on "conn.Exceute sql"i have solved the problem spelling was one of the mistake, but i also used 2 reseved words in my querry and in my table, thats why it didn't work. i changed the table name column name, now the insert query works

[jojay]

If you dont get through still, then try the below code:

conn.Provider="Microsoft.Jet.OLEDB.4.0; Data" & _       "Source=c:\Inetpub\wwwroot\test\test.mdb"

[Fry]

If you dont get through still, then try the below code:

conn.Provider="Microsoft.Jet.OLEDB.4.0; Data" & _       "Source=c:\Inetpub\wwwroot\test\test.mdb"

<{POST_SNAPBACK}>

thanks, the problem was resolved, it was the spelling and reserved words problem.