.Net and Mysql connection string

dynasoft

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem: Hi, can anyone point me to examples for the above as I can't find any. I keep getting error Unable to find the requested .Net Framework Data Provider. Many thanks.

colin

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

Cheers,

Colin

dynasoft

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

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

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

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

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

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

I reference both MySqlConnector (1.2.1) and MySql.Data.dll (8.0.11). Could there be a conflict here?

dynasoft

Please advise

allan

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

Thanks. I initially did not have Driver={MySQL ODBC 5.3 ANSI Driver}; but it did not work either.

allan

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

Allan

dynasoft

.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

a reference to the MySQL.Data library

MySql.Data.dll is referenced

Is different case a problem?

dynasoft

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

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

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

Also I don't use Entity Fw.

dynasoft

Passing "MySql.Data.MySqlClient" as 3rd paramter to Database method and in using produces same error msg.

dynasoft

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

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