Any IIS 5 settings problem?

Results 1 to 2 of 2

Thread: Any IIS 5 settings problem?

  1. #1
    Gogi Virk Guest

    Default Any IIS 5 settings problem?

    Hi all! I am unable to insert record in Access 2000 database from my ASP page. I am using INSERT INTO sql but I am getting error saying "Syntax error in INSERT INTO statement" and error number is 2147217900. Here is my code:<BR><BR>strDbLoc="webdbdatastuff.mdb"<BR>set conn=Server.CreateObject("ADODB.Connection")<BR>co nn.connectionstring="Provider=Microsoft.Jet.OLEDB. 4.0; Data Source=" & Server.MapPath(strDbLoc)<BR> connectionstring<BR>sql = "INSERT INTO parameters (itemA, itemB, itemC) VALUES(225.5,111.21,124.87)"<BR>response.write sql <BR>conn.execute sql <BR><BR>Are there any permissions on Web Server (IIS5) to check as I can select from db using the above connection but not able to update or insert. I also tried recordset.Addnew method.<BR><BR>Appreciate your time and help.<BR><BR>Gogi Virk<BR>

  2. #2
    Gogi Virk Guest

    Default Resolved

    Problem is resolved. It was wrong naming of table, I used keyword.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts