Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - error with database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

error with database

 Post Reply Post Reply
Author
borivath_same View Drop Down
Newbie
Newbie
Avatar

Joined: 28 December 2007
Location: Cambodia
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote borivath_same Quote  Post ReplyReply Direct Link To This Post Topic: error with database
    Posted: 28 December 2007 at 3:16am
Dear All,

i has  a Form that allow input NAME and COMMENT    to guestbook database. i made it already But when i upload it on the Internet and then i tested by input NAME and COMMENT.
When i pressed submit button. It has error:
-----------------------------------------------------------------------------------
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 0x1de4 Thread 0x1d10 DBC 0x1916014 Jet'.

/db/add_to_guestbook.asp, line 60
-------------------------------------------------------------------------------------
ASP code:
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("guestbook.mdb")

Please  help me.
Thanks and Cordially

Borivath


Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 28 December 2007 at 2:19pm
If you do a search, you will find this has been discussed countless times. Most likely cause is you don't have write access to the db.
Back to Top
yung32 View Drop Down
Newbie
Newbie


Joined: 21 July 2008
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote yung32 Quote  Post ReplyReply Direct Link To This Post Posted: 24 July 2008 at 8:14am
Hi to all,
This usually means that the MDB file is open in a copy of Access on the server, or Visual InterDev is open and has an active connection to the database. Check for it and close that operation. If you still problem persist then it seems your database is corrupted. Use compact and repair utility to repair your database or you can use stellar phoenix access repair software to repair your database.
Check for more information:http://www.repair-access-file.com


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: 24 July 2008 at 8:30am
This error can also occur if you are using an Access 97 database, in which case you should upgrade the database to Access 2000 or above.

The driver you are using can also throw up this error. Use the JET database driver instead:-

adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("guestbook.mdb")


Back to Top
 Post Reply Post Reply

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.