DotNetNuke Data Provider for MySQL is a data access layer based on dotConnect for MySQL. It allows DotNetNuke to work with MySQL server. This topic provides information on installing and using the DotNetNuke Data Provider for MySQL.
What Is DotNetNuke?
DotNetNuke is an open-source web application framework for creating and deploying projects such as commercial websites, corporate intranets and extranets, online publishing portals, and custom vertical applications. DotNetNuke is provided as open-source software, licensed under a BSD agreement.
DotNetNuke is built on a Microsoft ASP.NET (VB.NET) platform, and is easily installed and hosted. For more information on the product refer to DotNetNuke official site.
Note that DotNetNuke Data Provider for MySQL should be downloaded from the site separately from the dotConnect for MySQL installation. To download the file visit the following page: http://www.devart.com/dotconnect/mysql/download.html
Supported Modules
dotConnect for MySQL provides data layers for the following modules:
- Announcements (v03.04.00)
- Documents (v03.01.06)
- Events (v03.03.08)
- FAQs (v04.04.00)
- Feedback (v04.04.01)
- IFrame (v03.02.03)
- Links (v03.03.07)
- Repository (v03.01.13)
- UserDefinedTable (v03.04.00)
- UsersOnline (v03.01.00)
Requirements
- MySQL Server version 5.0 and higher
- Internet Information Server 5, 6 or 7
- ASP.NET Framework 2.0
- User must have sufficient permissions to install applications on the web server
- Appropriate DotNetNuke version must be installed correctly on the web server
- Appropriate dotConnect for MySQL version must be installed correctly on the web server
Installation
To start using dotConnect for MySQL with DotNetNuke, perform the following steps:
Make sure dotConnect for MySQL is installed on the web server you are working with.
Unpack the compressed file mysqldnn.zip to the root folder of your site. DotNetNuke files should be there already.
Note that some files will be overwritten, so it is recommended that you make a backup copy.
Adjust the connection string to match your configuration for all "SiteMySqlServer" occurrences in the DevartMySql-DNN-4.7.0.0.config file and rename it to Web.config.
Start the initialization routine of the site and follow the wizard. The necessary database objects and data will be created in the database you specified in the connection string.
Note that upgrade of database objects is not supported.
Compatibility
DotNetNuke Data Provider for MySQL is tested with dotConnect for MySQL 4.50 and DotNetNuke version 4.7.0.0. MySQL Server version should be 5.0 or higher. Please note that compatibility with other versions of DotNetNuke is not guaranteed.
© 2002-2008 Devart. All rights reserved.