No Access Drivers

Results 1 to 2 of 2

Thread: No Access Drivers

  1. #1
    Join Date
    Dec 1969

    Default No Access Drivers

    Newbie here trying to set up connection to my database.<BR>When I go to create my system DSN the only drivers I have installed that say anything about microsoft access is:<BR><BR>Driver do Microsoft Access (*.mdb)<BR>Microsoft Access-Treiber (*.mdb)<BR><BR>I have tryed both and I keep getting an error when I run my page. <BR>How do I install Microsoft Access Driver (*.mdb)

  2. #2
    Join Date
    Dec 1969

    Default Be sure you have a current

    mdac version:<BR><BR><BR><BR>See if that makes any difference. The problem could also be with your code. I&#039;d recommend not using a dsn anyway, faster and easier (IMO) to use oledb. Example:<BR><BR>Dim objConn<BR>Dim objRS<BR>Dim StrConn<BR>StrConn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=e:dbpathDatabaseName.mdb"<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>With ObjConn<BR>.ConnectionString = StrConn<BR>.Open<BR>End With<BR>Set objRS = objConn.Execute("Select * from table")<BR>ObjRS.Close<BR>ObjConn.Close<BR>Set objConn = Nothing<BR>Set objRS = Nothing

Posting Permissions

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