Connection Error
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=15310
Printed Date: 30 March 2026 at 6:55am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Connection Error
Posted By: wolfie
Subject: Connection Error
Date 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...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--[ http://www.wolfweb.co.uk - WolfWeb.co.uk ] PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[ |
Replies:
Posted By: dj air
Date 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 |
Posted By: wolfie
Date 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--[ http://www.wolfweb.co.uk - WolfWeb.co.uk ] PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[ |
Posted By: dj air
Date 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. |
Posted By: wolfie
Date 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--[ http://www.wolfweb.co.uk - WolfWeb.co.uk ] PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[ |
Posted By: dj air
Date 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 |
Posted By: Mart
Date Posted: 31 May 2005 at 4:26pm
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 wrote:Posted By: wolfie
Date 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--[ http://www.wolfweb.co.uk - WolfWeb.co.uk ] PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[ |