Database conn string + password (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

---

Joey -> Database conn string + password (6/7/2008 20:11:24) I need to add a password to this string so I can open the access database: myDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("/fpdb/test.mdb") Can anyone help?

---

BeTheBall -> RE: Database conn string + password (6/7/2008 21:24:30) http://www.asp101.com/tips/index.asp?id=98

---

Joey -> RE: Database conn string + password (6/7/2008 21:41:18) I wish I was that smart and could decode those instructions. I've tried many vairations, can anyone just spell it out clearly for me? Last attempt: myDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Database Password=Joey" & Server.Mappath("..\fpdb\test.mdb")

---

BeTheBall -> RE: Database conn string + password (6/7/2008 23:11:44) This work? myDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Server.Mappath("..\fpdb\test.mdb");Database Password=Joey"

---

Joey -> RE: Database conn string + password (6/7/2008 23:24:04) [No - http 500 error

---

BeTheBall -> RE: Database conn string + password (6/7/2008 23:44:30) How 'bout this? myDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("..\fpdb\test.mdb") &";Database Password=Joey" If not, I will play with it a bit and get back with you.

---

Joey -> RE: Database conn string + password (6/7/2008 23:49:01) Thanks for the help. Now I get this error "Microsoft JET Database Engine error '80004005' Could not find installable ISAM. "

---

BeTheBall -> RE: Database conn string + password (6/8/2008 0:00:12) This will work: myDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("..\fpdb\test.mdb")&";Jet OLEDB:Database Password=Joey;"

---

Joey -> RE: Database conn string + password (6/8/2008 10:37:29) Thank You!

---

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.0625