How to use Multiple MySQL Connector

Saravanan Ponnusamy

Recently im trying to change all my .NET C# projects to MySQL from MSSQL.

so i installed latest version MySQL and connector 8.0.13.

here my issue is connector 8.0.13 "mysql.data.dll" will support only .NET 6.0 and above..

but my projects some are .NET 6.0, some .NET 4.0, some .NET3.5 ..

connector 6.3.5 will support .NET4.0 .. Connector 5.3 will support .NET 3.5 .. but windows allow to install one connector at a time...

is there is any way to use multiple MySQL Connector in single machine...

or any other solution..

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta7y ago
Regarding ExecuteReader, just re-check that the cmd is using the connection that you used in opening connection
0
Amit Gupta7y ago
If you are using on VM, I suggest you to use the IP address of that machine, if it is connected to DHCP then create an IP (just like when we require to connect two pc with LAN) and then try. Try to ping that machine with that IP, if all done then go ahead
0
Saravanan Ponnusamy7y ago
no amit.. if i install latest version connector and i use that mysql.data.dll for .net 3.5 and 4.0 it throws error.. it makes my application to upgrade .net framework to 6.0 and above... i want my application which should run at .net 3.5 and 4.0...

also can you help one error which recently facing while im connecting to mysql database from code base..

this is the error "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond" ..

conn.open() -- working fine

Cmd.ExecuteReader(); -- throws this error..

im using mysql in two places.. one in local machine and one in virtual machine in same computer.. but both are separate.. installed separate MySQL workbench.. im not going to do anyway of connection from VM to local PC..

in local machine everthing working fine.... but in VM im getting this error...

i searched in google.. some solutions say to use '127.0.0.1' insted of locahost in connection string.. i used .. but no use..

can you help me..
0
Amit Gupta7y ago
Installing the higher version will take care of the compability. Isn't that happening? Upgrade your other references then Clean and rebuild your project
0