Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Error Connecting to database on mySQL Server
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error Connecting to database on mySQL Server

 Post Reply Post Reply
Author
RmB2u View Drop Down
Newbie
Newbie


Joined: 31 July 2006
Location: Netherlands
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote RmB2u Quote  Post ReplyReply Direct Link To This Post Topic: Error Connecting to database on mySQL Server
    Posted: 31 July 2006 at 3:09pm

Hi all,

I'am trying to config the forum, but i only get the error message below:

Error Connecting to database on mySQL Server
Check the following is set up and correct:-
mySQL Server User Name
mySQL Server Password
Name of the mySQL Server
Database name set up by you on the server
Empty Database set up by you on the mySQL Server
Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.

I allready have an existing MySQL database running, so I want to configure it in the existing database. (maybe with anoter prefix)
 
I did change the database_connection.asp like below:
 
strSQLServerName = "mysql.my-site.nl"
strSQLDBUserName = "my username"
strSQLDBPassword = "my password"
strSQLDBName = "my existing database"
 
The Web Wiz Forums Database mySQL Setup site is working fine, but the only thing i cannot do is login with another userid.
 
This because of the fact I only have 1 userid to modify/add into the database. (with this ID i can get into the database with PHPMyAdmin)
(this is the same ID wich is used for the connection string - in the file database_connection.asp)
 
What is going wrong ?
Can someone help me with this ?
 
Regards,
 
Robert.

 


Edited by RmB2u - 31 July 2006 at 3:11pm
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: 31 July 2006 at 5:39pm
I'm not sure what you are saying.

Are you saying that you already have an mySQL version of web wiz forums setup on mySQL?
Back to Top
RmB2u View Drop Down
Newbie
Newbie


Joined: 31 July 2006
Location: Netherlands
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote RmB2u Quote  Post ReplyReply Direct Link To This Post Posted: 31 July 2006 at 10:09pm

Hi,

No, i've allready a MySQL database in use at the moment (just for a photo gallery) , and in the same database i want to install the Web Wiz Forum.

The Web Wiz Forums Database mySQL Setup site is working fine, just only the log-in screen. When i try to log on, i get the error above.
 
Do you have some advise for me, thanks in advance,

Regards,

Robert.



Edited by RmB2u - 01 August 2006 at 11:03am
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: 01 August 2006 at 11:28am
You should be able to use your existing database fine, just make sure it has not tables with the prefix 'tbl' already in it, if you do then you need to alter the table prefix.

The error you are getting suggests that the connection details or login username and password are incorrect.

recheck your connection and login details are correct and you don't have any misspellings. Also check that you have the myODBC 3.51 database driver running on the server.
Back to Top
RmB2u View Drop Down
Newbie
Newbie


Joined: 31 July 2006
Location: Netherlands
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote RmB2u Quote  Post ReplyReply Direct Link To This Post Posted: 01 August 2006 at 7:20pm
Hi boRg,
 
It's working fine now. I've been calling with my ISP, but also i did try it from the office this time. Maybe my VPN policy @ home f*cks it up or something, because from the office it is been working great. !!!
 
Thanks for the quick assistence, and keep up the good work. !!
 
Kind regards,
 
Robert
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.