When using a fileless DSN

Results 1 to 2 of 2

Thread: When using a fileless DSN

  1. #1
    Pham Guest

    Default When using a fileless DSN

    &nbsp;<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver] Couldn&#039t lock file. <BR><BR>/bang/xt_email.asp, line 7 <BR><BR>here my code:&#060;%<BR>&#039Create a connection to our database using a fileless dsn<BR>Response.Buffer = true<BR>dim cnn,rst<BR>set cnn = Server.CreateObject("ADODB.Connection")<BR>set rst = Server.CreateObject("ADODB.RecordSet")<BR>cnn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=d:/inetpub/wwwroot/firstcap/bang/email.mdb;"<BR>sqltext = "SELECT * FROM email"<BR>rst.Open sqltext,cnn,3,3<BR><BR>

  2. #2
    RUSY Guest

    Default RE: When using a fileless DSN

    CLOSE THE DATABASE FILE YOU ARE WORKING ON <BR>AND RUN THE SCRIPT AGAIN

Posting Permissions

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