2. ASPRunnerPro General questions
  3. Password protected Database unable to open
This topic is locked

Password protected Database unable to open

 		9/27/2004 3:23:11 AM
ASPRunnerPro General questions
S
 spapax author

We have an MSAccess db file with password set.

We run the ASPRunner steps without any problem and we save all files in WEB site.
However when we try to see the database through ASPRunner pages for edit or update we get the following error:
Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x2c8 Thread 0x754 DBC 0x2089024 Jet'
Our objective is to protect MSAccess file by password in order to ensure data encryption even in case of db file download. Any other idea to this direction is welcomed.
Thanks in advance
Sergey Kornilov admin 9/27/2004

Hi,
I guess this problem is not password protection related. Please post your database connection string here which can be found in include/..._dbconnection.asp file.
Also you can protect your database on the Web by putting it outside WWWROOT where it won't be downloadable on the Internet. Please check this thread that explains how you can do this.
S
 		spapax author 9/27/2004

Connection String is:

strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("db\Usersl.mdb") & ";UID=;PWD=456"
Please note that when we remove password form db everything works fine in the same structure
Unfortunattely putting database outside wwwroot is not an option with our provider.
Sergey Kornilov admin 9/27/2004

I would recommend to ask your web hosting provider if they have designated folder for databases. Usually this folder located outside WWWROOT and has write permissions set.
A
 		agmoraojr 5/12/2008

Any update for this issue to have the .mdb file itself to be protected and no cause error and accessing at the website. just what had one member opens this thread.
thank you,

I would recommend to ask your web hosting provider if they have designated folder for databases. Usually this folder located outside WWWROOT and has write permissions set.
Sergey Kornilov admin 5/12/2008

Jong,
could you clarify what kind of problem you having?
A
 		agmoraojr 5/13/2008

admin,
I want to protect my ms access mdb locally by setting a password.
this is the error i got.

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 0xc8 Thread 0xe14 DBC 0x13cb024 Jet'.

/atm/include/dbcommon.asp, line 111
removing the password from the ms access, my program works fine and error is eliminated.

Jong,

could you clarify what kind of problem you having?
Sergey Kornilov admin 5/13/2008

Make sure you modify connection string in include/dbconnection.asp file by adding a password there.