Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - db connection plz help,.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

db connection plz help,.

 Post Reply Post Reply Page  12>
Author
pro_touch View Drop Down
Groupie
Groupie
Avatar

Joined: 21 August 2002
Location: Pakistan
Status: Offline
Points: 38
Post Options Post Options   Thanks (0) Thanks(0)   Quote pro_touch Quote  Post ReplyReply Direct Link To This Post Topic: db connection plz help,.
    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
 
 
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2006 at 11:24am
try


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


Back to Top
pro_touch View Drop Down
Groupie
Groupie
Avatar

Joined: 21 August 2002
Location: Pakistan
Status: Offline
Points: 38
Post Options Post Options   Thanks (0) Thanks(0)   Quote pro_touch Quote  Post ReplyReply Direct Link To This Post Posted: 14 October 2006 at 11:26am
how fast.    thats great :) it worked. thanks alot. so nice of you....
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
pro_touch View Drop Down
Groupie
Groupie
Avatar

Joined: 21 August 2002
Location: Pakistan
Status: Offline
Points: 38
Post Options Post Options   Thanks (0) Thanks(0)   Quote pro_touch Quote  Post ReplyReply Direct Link To This Post 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...

Back to Top
pro_touch View Drop Down
Groupie
Groupie
Avatar

Joined: 21 August 2002
Location: Pakistan
Status: Offline
Points: 38
Post Options Post Options   Thanks (0) Thanks(0)   Quote pro_touch Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Mikey View Drop Down
Senior Member
Senior Member

1979

Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mikey Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
pro_touch View Drop Down
Groupie
Groupie
Avatar

Joined: 21 August 2002
Location: Pakistan
Status: Offline
Points: 38
Post Options Post Options   Thanks (0) Thanks(0)   Quote pro_touch Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.