Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Connection Problems
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Connection Problems

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

Joined: 24 February 2003
Location: United States
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote choshour Quote  Post ReplyReply Direct Link To This Post Topic: Connection Problems
    Posted: 29 March 2003 at 9:11pm

I am new to ASP and am trying to get this connection string to work.  I would thankful to any one that might be able to help me.  Thanks in advance

<%
Dim adoCon    'Database Connection Variable
Dim rsCommon   'Holds the configuartion recordset
Dim strCon   'Holds the Database driver and the path and name of the database
Dim strSQL   'Holds the SQL query for the database
Dim strDbPathAndName  'Holds the path and name of the database

 

Set adoCon = Server.CreateObject("ADODB.Connection")

strDbPathAndName = Server.MapPath("admin/database/player.mdb")

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strDbPathAndName

adoCon.connectionstring = strCon

adoCon.Open

Set rsCommon = Server.CreateObject("ADODB.Recordset")

rsCommon.Open strSQL, adoCon

rsCommon.Close

%>

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 0x4f4 Thread 0x9a0 DBC 0xc633f64 Jet'.

/profile manager/connection2.asp, line 17



Edited by choshour
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 30 March 2003 at 1:29am

Well its a database path problem, try

strDbPathAndName = Server.MapPath & "admin/database/player.mdb"

General error Unable to open registry key
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 0x6cc Thread 0x78c DBC 0x144cfc4 Jet'.
This error can happen for a number of reasons the main reason being if the path to the database is incorrect.

You need to check that the path to the database is correct (You must use the physical path on the server to the database and not a virtual path).

The error is also quite common if the permissions on the server are incorrect. Check that IIS has sufficient permissions to access the registry and that the correct permissions, read and write, are set on the directory containing the database and the database itself, for the IUSR account.

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.