Connection string with password protected database...

[aamaker]

I have built a site for a client and need to secure the databases (various apps built using UD4/ASP/VBScript with Access 2000 databases)... Im usind dsn-less connection strings for them all so the string generated by UD looks like:

..."Provider=Microsoft.Jet.OLEDB.4.0;Data source=z:\production server_morpheus\snfinance\site\winning_numbers\jobdatabase.mdb;"
%>

my questions are:

1) where in access to I specify username/password
2) where in the connection string (and how) do I specify the username/password?

 

[mlawson]

There are a number of ways to do this, you could add user name and password within the string itself, which is fine if you want sole access to the database, not so good if you want to allow user access, you'd be better setting up user authentication for that.

Excuse my next link but it is the most relevant!

http://www.macromedia.com/support/ultradev/ts/documents/adoconn.htm

This should guide you through the issues of adding user/pass to an ADO/ODBC connection string.

Have fun

M

 

[Cheech]

Why "Excuse my next link"?? Live long and make your kids suffer..

 

[mlawson]

I don't like to seem like I'm preaching by giving folk links back to the Mothership. No, you're right, folk who post should have RFTM first.

Thanks cheech!

Having fun

M

 

[Cheech]

"should have RFTM first" I normally advise them to RTFM ;-) Live long and make your kids suffer..

 

[mlawson]

You're a hard (wo)man !

Having fun

M

 

[Cheech]

Man! there thats that cleared up Live long and make your kids suffer..

 

[mlawson]

Yep, I wouldn't want to get on your wrong side if you were a charming young lady. Now that I know your intimate details, look out!