Connecting mdb file with asp

Results 1 to 2 of 2

Thread: Connecting mdb file with asp

  1. #1
    Join Date
    Dec 1969

    Default Connecting mdb file with asp

    Could anybody please tell me how to connect mdb file with asp file in the first place? thanks

  2. #2
    Join Date
    Dec 1969

    Default Connection

    Here is an example connection, although I do think that you should have a look at some literature on the subject, and there are plenty of websites that cover both DSN and DSN-less connections.<BR><BR>Dim RsShifts<BR>Dim adocon<BR>Dim SQL<BR><BR>&#039;Create an ADO connection object <BR>Set adoCon = Server.CreateObject("ADODB.Connection") <BR><BR>&#039;Set an active connection to the Connection object using a DSN-less connection <BR>adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("my_access_database.mdb")<BR><BR>&# 039;Create an ADO recordset object <BR>Set rsShifts = Server.CreateObject("ADODB.Recordset") <BR><BR>SQL = "Select * FROM shifts"<BR><BR> SQL, ADOCON

Posting Permissions

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