☰
Current Page
Main Menu
Home
Home
Editing MySqlConnectionString
Edit
Preview
H1
H2
H3
default
Set your preferred keybinding
default
vim
emacs
markdown
Set this page's format to
AsciiDoc
Creole
Markdown
MediaWiki
Org-mode
Plain Text
RDoc
Textile
Rendering unavailable for
BibTeX
Pod
reStructuredText
Help 1
Help 1
Help 1
Help 2
Help 3
Help 4
Help 5
Help 6
Help 7
Help 8
Autosaved text is available. Click the button to restore it.
Restore Text
#MySQL Connection String [[_TOC_]] ##About The MySqlConnectionString is used for setting up connections to My SQL databases. This will cause the AdHocContext.Driver object to become a MySqlDriver object. You can specify this setting for an entire user group or you can specify it per-user. ##ODBC Driver In order to connect to a MySQL database, you will need to have an ODBC driver installed on the server which is hosting the Izenda application. [Download the latest ODBC Connector](https://dev.mysql.com/downloads/connector/odbc/) ##Setting Up a MySQL Connection String To set up your MySql Connection String, use the AdHocSettings property MySqlConnectionString. Make sure the version of the driver in the connection string matches the version installed on your server. ```csharp Izenda.AdHoc.AdHocSettings.MySqlConnectionString = "Driver={MySQL ODBC 5.3 ANSI Driver};Server=localhost;Port=3307;Database=databasename;Uid=username;Pwd=password;pooling=false"; ``` You will have to replace your port number (if different), databasename, username, and password. Additionally, pooling=false may not be required in your case. ##Testing Your MySQL Connection String To test whether your MySQL connection string is working, there are some diagnostics on the Settings.aspx page that give a PASS/FAIL on various connectivity and permissions-based metrics.
Uploading file...
Header
 **This documentation is for the legacy Izenda 6 product. Documentation for the new Izenda 7 product can be found at [[https://www.izenda.com/docs/|https://www.izenda.com/docs/]]**
Sidebar
 --- * [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]] * [[Release Notes]] * [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]] * [[FAQ]] * [[Tutorials]] * [[The Izenda API|/API/AdHocConfig]] * [[The AdHocSettings class|/API/AdHocSettings]] * [Developer Links and Guides](/Guides/Developer-Links-and-Guides) * [[Known Issues]] --- * <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a> * [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A) * <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a> * <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a> * <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a> --- * [Guide To Report Design](/Guides/ReportDesign) * [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs) --- * [[Acknowledgements]]
Edit message:
Cancel