Trying to Connect Access database

Results 1 to 2 of 2

Thread: Trying to Connect Access database

  1. #1
    Join Date
    Dec 1969

    Default Trying to Connect Access database

    Hello gurus:<BR><BR>I am writing following code to connect with access database.<BR><BR>Dim dcnDB<BR>Set dcnDB = Server.CreateObject("ADODB.Connection")<BR>dcnDB.C onnectionString = "Provider=Microsoft.Jet.OLEDB.3.50;Data Source=C:AccountsAccounts.Mdb"<BR>dcnDB.Open<BR><B R>But I am getting following error on explorer<BR><BR>ADODB.Connection error &#039;800a0e7a&#039; <BR>Provider cannot be found. It may not be properly installed. <BR>/act_coa.asp, line 7 <BR><BR><BR>Actuall I have install PWS 4.00 on my home computer to do some practice becuase I am new in web development. Can anyone tell me how I connect using DSN and what correct syntax should I use.<BR><BR>Thanks<BR><BR>Qureshi

  2. #2
    Join Date
    Dec 1969

    Default MDAC

    Go to and find the most recent version of this file for your operating system:<BR><BR>mdac_typ.exe<BR><BR>This will update your system with the newest versions of Microsoft Data Access Components

Posting Permissions

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