Snitz Forums 2000 - Please help with DSN-Less connection code

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

Please help with DSN-Less connection code

New Topic

Topic Locked

Printer Friendly

Author

Topic

mspaul
Starting Member

Australia
3 Posts

Posted - 15 January 2005 : 03:10:04

Hi Guys,

I've just managed to set up a DSN-less connection for my first project

But unfortunately I can't seem to figure out where to specify the database password in the code and so I can't connect to the database.

My password for the database is : test

This is my code :

<%
Dim userConnectString, userconn

userConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("suppliers.mdb")
Set userconn = Server.CreateObject("ADODB.Connection")
userconn.open userConnectString
%>

Where do I specify the username and password in this connection?

Any help with be greatly appreciated. Thanks in advance.

Hamlin
Advanced Member

United Kingdom
2386 Posts

Posted - 15 January 2005 : 06:19:40

userConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("suppliers.mdb") & ";User Id=userid;Password=pass;"

Should do the trick.