Web Wiz Forums - Help me with Installation

Help me with Installation

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=27296
Printed Date: 01 April 2026 at 8:50pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Help me with Installation

Posted By: varushar
Subject: Help me with Installation
Date Posted: 27 April 2009 at 7:44am

Hi All,

I downloaded both mysql version of code.

I installed mysql5, mysql admin tool and created schema called webwizforums by using this information:

Database: localhost, user:varushar; password: guessit

I updated the database_connection.asp and set the following values:

strSQLServerName = "localhost"
strSQLDBUserName = "varushar"

strSQLDBPassword = "guessit"

strSQLDBName = "webwizforums"

When I accessed page: http://localhost/Forum/mySQL_server_setup.asp" rel="nofollow - http://localhost/Forum/mySQL_server_setup.asp and entered username/password i am getting following error:

Detailed Error Message:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Error Details:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

------------------------------------------------------------------------------

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:- common.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

---------------------------------------------------------------------------------------------

Please help me with this...

Waiting for response...

Replies:

Posted By: WebWiz-Bruce
Date Posted: 27 April 2009 at 8:07am

You need to also install the myODBC 3.51 driver on the server. It's available from the mySQL website as a suppurate download.

The newer myODBC 5.1 driver is also supported, but you will need to enable support for this in the database/database_connection.asp file by uncommenting the line below:-

'strMyODBCDriver = "5.1"

-------------
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: varushar
Date Posted: 27 April 2009 at 8:30am

Thanks a lot WebWiz-Bruce...

You made my day.. thanks a lot once again