Database connection in ASP

[hpl]

I can't make a database connection in ASP using Visual InterDev.
I am using this connection string:

set myconn = server.createobject("ADODB.connection")
	myconn.open "Driver={microsoft access Driver (*.mdb)};dbq="&server.mappath("lr_statech.mdb")

but this results in this mysterius error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x304 Thread 0x624 DBC 0xad8014 Jet'.

I can't find out what's wrong, please let me know if I can use another connection string

[JoshT]

try this:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=databaseName;User ID=userName;Password=userPassword;"

[hpl]

Hi Josh
I not sure where to write this code, would you please help me?

[JoshT]

Use it for the connection string passed to myconn.open