Web Wiz Forums - Database connection issues

Print Page | Close Window

Database connection issues

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28098
Printed Date: 28 March 2026 at 2:25am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Database connection issues

Posted By: Iowarth
Subject: Database connection issues
Date Posted: 03 December 2009 at 7:52pm

Hi

I run a Web Wiz forum which I took over about 6 months ago and it has run on my service provider's server perfectly ever since ...... until yesterday morning!
It now comes up with an Error 500 whenever trying to use any of the Forum pages which involve access to the database.
The detailed error message from the logs is:-
"ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/forum/common.asp, line 260"

I have tried recycling the application pool and using both the virtual and physical database path - but the problem persists.
Incidentally, this is an old version of Web Wiz (Copyright 2001-2004) - I hope to upgrade to the latest ... when I can afford it!
My apologies if the answer exists within the forum - I have searched but failed to find this specific problem
Many thanks for any assistance.
Chris

Replies:

Posted By: WebWiz-Bruce
Date Posted: 04 December 2009 at 9:11am

This is a server issue. The database driver is either corrupted or has been disabled.

You would need to contact your hosting provider.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Iowarth
Date Posted: 04 December 2009 at 10:40am

Thanks Bruce.
This was also my supposition - but it's amazing how difficult it can be to persuade one's hosting providers to accept the problem might be with their server!
They did provide me with an alternative connection string (ignoring the fact that the standard one had worked perfectly for 6 months!). This did produce a change of error message to :-

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Specified driver could not be loaded due to system error 193 (Microsoft Access Driver (*.mdb)).

At least this seems to pretty conclusively prove a server issue - even to them one would hope! I will update this thread with the outcome or any developments for the benefit of any others who may get similar problems at some time.

Chris

-------------
Chris Davis
Administrator, http://www.herpetofauna.co.uk

Posted By: Iowarth
Date Posted: 04 December 2009 at 12:44pm

Hi again

Simply an update as promised. The situation is now resolved and Bruce was (of course!) quite right!
In my response to my hosting provider I stated the following:-
"An internet search suggests that this problem may result from running 64bit server without 32bit OLEDB manager. This, or variants of it (eg MDAC or OLEDB corrupted) are also the most common, in fact, after connection string errors, the only causes I can find on the net of both this and the preceding errors. The software provider also states unequivocally that this is a server error. Bearing in mind that this application has run perfectly for 6 months and that I made no change whatsoever to it prior to its extremely sudden cessation, might I suggest that the above be investigated - particularly (but not exclusively) what server changes (eg updates etc) might have been implemented overnight on Tuesday prior to its sudden loss at 0841 on Wednesday"
I then received a response stating:-
"We've made some updates to your user on the server ........" and it worked.
This obviously demonstrates that a pro-active response to a support department can be of assistance.
Hopefully, this episode and its resolution might be of assistance to anyone else who might suffer similar problems at some time in the future.
Chris

-------------
Chris Davis
Administrator, http://www.herpetofauna.co.uk

Posted By: WebWiz-Bruce
Date Posted: 04 December 2009 at 1:10pm

When I first saw your error I thought exactly the same thing in regards to the issue as there is no 64bit JET Access driver, so unless you place the application pool in 32bit mode then on a 64bit machine you do get this error.

However in your case I would have thought this unlikely as you can not update a server from 32bit to 64bit, it requires that you have a new OS installed.

Migrating your account to a 64bit machine without notice is very bad as there are so many things that can break.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: traumaplayer
Date Posted: 15 December 2009 at 8:02pm

What odd timing! As of 12/11/09 I am having the same issue. However, I'm having a hard time getting help from the hosting company. This forum has been up and running for many years and this is the first time I've had an issue.

They sent an email a couple weeks ago letting me know of server maintenance on 12/11 at 2am. In the email is this: "The impact of this maintenance will be the removal of any 10.x.x.x IP addresses space bound to shared servers.
PLEASE NOTE: Action is needed to update any references to these internal IP addresses to maintain website and database functionality.
1)Data Source Names (DSN's)
2)Any references to internal address in code such as database connection strings."

I know this is the reason for the connection problem but I'm not sure I know what to do to fix.

Any ideas?

Thanks in advance,

Tyler

Posted By: WebWiz-Bruce
Date Posted: 16 December 2009 at 11:27am

This was quite a specific issue to using an Access database on an x64 system.

Is this what you are using? Are you using Access on an x64 OS and if not what database types are you using and what is the OS?

Also any error messages would be useful as well.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: traumaplayer
Date Posted: 16 December 2009 at 1:12pm

MS SQL database. This is the error message:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/forum/common.asp, line 260

Thanks!

Posted By: WebWiz-Bruce
Date Posted: 16 December 2009 at 1:57pm

This is a very different issue to the original issue posted.

The error is due to the incorrect name or IP address to the database server. Contact your web host for the new SQL Server Hostname or IP address.

You should then reinstall the latest release and when the install wizard asks for the database connection details put in the new hostname or IP supplied by your hosting company.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: ishfaq
Date Posted: 25 December 2009 at 2:02am

Hi,

I would like to pick up on the original issue. I have a Windows 2008 64bit machine on which I have installed 9.64 but get the error:

Error details:-
ADODB.Connection
Provider cannot be found. It may not be properly installed.

After reading the earlier posts in this thread, I searched around for a driver suitable but couldn't find one. Can anyone help? I think I am looking for a MDAC driver but I'm sure the latest version of Windows has it as Win 2003 had it.

I've used this forum software for a number of years now but only on 32bit systems.

I am using an Access database.

Thanks

Posted By: WebWiz-Bruce
Date Posted: 28 December 2009 at 9:47am

Microsoft are not making a 64 bit Access driver, which is why you have this issue.

What you need to do is go into the IIS Manager and locate the Application Pool for the website that you wish to use Access on. You then need to edit the application pool using the advanced option and set the application pool to run in 32 bit mode.

Once the application pool is running in 32 bit mode you will be able to use the Access JET 32 bit driver which comes with Windows 2008.

Microsoft actually recommend that you run application pools in 32 bit mode as they say that not only do you get better compatibility with 32 bit drivers, components, etc. but also it gives better memory usage and performance, so you may want to change the default application pool settings to always use 32 bit mode.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting