Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 
Monday, December 01, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
General
The ever-powerful ListX module forum. Post your questions, new configuration ideas and reviews.
Forums > Bi4ce.Modules.ListX > General
Subject: mySQL connection string help

You are not authorized to post a reply.   
Author Messages
empulse
Middleweight
Posts:81
08/26/2008 2:30 PM Alert 
I am trying to setup a mySQL connection string to a remote database, but cannot get it to work. Using the example in the manual results in an error:
"The 'MySQLProv' provider is not registered on the local machine"

I assume that I may need to do something in web.config.

I also think that there is a problem with the example string in the manual, since it does not specify a server.

If anyone has managed to get a mySQL connection working, I'd appreciate an example of how it was done.
ken.stessens
Middleweight
Posts:95
08/31/2008 8:17 AM Alert 
Hi,

this connection string works perfect for me:

Driver={MySQL ODBC 3.51 Driver};Server=MYSERVER;Database=MYDATABASE;User=MYUSER;Password=MYPASSWORD;Option=3;

If you enter this in the "view options > Query > custom connection string", you can use this throughout the entire module, even without changing the web.config


Hope this helps,
Ken
robert_chumley
Please Wait...
Posts:595
09/09/2008 9:37 AM Alert 
Thanks for the help Ken.
Robert Chumley
r2integrated (formally bi4ce)
ken.stessens
Middleweight
Posts:95
09/24/2008 11:37 AM Alert 
Hi,

I'd like some help myself now: instead of declaring the connection string in every module, I' rather do that once in the web.config

this is the syntax I currently have in the module:
Driver={MySQL ODBC 3.51 Driver};Server=MYSERVER;Port=3307;Database=MYDATABASE;User=MYUSER;Password=MYPASSWORD;Option=3;

I have tried this in the web.config:
<add key="MySqlDB" value="{MySQL ODBC 3.51 Driver};Server=MYSERVER;Port=3307;Database=MYDATABASE;User=MYUSER;Password=MYPASSWORD;Option=3;" />

and in the listX:
[MySqlDB,Configuration]

resulting in following error:
System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString.


Thanks,
Ken
Shaliksh
Welterweight
Posts:27
09/25/2008 4:01 PM Alert 
I am using following format in my web config and it works

<add key="OracleConnection" value=" Provider=OraOLEDB.Oracle;Data Source=lmydata.mydata.com;User Id=frontend;Password=superpass; " />

Hope This Helps
Shalik
R2Integrated
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > General > mySQL connection string help


ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation