Web Wiz Forums - Error Connecting to database on mySQL Server

Print Page | Close Window

Error Connecting to database on mySQL Server

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=20868
Printed Date: 11 April 2026 at 10:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error Connecting to database on mySQL Server

Posted By: RmB2u
Subject: Error Connecting to database on mySQL Server
Date 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.

Replies:

Posted By: WebWiz-Bruce
Date 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?

-------------
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: RmB2u
Date 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.

Posted By: WebWiz-Bruce
Date 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.

-------------
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: RmB2u
Date 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