Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Catastrophic failure while connecting to DB
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Catastrophic failure while connecting to DB
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
kharelrupak View Drop Down
Newbie
Newbie
Avatar

Joined: 15 December 2007
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote kharelrupak Quote  Post ReplyReply Direct Link To This Post Topic: Catastrophic failure while connecting to DB
    Posted: 15 December 2007 at 4:38pm
Hi,
I am sure that you will be able to help me here.
I have my website hosted by webwiz host. I have a website and webwiz forum installed. It was running properly until today when suddenly i started getting message saying
 
Server Error in Forum Application
An error has occured while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_db_connection
File Name:- common.asp

Error details:-
Provider
Catastrophic failure
 
This is the error on forum, and my asp application also gives the catastrophic failure error.
When i trace the line of codes in my application i was able to find a line of code.
 
Private Function connectDatabase()    'connects to the database and opens a connection.
  sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER= " & dbhost & "; DATABASE= " & dbname & "; " &_
  " UID= " & dbuser & ";PASSWORD=" & dbpassword 
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open(sConnection) //this is the line that is throwing error
End Function
 
i am sure this is the server problem since all were working well before.
 
Waiting for the response soon.
 
Regards
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: 15 December 2007 at 6:52pm
The problem appears to have been an issue with the myODBC driver becoming corrupted in the application pool memory of the server.

The myODBC driver is used so that your ASP website can talk to the mySQL database. The mySQL database is a good database but it is let down when used with ASP as we have to use the myODBC driver which does tend to have it's bugs.

We will look at updating the myODBC driver on the server your site is on as we are currently using an older myODBC 3.51.12 driver as we experienced issues with the server crashing underload when using newer versions of the myODBC driver when we applied Windows 2003 Server SP2 about 6 months ago.

This is the first time we have seen an issue of this kind with the myODBC 3.51.12 driver presently being used on the servers since rolling back to this older driver 6 months ago.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
kharelrupak View Drop Down
Newbie
Newbie
Avatar

Joined: 15 December 2007
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote kharelrupak Quote  Post ReplyReply Direct Link To This Post Posted: 15 December 2007 at 11:26pm

Thanks...  I had guessed that it can be problem with the driver... anyways its working fine right now.. lets see in future.... if it continuously starts to give me problems then i will have to think of moving to MSSQL.

Regards
Back to Top
jamie.townsend View Drop Down
Groupie
Groupie


Joined: 07 December 2007
Location: England
Status: Offline
Points: 114 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jamie.townsend Quote  Post ReplyReply Direct Link To This Post Posted: 16 December 2007 at 12:21am
I work for a big uk hosting company and this tends to popup every now and then.
Generally an application pool recycle fixes the issue.
 
I can not stress enough that you should migrate to MSSQL especially if you have a database included in your hosting package !
Back to Top
hassanx View Drop Down
Newbie
Newbie


Joined: 29 January 2006
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hassanx Quote  Post ReplyReply Direct Link To This Post Posted: 24 January 2008 at 1:59pm
Hello,

I get the same error for 3 days..


Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Service Components
Catastrophic failure


I'm on Brinkster server (paid, not free) and the customer service said that he doesn't see any obvious errors in myconnection string, but that is most likely caused by an issue in the code.

told me to see the following FAQ for sample database connections.

 http://kb.brinkster.com/Kb.asp?kb=108078


Any help would be appriciated :) I'm stuck..
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 January 2008 at 2:24pm
I'm afraid that your Brinkster guy is talking out his bottom or is one of these general clueless support guys who blame the code. This is the hosting version of 'try rebooting the computer' that you get when you phone an IT support department.

The issue is a server error. The database connection is a standard DSN-less connection, of which there isn't really many ways of doing it. If there was a connection string issue then these forums would be full of 1000's of people with the same error.

Often this error is coursed by a corruption in the app pool serving your site. Like Jamie says recycling the app pool usual fixes the issue.

If it keeps happening then it suggests a corruption with the DB driver. Usually reinstalling the MDAC drivers on the servers would fix this.

You should get back onto Brinkster and ask to talk to a server engineer who knows what they are talking about.


Edited by WebWiz-Bruce - 24 January 2008 at 2:30pm
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
hassanx View Drop Down
Newbie
Newbie


Joined: 29 January 2006
Status: Offline
Points: 11 		Post Options Post Options   Thanks (0) Thanks(0)   Quote hassanx Quote  Post ReplyReply Direct Link To This Post Posted: 24 January 2008 at 3:04pm
Originally posted by WebWiz-Bruce WebWiz-Bruce wrote:

I'm afraid that your Brinkster guy is talking out his bottom or is one of these general clueless support guys who blame the code. This is the hosting version of 'try rebooting the computer' that you get when you phone an IT support department.


LOLLOL

I was just logging back to talk again but somehow forum got back online again. With no problems.

So it's the server I should blame for this type of error.

Thank you so much again :)

LOL
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 January 2008 at 3:08pm
Most servers in a shared hosting environment are set to recycle the application pool every x number of minutes, usually between 6 and 24 hours. This helps reduce the amount of memory the server uses (app pools can use over 1gig of memory after a few hours) and also flushes out any issues like the one you mention.

If it keeps happening then you should get the server looked at as it suggests a server issue, or I have on occasion seen this type of error coursed by someone running bad code on the server who shares the same app pool as your web site.
Web Wiz Forums Hosting
ASP.NET Web Hosting
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.