Having problems with database access

Results 1 to 3 of 3

Thread: Having problems with database access

  1. #1
    charles Guest

    Default Having problems with database access

    When I write up this code:<BR><BR>&#060;%@ LANGUAGE=VBSCRIPT%&#062;<BR>&#060;%<BR>Dim cnDB<BR>Dim rsQuery<BR>set cnDB = server.createobject("adodb.connection")<BR>cnDB.Co nnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data <BR><BR>Source=C:InetpubwwwrootNWIND.MDB"<BR>cnDB. Open<BR>set rsQuery = Server.CreateObject("ADODB.Recordset")<BR>rsQuery. Open "SELECT * FROM Shippers",cnDB<BR>rsQuery.AddNew<BR>rsQuery("Compa nyName")="&#060;text&#062;"<BR>rsQuery("Phone")="& #060;text&#062;" <BR>rsQuery.Update<BR>rsQuery.Close<BR>cnDB.Close< BR>%&#062;<BR><BR>I get this error:<BR><BR>HTTP 500.100 - Internal Server Error - ASP error<BR>Internet Information Services<BR><BR>--------------------------------------------------------------------------------<BR><BR>Technical Information (for support personnel)<BR><BR>Error Type:<BR>ADODB.Recordset (0x800A0CB3)<BR>Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.<BR>/nwind.asp, line 10<BR><BR><BR>Browser Type:<BR>Mozilla/4.0 (compatible; MSIE 6.0b; Windows NT 5.0) <BR><BR>Page:<BR>GET /nwind.asp <BR><BR><BR><BR><BR>Anyone know what&#039;s going on? This is straight out of a book.

  2. #2
    Join Date
    Dec 1969

    Default Directory db is in

    must have read/write access for the annon user.

  3. #3
    charles Guest

    Default RE: Directory db is in

    I have read/write set for the ISUR_&#060;machine name&#062; user. Is this adequate or do I need something else set?

Posting Permissions

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