Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...MySQL connectorMySQL connector
Previous
 
Next
New Post
2/1/2011 7:36 AM
 

Would you please describe in brief the process of connecting DotNetNuke to the MySQL server.

I've found http://www.devart.com/dotconnect/mysql/download.html but it doesn't work (bunch of errors) for me.

Thanks in advance.

 
New Post
2/1/2011 9:08 AM
 
apparently that provider only works for DNN 4.7.0. I would very much advise you to not use this provider, since there have been numerous security fixes to the DNN platform since then. Also, you would be limited to use modules that support MySQL. I don't have numbers on modules that offer support, but i guess it would be close to 0. If you require a free DB Server, i would seriously consider using SQL Server Express.

Erik van Ballegoij, Former DNN Corp. Employee and DNN Expert

DNN Blog | Twitter: @erikvb | LinkedIn: Erik van Ballegoij on LinkedIn

 
New Post
2/1/2011 11:27 AM
 
While the database provider system is still part of the dnn design model - the dnn core install really no longer supports any provider but MS SQL Server.   There are just too many MS SQL specific stored procedures in the core and pretty much in every 3rd party module for it to be practical to work functionally with other sql servers.

And given that dnn works with ms sql express (free) there is no real reason to go down that path anyway.

Tools like dotconnect are designed to help developers connected to a mysql server for their own projects.  What they dont do, is work thru the fact that the  scripting systems are different for every brand of sql server.

Westa
 
New Post
2/1/2011 12:01 PM
 
If you have data in a MySQL data that you want to display, this can be done.   There are several modules that will allow you to define an alternate connection string to access such data.    So you can define the appropriate connection string to your MySQL database and use these modules to display the data.  (see www.connectionstrings.com for examples of appropriate connection string to MySQL)  

In fact, you can access any database that you can define the appropriate connection string (and have the required provider) - Excel, MS-Access, Oracle, DB2, ...

The Report module can access an alternate database via a user supplied connection string.  Also consider SQLGird (Pro) from DNNStuff and/or SQLGridSelectedview from Tressleworks.

Note: You will still need to use SQL Express (or better) to run the DotNetNuke Site.

Hope this helps
Paul.
 
 
New Post
2/2/2011 8:39 AM
 
Thank you all very much, I've used MS SQL Server.
Please close the thread.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...MySQL connectorMySQL connector


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out