IIS 7 and Above
MySql DB Manager provider
Last post Jun 15, 2011 07:36 AM by caban13
Apr 13, 2009 03:18 AM|ma_khan|LINK
We do not have built-in support for MySql but does anyone know of a provider for the DB Manager???
Edit: do we have a hotkey available for Execute! for an SQL query?
Apr 13, 2009 07:14 PM|moshaikh|LINK
Thats a good question. Let me find out and get back to you.
Apr 14, 2009 01:30 PM|SaadL|LINK
At this time, I do not believe that there are any MySQL providers for DB Manager. I will post back on the forum if/when I hear of one.
As to executing a query, you can hit the F5 key in the query editor to get the results back. Hope this helps.
May 04, 2009 11:53 AM|cooshal|LINK
I had the same problem too...........
But I somehow got access to the following tool, which is even recommended by the Microsoft experts, try it. But the problem is that, I am unable to configure it. So, if anybody succeeds, then please do post back.
May 25, 2009 05:29 PM|limonata|LINK
From the IIS database homepage, it mention that it does support other database and I paste this quote from the IIS's page on database manager. I even remember from the one of the video on IIS that you can add custom database into database manager. if someone
found a sample connection string for mysql connection, please forward to here.
IIS Database Manager provides native support for SQL Server and is also fully extensible for developers to add support for other database systems.
IIS Database Manager has an extensible architecture that allows new database types to be added. The provider model allows administrators to implement and register a new database provider on the server to manage that database. Users can leverage IIS Manager
for administration of the database connections regardless of the database to which you want to connect.
Jun 17, 2009 01:16 PM|richma|LINK
Here is an example adding custom provider which is what you would need to do to plug into other databases not current supported.
The following is an example from Beta that shows how to do this with SQL ..
Note that the Assembly to reference is now : Microsoft.Web.Managment.DatabaseManager
And in the method GetServerTypes the ID property no longer exists this could be replaced with Tag .. or you could rewite the implementation of this as you wish to provide datatype information.
Sep 30, 2009 11:12 AM|ma_khan|LINK
IIS DBManager v1 has MySQL DB provider ... but is there an article on how to connect to a Windows 7 machine running IIS and MySQL...
I have looked around and there doesnt seem to be one...
Sep 30, 2009 12:13 PM|richma|LINK
I dont believe anything has been published on this.Here are the steps on how to create a connection. If there are other details you are looking for please let us know.
1. Open IIS Manager
2. Select the Server in the Connections Tree View
3. Select Database Manager User Interface and click Open Feature.
4. Click the Add Connection icon in the top left.
5. Under Database provider select: MySql5.x,6.x(MySql.Data.MySqlClient)
6. In the Add Connection dialog, enter Connection name, Server, Database, UId, and Pwd and Port.The following is an example of the field entries for connecting to the local instance of mySql
Database: <Your DB Name>
UID:root ( root is the default Admin account for MySQL)
Pwd: <PWD for root account>
Port:3306 ( Default Port for MySQL)
Sep 30, 2009 02:10 PM|ma_khan|LINK
Your answer looks pretty simple except for the fact that I dont ever get the 5th point... Meaning I never get the MySql.Data.MySqlClient option... I am pretty sure I have DBManager v1..
Here's the snippet from Administration.config:
<add name="DBManager" type="Microsoft.Web.Management.DatabaseManager.DBManagerModuleProvider, Microsoft.Web.Management.DatabaseManager, Version=188.8.131.52, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<provider name="SQL Server 2005/2008" providerName="System.Data.SqlClient" type="Microsoft.Web.Management.DatabaseManager.SqlDatabase.SqlDatabaseProvider, Microsoft.Web.Management.DatabaseManager.SqlDatabase, Version=184.108.40.206, Culture=neutral,
<provider name="MySql 5.x, 6.x" providerName="MySql.Data.MySqlClient" type="Microsoft.Web.Management.DatabaseManager.MySqlDatabase.MySqlDatabaseProvider, Microsoft.Web.Management.DatabaseManager.MySqlDatabase, Version=220.127.116.11, Culture=neutral,
But I never see the 2nd provider as an option in any of my sites... I am using Windows 7 32-bit
Sep 30, 2009 04:04 PM|richma|LINK
Your provider setup looks correct here. Are you seeing any errors when you open the Database Manager and click Add connection ?
Are there any errors in the applicaiton event log ?
Can you successfully connect to SQL using the SQL provider ?
Oct 01, 2009 10:39 AM|ma_khan|LINK
No errors with DB manager at any point in time... No errors in the Event logs... I will check the connection with MS SQL today...
Oct 01, 2009 11:18 AM|richma|LINK
Oct 01, 2009 12:34 PM|CarlosAg|LINK
Do you know if MySQL Connector is installed and setup in your machine?
Oct 01, 2009 01:06 PM|ma_khan|LINK
I get an error as soon as I put the code into administartion.config file... well that's expected...
I open machine.config file and don't find the dbProviderFactory text in the whole file...
So as I see it DB Manager is working somehow but there seems to be a problem with one of the providers?? I will check with MS SQL later tonight just to be sure on that as well..
Oct 01, 2009 03:18 PM|CarlosAg|LINK
Could you try installing MySQL connector (Specifcally the ADO.NET Driver for MySQL):
Oct 02, 2009 09:37 AM|ma_khan|LINK
Carlos & Richard,
It was the Connector that was missing... once that is in place we are good to go...
But what I want to know is... Should the connector have been there during IIS DB manger or MySql installation ???
Or is it that we just needed to know that the connector should be there to get the IIS DB manager working with MySql...
Thanks anyways... the tool's awesome BTW... :)
Wrote an article about configuring it at
Oct 02, 2009 10:36 AM|richma|LINK
Good to here its working. The connector is not installed as part of the DB manager but we are looking at including this an associated or dependency install when Web Platform Installer is used. We will also look into other ways to handle this condtition
so users are informed when in this state.
Thanks you very much for reporting this.
Jun 14, 2011 06:52 PM|caban13|LINK
Jun 14, 2011 11:19 PM|HCamper|LINK
Yes It could be a mystery language for the current topic if you have not been using MySQL Connectors.
This is a dated discussion for "MySQL Net Connector" much has changed since this thread was started.
Question what kind of Programming or Database Access do you require?
I suggest that you start a new thread with what Programming or Data Base access requirements are
then answers that are more up to date can be provided.
Jun 15, 2011 07:36 AM|caban13|LINK