Help with MySQL

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=30476
Printed Date: 31 March 2026 at 4:48am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Help with MySQL

Posted By: lordtec
Subject: Help with MySQL
Date Posted: 07 September 2012 at 3:16am

How do I inform fields and tables to configure a new forum with databank of My SQL.

I´m asking because I´ve always used a databank based on Access. I´ve never used My SQL.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 07 September 2012 at 12:28pm

When installing Web Wiz Forums the install wizard will ask you for the connection details for your blank mySQL database. It will then create all the tables and default data in the blank databaase required for Web Wiz Forums to run.

The page below has step by step instructions on installing the mySQL version:-

http://www.webwiz.net/web-wiz-forums/kb/mySQL-install.htm" rel="nofollow - http://www.webwiz.net/web-wiz-forums/kb/mySQL-install.htm

-------------
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: lordtec
Date Posted: 08 September 2012 at 2:53am

I'm having the following error with myODBC Database Driver:5.1

Test Database Connection

Test Database Connection
An Error Occurred Connecting to the Database Error details:- Microsoft OLE DB Provider for ODBC Drivers [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Posted By: lordtec
Date Posted: 08 September 2012 at 2:57am

with myODBC Database Driver: 3.51 the error is:

Test Database Connection

Test Database Connection
An Error Occurred Connecting to the Database Error details:- Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'dbmy0099.whserver.com' (11004)

Posted By: WebWiz-Bruce
Date Posted: 10 September 2012 at 4:43pm

The error suggest that the host name you have provided dbmy0099.whserver.com, is incorrect.

Contact your hosting provider for the correct connection details for your mySQL database.

Posted By: AllMor
Date Posted: 14 September 2012 at 1:00pm

Hi there,

Earlier I also got an error message similar to yours and I think I found a solution.
I changed a bit in the connection strings for MySQL

Here is my corrections.

setup_db_con_test.asp
From
strCon = "Driver={MySQL ODBC " & strMyODBCDriver & " Driver};Port=3306;Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
To
strCon = "Driver={MySQL};Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"

setup_database_connection.asp
From
strCon = "Driver={MySQL ODBC " & strMyODBCDriver & " Driver};Port=3306;Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
To
strCon = "Driver={MySQL};Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"

\database\database_connection.asp
From
strCon = "Driver={MySQL ODBC " & strMyODBCDriver & " Driver};Port=3306;Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
To
strCon = "Driver={MySQL};Option=3;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"

Posted By: WebWiz-Bruce
Date Posted: 14 September 2012 at 5:11pm

What you are doing there is changing the driver from the OBDC Driver to the generic mySQL driver.

This will not work as you will find problems in your forum. You would need to change the connection string back to how it was before and contact your server admin and have them install either myODBC 3.51 or myODBC 5.1 driver on the server.

Once this is done install web wiz forums again and select which ever myODBC driver your server admin has installed on the server.

Posted By: AllMor
Date Posted: 14 September 2012 at 9:49pm

But it´s the only way I can make it work with my provider at this time.

I will contact my Server Admin and ask them to install the myODBC driver.

Thanks for your support Bruce,

Kind regards

Allan