Connection String is fine until...

i password the database, here is the connection string:

Code:

---

Set Conn = Server.CreateObject("ADODB.Connection")
    Set RS = Server.CreateObject("ADODB.RecordSet") 

DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)};"
    DSNtemp=dsntemp & "DBQ=" & server.mappath("../db/database.mdb")
    conn.Open DSNtemp, 1, 3

---

can anybody point out where i should be putting the uid and pwd? I've tried just about everywhere in the string :confused:

just put ;pwd=PASSWORD; as in:

Code:

---

Set Conn = Server.CreateObject("ADODB.Connection")
    Set RS = Server.CreateObject("ADODB.RecordSet") 

DSNtemp = "DRIVER={Microsoft Access Driver (*.mdb)};"
    DSNtemp = DSNtemp & "DBQ=" & server.mappath("../db/database.mdb") & ";pwd=PASSWORD;"
    conn.Open DSNtemp, 1, 3

---

i put my password in the way you stated and it's still giving me this 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 0x58c Thread 0x674 DBC 0x161500c Jet'.

:confused: :confused:

it's an Access 2000 database and i'm using Windows 2000 pro

thanx anyway, i got it working with a different connection string :D