|
| |
|
|
Joey
Posts: 167
Joined: 5/15/2002
From:
Status: offline
 |
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database conn string + password - 6/7/2008 21:24:30
http://www.asp101.com/tips/index.asp?id=98
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Joey
Posts: 167
Joined: 5/15/2002
From:
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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"
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Joey
Posts: 167
Joined: 5/15/2002
From:
Status: offline
|
RE: Database conn string + password - 6/7/2008 23:24:04
[No - http 500 error
| |
|
|
|
BeTheBall
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Joey
Posts: 167
Joined: 5/15/2002
From:
Status: offline
|
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
Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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;"
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Joey
Posts: 167
Joined: 5/15/2002
From:
Status: offline
|
RE: Database conn string + password - 6/8/2008 10:37:29
Thank You!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
