Fix for MySQL Connector/Net 6.9.3

AJAX(112) Apple(1) Application Builder(244) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(11) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) DotNetNuke(12) EASE(20) Email(6) Features(99) Firebird(1) Form Builder(14) Globalization and Localization(6) Hypermedia(2) Installation(4) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(15) OAuth(6) OAuth Scopes(1) OAuth2(9) Offline(19) Offline Apps(4) Offline Sync(4) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(166) Reports(48) REST(28) RESTful(25) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(75) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) Stored Procedure(4) Teamwork(15) Tips and Tricks(83) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(332) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Tuesday, September 30, 2014PrintSubscribe
Fix for MySQL Connector/Net 6.9.3

The latest installer of MySQL Connector for .NET contains a bug that will cause an error in any Code On Time applications that attempt to use this provider. The bug report can be found here. The error message can be seen below:

MySQL connector for .NET server error.

In order to fix the error, please follow the steps outlined below:

1.    Press the Start button on the taskbar, and type in “Notepad”. Right-click on the Notepad program and press Run As Administrator.

Running the Notepad as an administrator.

2. On the toolbar, press File | Open, paste in the following path, and press Enter to open the file.


3. Press Ctrl+F keys on your keyboard, type in “MySql.Web.v20”. Remove the “.v20” part. Perform the operation on the MySqlMembershipProvider, MySqlProfileProvider, MySqlRoleProvider, and MySqlSiteMapProvider provider elements.

Finding the "MySql.Web.v20"lines to replace.

4. Save the file. On the toolbar, press File | Open. Paste in the following path and press Enter.


5. Perform the same changes as described above to remove the “.v20” from “MySql.Web.v20”.

6. Save the file.

7. Restart the app generator and proceed to regenerate your web application.

Labels: ASP.NET, MySQL