I am trying to set up an area for users to login to with a username and password. I have been told by the hosts of the site that I must use a DSN Less Connection but the code they supply me with doesn't seem to be working:

Set Conn = Server.CreateObject("ADODB.Connection"
conString = "DBQ=D:\j\o\joebloggs\private\database.mdb"
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & conString

I am also not sure where to place the above code.

I am very very new to database work and would appreciate some help.

Thanks very much.

I normally save it as a txt file and the on each page have it as an include.

<!--#INCLUDE virtual="folder_name/file_name.txt"-->

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I am trying to set up an area for users to login to with a username and password. I have been told by the hosts of the site that I must use a DSN Less Connection but the code they supply me with doesn't seem to be working:

Set Conn = Server.CreateObject("ADODB.Connection"
conString = "DBQ=D:\j\o\joebloggs\private\database.mdb"
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & conString

I am also not sure where to place the above code.

I am very very new to database work and would appreciate some help.

Thanks very much.

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting