Delete record in SQL

Results 1 to 2 of 2

Thread: Delete record in SQL

  1. #1
    Join Date
    Dec 1969

    Default Delete record in SQL

    Next problem! My previous code which deleted a record does not now work. The code is:<BR><BR>&#060;%<BR>conn = "Provider=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=...."<BR>Dim oRSbc<BR>Set oRSbc=server.createobject("ADODB.recordset")<BR>oR "delete FROM [Table1] WHERE ID=" & cint(Request.QueryString("ID")) & ";",conn,1,3%&#062;<BR> &#060;strong&#062;Record Deleted&#060;/strong&#062;<BR> &#060;%Set oRSbc=nothing%&#062;<BR><BR>I get the following error:<BR><BR><BR>ADODB.Recordset error &#039;800a0e7a&#039; <BR><BR>Provider cannot be found. It may not be properly installed. <BR><BR>/admin/delete.asp, line 29 <BR><BR><BR>Line 29 is where is says "delete from table1..."<BR><BR>Any help much appreciated.<BR><BR>Andy

  2. #2
    Join Date
    Dec 1969

    Default RE: Delete record in SQL

    1. use SQLOLEDB not MSDASQL<BR>2. SQL Server uses DELETE tableName not DELETE FROM tablename<BR><BR>and dopn&#039;t forget you CAN actually refer to the documentation, y&#039;know<BR><BR>(books online)<BR><BR><BR><BR>j<BR>

Posting Permissions

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