Learn More





DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact .

The use of the Community Blog is covered by our Community Blog Guidelines - please read before commenting or posting.

MySQL Provider (update)

June 2006 update - Since there is a MySQL provider available commercially, I am not working on the MySQL provider at this time.

First, let me warn you that we are AT LEAST 6 months away from having a DotNetNuke MySQL provider. This is just a blog to say that I have started working on it and to show you what I have learned so far (in case you want to follow along :)

Let me say, I am really impressed with MySQL. I was able to install it easily on my Windows XP machine and get it running in about an hour. I am a long time MS SQL user and was very frustrated with trying to use Oracle and Firebird. I realize the problem is that I am spoiled from MS SQL server, but hey I'm busy and I like easy to use tools :)

My goal is to start the MySQL provider then form a group to finish and maintain the development. Since I have never used MySQL before I downloaded it, installed it, and made a sample ASP.NET 2.0 web project that displayed data from a table in a GridView.

Here are my notes so far:

  1. Go to download and install “Current Release (Recommended).
  2. Download and install: MySQL Administrator (to Administer your MySQL Server. The first download just installs only the server) 
  3. Download and install: Connector/Net 1.0 (you need this to get your ASP.NET pages to talk to your MySQL server)
  4. You can also download: MySQL Query Browser – (a graphical client to work with your MySQL databases and run queries) however, I ended up paying $49.95 for MySQL Developer Studio because it was the most inexpensive tool that would allow me to open up a table and add data to it like you would with SQL server. All other tools require you to write an text “Insert SQL" statement. It also includes a graphical SQL query designer for designing your queries.
  5. Read and follow this guide: A Step-by-Step Guide To Using MySQL with ASP.NET (to get the sample from A Step-by-Step Guide To Using MySQL with ASP.NET to work I went to “C:\Program Files\MySQL\MySQL Connector Net 1.0.7\bin\.NET 2.0” (installed with Connector/Net 1.0) and copied the “MySql.Data.dll” to the “/bin” directory of my sample 2.0 project).

Now I have MySQL up and running and it feels as familiar as MS SQL server. Already I am sold on it as a product and I can see how a lot of people will love to run DotNetNuke on it once a provider becomes available.


Comment Form

Only registered users may post comments.


2sic Daniel Mettler (124)
Aderson Oliveira (15)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (21)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (203)
Chris Paterra (55)
Clinton Patterson (28)
Cuong Dang (21)
Daniel Bartholomew (2)
Dave Buckner (2)
David Poindexter (3)
David Rodriguez (2)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (74)
Geoff Barlow (6)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (3)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (268)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Peter Donker (52)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Wilkinson (3)
Scott Willhite (97)
Sebastian Leupold (80)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (2)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (37)
Will Strohl (163)
William Severance (5)
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?