Web Wiz Forums - Microsoft OLE DB provider for ODBC Driver error

Print Page | Close Window

Microsoft OLE DB provider for ODBC Driver error

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

Topic: Microsoft OLE DB provider for ODBC Driver error

Posted By: vkyvijay
Subject: Microsoft OLE DB provider for ODBC Driver error
Date Posted: 05 November 2016 at 11:06am

I downloaded the latest version of Web Wiz Forums (11.07) and tried installing it on my IIS 10.
Windows 10 pc to test it.
But I am unable to connect to MySQL database.

Error Msg:
Microsoft OLE DB provider for ODBC Drivers
[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified.

My system details.

MySQL version : 5.7.16 x64
MySQL Connector: ODBC 5.3.6

Am able to connect using PHP and PHP applications running fine.

Did not try any other ASP application to check connectivity.

Forum 11.07 working fine with Access database.

So please help me.

Thanks in advance.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 07 November 2016 at 9:47am

The error is due to the myODBC Driver not being installed on your Windows 10 PC.

Currently Web Wiz Forums supports the myODBC 3.51 or myODBC 5.1 Drivers.

You would need to install one of these drivers on the server and then configure Web Wiz Forums to use either myODBC 3.51 or myODBC 5.1.

You can download the myODBC driver from the page below by clicking on 'Looking for previous GA versions?' and selecting the myODBC 3.51 or 5.1 versions.

https://dev.mysql.com/downloads/connector/odbc/" rel="nofollow - https://dev.mysql.com/downloads/connector/odbc/

However, I would advise to use a SQL Server Database with Web Wiz Forums.

-------------
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: vkyvijay
Date Posted: 14 November 2016 at 3:14pm

Thanks for your reply but I have already installed ODBC Driver 5.3.6 and selected myODBC 5.1 but still no go.

Any further suggestions.

Posted By: WebWiz-Bruce
Date Posted: 15 November 2016 at 8:50am

The myODBC 5.3 driver is not the same driver as the myODBC 5.1 driver. The version that you select needs to match the installed version.

You would need to download and install the myODBC 5.1 driver.

We are currently testing support for myODBC 5.3 driver but in the current version the myODBC 5.3 driver is not supported.

-------------
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