New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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.


Aderson Oliveira (22)
Alec Whittington (11)
Alessandra Davies (3)
Alex Shirley (10)
Andrew Hoefling (3)
Andrew Nurse (30)
Andy Tryba (1)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (37)
Ben Schmidt (1)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (12)
Bill Walker (36)
Bob Kruger (5)
Bogdan Litescu (1)
Brian Dukes (2)
Brice Snow (1)
Bruce Chapman (20)
Bryan Andrews (1)
cathal connolly (55)
Charles Nurse (163)
Chris Hammond (213)
Chris Paterra (55)
Clint Patterson (108)
Cuong Dang (21)
Daniel Bartholomew (2)
Daniel Mettler (181)
Daniel Valadas (48)
Dave Buckner (2)
David Poindexter (12)
David Rodriguez (3)
Dennis Shiao (1)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (80)
Francisco Perez Andres (17)
Geoff Barlow (12)
George Alatrash (12)
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 (274)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (4)
Jordan Coopersmith (1)
Joseph Craig (2)
Kan Ma (1)
Keivan Beigi (3)
Kelly Ford (4)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Malik Khan (1)
Matt Rutledge (2)
Matthias Schlomann (16)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (3)
Michael Washington (202)
Miguel Gatmaytan (3)
Mike Horton (19)
Mitchel Sellers (40)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Oliver Hine (1)
Patricio F. Salinas (1)
Patrick Ryan (1)
Peter Donker (54)
Philip Beadle (135)
Philipp Becker (4)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Sacha Trauwaen (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott Schlesier (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)
Steven Fisher (1)
Timo Breumelhof (24)
Tony Henrich (3)
Torsten Weggen (3)
Tycho de Waard (4)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (40)
Will Strohl (180)
William Severance (5)
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out