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

  New Posts New Posts RSS Feed - forum can't log into the database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

forum can't log into the database
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
billiam777 View Drop Down
Newbie
Newbie


Joined: 06 January 2012
Status: Offline
Points: 25 		Post Options Post Options   Thanks (0) Thanks(0)   Quote billiam777 Quote  Post ReplyReply Direct Link To This Post Topic: forum can't log into the database
    Posted: 20 August 2012 at 12:13am
This error comes up when going to the forum page or any page including admin

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:- database_connection.asp
Forum Version:- 10.03

Error details:-
Back to Top
Scotty32 View Drop Down
Moderator Group
Moderator Group


Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotty32 Quote  Post ReplyReply Direct Link To This Post Posted: 20 August 2012 at 11:06am
Do you have the relevant permissions set on the database?

For example the database may be configured to only allow local traffic (localhost) and you are connecting externally (ie IP Address or Hostname)?
S2H.co.uk - WebWiz Mods and Skins

For support on my mods + skins, please use my forum.
Back to Top
billiam777 View Drop Down
Newbie
Newbie


Joined: 06 January 2012
Status: Offline
Points: 25 		Post Options Post Options   Thanks (0) Thanks(0)   Quote billiam777 Quote  Post ReplyReply Direct Link To This Post Posted: 20 August 2012 at 4:13pm
I checked and its not set for localhost.  I also verified that some coldfusion pages I wrote can access the same database.
Back to Top
IanSmithISA View Drop Down
Groupie
Groupie


Joined: 21 October 2010
Location: Worcester
Status: Offline
Points: 127 		Post Options Post Options   Thanks (0) Thanks(0)   Quote IanSmithISA Quote  Post ReplyReply Direct Link To This Post Posted: 20 August 2012 at 5:08pm
Good afternoon,

I don’t know if this is an officially supported  route or if you are confident enough, but what I would do is modify the file

YourForum\database\database_connection.asp

and change

If Err.Number <> 0 Then               Call errorMsg("An error has occurred while connecting to the database.", "db_connection", "database_connection.asp")

to
                If Err.Number <> 0 Then               Call errorMsg("An error has occurred while connecting to the database.", Err.Description, "database_connection.asp")

Note the loss of quotes in the new value.

On my version this is line 165, this may give you a more informative error message.

Bye

Ian
Back to Top
billiam777 View Drop Down
Newbie
Newbie


Joined: 06 January 2012
Status: Offline
Points: 25 		Post Options Post Options   Thanks (0) Thanks(0)   Quote billiam777 Quote  Post ReplyReply Direct Link To This Post Posted: 20 August 2012 at 5:18pm
Thank you Ian...I changed the code and it didn't give me much more info.

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

Support Error Code:- err_mySQL_
File Name:- database_connection.asp
Forum Version:- 10.03

Error details:-
ADODB.Connection
Back to Top
billiam777 View Drop Down
Newbie
Newbie


Joined: 06 January 2012
Status: Offline
Points: 25 		Post Options Post Options   Thanks (0) Thanks(0)   Quote billiam777 Quote  Post ReplyReply Direct Link To This Post Posted: 20 August 2012 at 5:20pm
By the way, I am the host so if I need to make a change to something on the server I can do it...but like I said...I can access the database with coldfusion.
Back to Top
IanSmithISA View Drop Down
Groupie
Groupie


Joined: 21 October 2010
Location: Worcester
Status: Offline
Points: 127 		Post Options Post Options   Thanks (0) Thanks(0)   Quote IanSmithISA Quote  Post ReplyReply Direct Link To This Post Posted: 20 August 2012 at 5:39pm
Good evening,

I see that there is no error description anymore, which does mean that you changed the relevant thing. :-)

Support Error Code:- err_mySQL_

I would have expected now some thing like

Support Error Code:- err_mySQL_[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedrn a

The database driver should have returned some text describing the error but has returned an empty string.

You could replace err.Description with err.Number and Google the returned code, it will be something like -2147467259, but this might be pretty generic.

Beyond this I have no more ideas, I am new to having a WebWiz forum and am still learning my way around the internals.

I wouldn't assume that Cold Fusion is accessing the database in the same way as Web Wiz though.

Bye

Ian
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: 21 August 2012 at 9:30am
Did you get an error during the database setup using the setup wizard?
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  123>

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.