| Author |
 Topic Search  Topic Options
|
wolfie 
Groupie
Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Connection Error
Posted: 31 May 2005 at 3:02pm |
I recently installed IIS and Access XP on my new PC but I am having trouble connecting to the database, I get this 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 0xc50 Thread 0x840 DBC 0x131b0a4 Jet'.
/inc/adocon.asp, line 11
As I am aware, it's nothing to do with the adocon.asp file as this
works on my remote server. I cannot think of anything different I have
done to when I last installed it.
Any ideas?
Cheers.
|
Wolfie--[ WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2005 at 3:38pm |
|
What IIS is this?
also check that you have the upto date MDAC drivers and also Compact and repair the database.
also make sure you have read,write and modify permssions on the folder holding the database
|
|
wolfie
Groupie
Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2005 at 3:59pm |
|
IIS 5.1
Tried updating to MDAC 2.8 -
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c& ;DisplayLang=en
- but Windows XP Pro SP2 has it already.
|
Wolfie--[ WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2005 at 4:06pm |
|
i have a XP PRo SP2 as a server here, and had no problems setting it up.
only thing really i can suggest is un install it and re install.
ive installed it twice on two occations and had no problems.
|
|
wolfie
Groupie
Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2005 at 4:08pm |
|
Wait, I've got the Beta version of OpenOffice 2 installed. That has a
database program installed that has connectivity like that of Access.
Do you suppose it's a conflict with that?
|
Wolfie--[ WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2005 at 4:14pm |
|
im not sure as i haven't looked at openoffice, but it maybe hogging the ports/processes used to do so.
if possible try disabling it and see if it then allolws access.
the only difference between our setups is of course open office but
also i use office 2003 here. not XP but that shoul;dn't make any
difference as office is not requoired to run access databases though IIS
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2005 at 4:26pm |
 wolfie wrote:
I recently installed IIS and Access XP on my new PC but I
am having trouble connecting to the database, I get this 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 0xc50 Thread 0x840 DBC 0x131b0a4 Jet'.
/inc/adocon.asp, line 11
As I am aware, it's nothing to do with the adocon.asp file as this
works on my remote server. I cannot think of anything different I have
done to when I last installed it.
Any ideas?
Cheers.
|
That error can also mean that the database you are pointing to in your connection string doesn't exist.
Just Response.Write out your connection string and then test that the path to the database is right
|
|
wolfie
Groupie
Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2005 at 5:57pm |
Right, so I've uninstalled IIS, Access XP and also OpenOffice.
I've installed Access XP and IIS in that order and nothing works still.
I know the database lookup is correct because I've checked and doubled
checked it and it's exactly the same as my hosting server -
wolfweb.co.uk.
Nothing works still.
Could it be that I have placed all my files in C:\Inetpub\wwwroot\?
I've changed the settings in the Home Directory tab in the Default Website Properties so it's the following...
This really has me confused...
|
Wolfie--[ WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[
|
|
