Jump to content

ryan0926

Members
  • Content Count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ryan0926

  • Rank
    Newbie
  1. SOLVED my problem. hehehe I should allow nulls on my fields anyway. tnx
  2. I've been following you guys. I had the same problem. already change the permission of the gtks.mdf database uncheck readonly etc. i can read from the db. here is the code. Connected OK error: -2147217900 No update permissions!INSERT INTO ct_mstr (ct-nbr,ct-fname)VALUE('3','rya') already figure out my problem. some of my fields doesnt allow nulls.. i change them to allow nulls. it works tnx guys.
  3. hi Im using w2k3 server and sql server 2005. I followed the w3chools asp tutorial up to ADO.. when I'm trying to insert a new record to a table from a form the page would show no update permission.I did tried to add IUSR_servername to my database with full control etc. then I created a sql login to sql server. I can perform select statement from database and show it to page.. but i cant insert a record. the error keeps on showing the no update permission. meaning I have an error on it please help. this is the code.<html><body><%dim connSet conn = CreateObject("ADODB.Connection") conn.Mode = 3 ' adModeReadWrite conn.Open "DSN=gtks;uid=test;pwd=test;"If conn.errors.count = 0 ThenResponse.Write ("Connected OK " & "<br />" & "<br />")End Ifsql="INSERT INTO ct_mstr (CT-NBR,CT-FNAME)"sql=sql & " VALUES "sql=sql & "('" & Request.Form("nbr") & "'"sql=sql & "'" & Request.Form("fname") & ")"on error resume nextconn.Execute sql,recaffectedif err<>0 then Response.Write("check No update permissions!")else Response.Write("<h3>" & recaffected & " record added</h3>")end ifconn.close%></body></html>did i missed something to configure?tnx in advance..
×
×
  • Create New...