Classic ASP Discussion - ADO Connection String

Print Page | Close Window

ADO Connection String

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=9470
Printed Date: 01 April 2026 at 1:00am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ADO Connection String

Posted By: jmss66
Subject: ADO Connection String
Date Posted: 02 February 2004 at 12:41pm

I have an ACCESS database which I am going to put a password. What do I need to do or add in my connection string for the password? The connection string below is working till I put a database password.

  Dim objConn
  curDir = Server.MapPath("db/MyDatabase.mdb")
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="  & curDir

Thanks,
Judy

Replies:

Posted By: Semikolon
Date Posted: 02 February 2004 at 12:47pm

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & curDir & ";Password=password"