Answers

• colin Posts: 15,177Questions: 1Answers: 2,590

  July 2021

  This thread should help, it's asking the same thing.

  Cheers,

  Colin
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  Hi,
  Thanks. However I still get error 'Unable to find the requested .Net Framework Data Provider. It may not be installed.'. Are there drivers I need to install ? Conncting elsewhere in my code via ODBC works fine.
• colin Posts: 15,177Questions: 1Answers: 2,590

  July 2021

  Bit of a basic question, but I assume you've downloaded the Editor package? Was this working for you before, or is this a new installation?

  Colin
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  Hi, yes its all there. My project is working fine with sqlserver but setting tings up for mysql won't work for editor. Works fine elsewhere in my code. The project was built so it supports sqlserver and mysql. Last bit is to make Editor work with mysql
• colin Posts: 15,177Questions: 1Answers: 2,590

  July 2021

  This is my connection settings for .NET and MySQL:

  colin@colin-dektop:/mnt/DataTablesSrc/extensions/Editor-NETCore-Demo/Editor NET Core demo/Properties$ cat launchSettings.json 
  {
    "$schema": "http://json.schemastore.org/launchsettings.json",
    "iisSettings": {
      "windowsAuthentication": false,
      "anonymousAuthentication": true,
      "iisExpress": {
        "applicationUrl": "http://localhost:57111",
        "sslPort": 0
      }
    },
    "profiles": {
      "IIS Express": {
        "commandName": "IISExpress",
        "launchBrowser": true,
        "launchUrl": "examples/index.html",
        "environmentVariables": {
          "ASPNETCORE_ENVIRONMENT": "Development",
          "DBTYPE": "mysql",
          "DBCONNECTION": "Server=127.0.0.1;Port=3306;Database=test;Uid=sa;Pwd=MyPASSWORD;"
        }
      },
      "Editor_NET_Core_demo": {
        "commandName": "Project",
        "launchBrowser": true,
        "launchUrl": "examples/index.html",
        "applicationUrl": "http://localhost:5000",
        "environmentVariables": {
          "ASPNETCORE_ENVIRONMENT": "Development",
          "DBTYPE": "mysql",
          "DBCONNECTION": "Server=127.0.0.1;Port=3306;Database=test;Uid=sa;Pwd=MyPASSWORD;"
        }
      }
    }
  }
  

  Could you take a look please and see if that's comparable to yours. We use .NET under Linux, but it should be the same.

  Colin
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021 edited July 2021

  Thanks. My code is in a Model class as per below:

          public static DtResponse CRUDXxx(Int16 tpe, XxxUISettings lblo)
          {
              string strTp = string.Empty;
              Editor editor = null;
              NameValueViewModel[] arrNVVM = null;
  
              try
              {
                  HttpRequest formData = HttpContext.Current.Request;
  
                  arrNVVM = CommonAttributes.GetLogTypesViewModel();
  
                  using (Database db = new Database("mysql", "Server=127.0.0.1;Port=3306;Database=mydb;Uid=root;Pwd=mypswd;"))
                  {
                      editor = new Editor(db, "ProgrammeXxx").Model<XxxDBModel>();
                      editor.Field(new Field("id")
                          .Set(false)
                      );
                      editor.Field(new Field("EntryType")
                          .GetFormatter((val, host) => Array.Find(arrNVVM, o => 
                              o.Name == val).strValue)
                          .Set(false)
                      );
                      editor.Field(new Field("EntryDateTime")
                          .GetFormatter((val, data) => val)
                          .Set(false)
                      );
                      editor.TryCatch(false);
                      editor.Debug(true);
                      editor.Process(formData);
                  }
                  arrNVVM = null;
                  lblo = null;
              }
              catch (Exception ex)
              {
                  //...
              }
              return editor.Data();
          }
  

  Error ocurrs in the using line. Works fine with sqlserver. Thanks.
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  Adding a reference to the drivers to use does not fix the issue:

  using (Database db = new Database("mysql", "Driver={MySQL ODBC 5.3 ANSI Driver};Server=127.0.0.1;Port=3306;Database=mydb;Uid=root;Pwd=mypswd;"))
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021 edited July 2021

  I reference both MySqlConnector (1.2.1) and MySql.Data.dll (8.0.11). Could there be a conflict here?
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  Please advise
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  July 2021

  When set for mysql the Database class will use MySql.Data.MySqlClient [reference.

  MySql.Data.dll I would have thought would be enough, but Driver={MySQL ODBC 5.3 ANSI Driver}; might be causing it issues. What if you drop that part?

  Allan
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  Thanks. I initially did not have Driver={MySQL ODBC 5.3 ANSI Driver}; but it did not work either.
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  July 2021

  What was the error without it, and does your project has a reference to the MySQL.Data library?

  Allan
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021 edited July 2021

  .Error was the same:

  'Unable to find the requested .Net Framework Data Provider. It may not be installed

  MySql.Data.dll is referenced and in the bin folder
• tangerine Posts: 3,350Questions: 37Answers: 394

  July 2021

  a reference to the MySQL.Data library

  MySql.Data.dll is referenced

  Is different case a problem?
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  I think Allan used 'MySQL.Data' in his reply. I have MySql.Data throughout and I just add the reference via the IDE so I don't think thats the issue.
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  July 2021

  Are you using .NET 5 / .NET Core or .NET Framework?

  If 5 or Core, you need to register the client - e.g. in Program.cs you might have (in Main):

  DbProviderFactories.RegisterFactory("System.Data.SqlClient", SqlClientFactory.Instance);
  

  Along with a using MySql.Data.MySqlClient; line.

  Allan
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  I use .Net fw 4.72 so I think from what I see DbProviderFactories does not expose RegisterFactory

  Adding the line using MySql.Data.MySqlClient; does not do anything

  Would you have anything else I can look out for? Thanks.
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  Also I don't use Entity Fw.
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  Passing "MySql.Data.MySqlClient" as 3rd paramter to Database method and in using produces same error msg.
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021 edited July 2021

  Adding to web.config:

  <system.data>
  <DbProviderFactories>
  <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory,MySql.Data" />
  </DbProviderFactories>
  </system.data>

  Seems to work. Still testing..
• dynasoft Posts: 429Questions: 68Answers: 3

  July 2021

  Adding that entry into web.config works well. Thanks.