Here's what I am trying to do, and I've searched the forum, found info, but it's not doing what I want it to. I have four seperate databases, which I have each created ASP pages for. Now I want to have users login (before it was just Guest). I have created a sepearte "screen" to add to the Users.mdb database. Here is the directory structure
wwwroot/asp/users/db/users.mdb
data
wwwroot/asp/data1/db/data1.mdb
wwwroot/asp/data2/db/data2.mdb
wwwroot/3...etc
wwwroot/4...etc
I found info to modify my strConnection string to this:
strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (.mdb)};DBQ=" & server.mappath("/private/mydatabase.mdb") & ";UID=;PWD="
FROM THIS:
strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("db\Case.mdb") & ";Driver={Microsoft Access Driver (.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
* I edited the login.asp page for each of the DATA sources to point to my users.mdb database to check for validity.....I've tried everything but the new connection string does not work.....I have not uploaded, but it does not work on the local machine.
By just changing the database path this is the error
This is what I had:
strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("..\..\users\db\users.mdb") & ";Driver={Microsoft Access Driver (.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
Error Type:
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 0xe7c Thread 0xfd8 DBC 0x1521024 Jet'.
/casetest/login.asp, line 60
By implementing the corrected StrConnection to this:
strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("../../users/db/users.mdb") & ";UID=;PWD="
I get this:
Error Type:
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 0xe7c Thread 0xfd0 DBC 0x1521024 Jet'.
/casetest/login.asp, line 61
So, I'm really lost....I really don't understand the ../.. thing except for the backing up the directory structure is my guess. Any help would be great!
Thanks in advance!
Allan
