Fry

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

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

..

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?

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?

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.

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

hi i have followed every steps from the tutorial to build the IIs 5.1 to build the stmp and website.when i use the code from the tutorial to send emails, alll i got is emails in the queue folder. here is the code below. i tried all sort of thing for almost 2 weeks, i still couldn't send email. Can someone please help me? I am using rogers internet. and i am using a router. I have set up the router so the port 25 is forward to my computer. I am sure the code is correct, i think i messed something up from the smtp setting or some connection setting issue, the router wasn't configure properly.<%Set myMail=CreateObject("CDO.Message")myMail.Subject="Sending email with CDO"myMail.From="mymail@myidomain.com"myMail.To ="joeydeng@hotmail.com"myMail.TextBody="hi from joey This is a message."myMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing")=2'Name or IP of remote SMTP servermyMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver")="localhost"'Server portmyMail.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport")=25 myMail.Configuration.Fields.UpdatemyMail.Sendset myMail=nothingResponse.Write("Joey default email has been sent out")%>here is the smtp setting in my iis. i've asked in other forum but no one knows the cause.http://forums.aspfree.com/attachment.php?attachmentid=3660http://forums.aspfree.com/attachment.php?attachmentid=3661http://forums.aspfree.com/attachment.php?attachmentid=3662http://forums.aspfree.com/attachment.php?attachmentid=3663