database lock

Results 1 to 2 of 2

Thread: database lock

  1. #1
    Join Date
    Dec 1969

    Default database lock

    Hello,<BR><BR>I am re-using some code that works fine on an old database/website, but when I copy it to a new site/database it only works intermittently and a .ldb file appears! IUSR has full control. The code is below. If anyone can tell me why this works once and then locks the database I&#039;d be very grateful!!<BR><BR>Mark<BR><BR>Dim DBpath, ConnStr, conn<BR><BR>DBPath=server.mappath("scores.mdb")<BR >ConnStr="DRIVER=Microsoft Access Driver (*.mdb); UID=admin; UserCommitSync=Yes; Threads=4; SafeTransactions=1; PageTimeout=1; MaxScanRows=8; MaxBufferSize=2048; FIL=MS Access;DriverId=281; DBQ=" & DBPath<BR>on error resume next<BR>Set Conn=server.createobject("adodb.connection")<BR>co ConnStr<BR><BR><BR>set rs=server.createobject("adodb.recordset")<BR>rs.Lo ckType=adLockReadOnly<BR>sql="Select id FROM scores WHERE (((name)=&#039;" & uname & "&#039;) AND ((pwd)=&#039;" & upwd & "&#039;));"<BR><BR> sql,conn<BR><BR>If rs.eof then<BR>&#039;do stuff<BR>&#039; end if

  2. #2
    mark Guest

    Default RE: database lock PS

    PS It may be a server thing as it works OK on another server. But I still don&#039;t know why!

Posting Permissions

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