General Discussion - db connection plz help,.

Print Page | Close Window

db connection plz help,.

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21608
Printed Date: 30 March 2026 at 1:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: db connection plz help,.

Posted By: pro_touch
Subject: db connection plz help,.
Date Posted: 14 October 2006 at 11:21am

objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("dbname.mdb")

my db is password protected and thats why i am getting error now how can i open connection with password plz help.

i am getting 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 0x464 Thread 0x7d4 DBC 0x739024 Jet'.
/default.asp, line 52

Replies:

Posted By: dj air
Date Posted: 14 October 2006 at 11:24am

try

objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("dbname.mdb") &";Password=value"

Posted By: pro_touch
Date Posted: 14 October 2006 at 11:26am

how fast. thats great :) it worked. thanks alot. so nice of you....

Posted By: WebWiz-Bruce
Date Posted: 14 October 2006 at 12:40pm

Access passwords can be easily cracked, there's lost of tools on the web to do this. I often use them as it's quicker than trying to remember what the password was.

I would recommend still placing the database in a folder outside of your public web site folders on your hosting account. This way a hacker can not download your database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: pro_touch
Date Posted: 14 October 2006 at 1:28pm

poor me :( my hosting company doesnt give me physical path but they given me a option to secure the folder.... if i do this... the forum doesnt work coz the folder asks for password :( what to do...

Posted By: pro_touch
Date Posted: 14 October 2006 at 11:31pm

oh no... after uploading database of huge data its giving error i setup password on database... and it works on my iis....

it says unable to open registry key. temporary volatile jet dsn for process.. i used the connection line mentioned above.... and it worked on my home pc. plz help as soon as possible plzz.. thanks.

Posted By: Mikey
Date Posted: 15 October 2006 at 12:20am

This error means that you don't have permission to use the database or the folder it is contained in.

You need read/write/modify

-------------
Handyman man?

Posted By: pro_touch
Date Posted: 15 October 2006 at 1:19am

its not solving the problem ... i think the problem must be with that thing i used password on ms access now i cant upload another file i have to use it..... is there anything wrong with the connection line mentioned above database is ms access 97.

Posted By: pro_touch
Date Posted: 15 October 2006 at 1:28am

plz check if anything wrong with this line.

objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb") & ";Password=password"

any changes should i make in this line ?

it works in my home pc but giving error in this line on hosting srv.

error is

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1450 Thread 0x654 DBC 0x22bee754 Jet'.

/default.asp, line 55

and line 55 is mentioned above ..database connection.

Posted By: pro_touch
Date Posted: 15 October 2006 at 1:56am

plz make this connection line i want to try this.

Provider=Microsoft.Jet.OLEDB.3.51 user this into this line.

objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("dbname.mdb") &";Password=value"

Posted By: dj air
Date Posted: 15 October 2006 at 11:20am

that can be the issue, you are using MS Access 97

the database looks like it maybe becoming corrupt on uploading.

if possible try a newer version of access using the Upgrade tool in MS ACCESS.

also before uploading make sure to compact and repair the db to lower the risk of corrupting it.