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

  New Posts New Posts RSS Feed - Help with MySQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Help with MySQL
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
lordtec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 16 July 2007
Location: Brazil
Status: Offline
Points: 213 		Post Options Post Options   Thanks (0) Thanks(0)   Quote lordtec Quote  Post ReplyReply Direct Link To This Post Topic: Help with MySQL
    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.
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: 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:-
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
lordtec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 16 July 2007
Location: Brazil
Status: Offline
Points: 213 		Post Options Post Options   Thanks (0) Thanks(0)   Quote lordtec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
lordtec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 16 July 2007
Location: Brazil
Status: Offline
Points: 213 		Post Options Post Options   Thanks (0) Thanks(0)   Quote lordtec Quote  Post ReplyReply Direct Link To This Post 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)
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: 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
AllMor View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70 		Post Options Post Options   Thanks (0) Thanks(0)   Quote AllMor Quote  Post ReplyReply Direct Link To This Post 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 & ";"
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 (1) Thanks(1)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
AllMor View Drop Down
Groupie
Groupie
Avatar

Joined: 16 April 2010
Location: Denmark
Status: Offline
Points: 70 		Post Options Post Options   Thanks (0) Thanks(0)   Quote AllMor Quote  Post ReplyReply Direct Link To This Post Posted: 14 September 2012 at 9:49pm
But it´s the only way I can make it work with my provider at this time. Confused
I will contact my Server Admin and ask them to install the myODBC driver.
 
Thanks for your support Bruce,
 
Kind regards
 
Allan
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.