Connection with .NET

Vikram

Hi,
I am trying to connect MySQL from .NET. I have installed MySQL properly. Also I have installed .NET connector. But I am getting error "Unable to connect Server".

Thanks,

VIkram

6 Replies

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

jitendra kumar16y ago
go though this link and download necessary file for MYSQL
http://www.sqlstrings.com/mysql-asp.net-connection.htm
http://aspnet101.com/tutorials.aspx?id=39
0
Kirtan Patel16y ago
Seems You have Problem in Connection String of C# code ..

can you post your Connection string here ...?
0
Vikram16y ago
Thanks Jitendra,

I tried all option which you are given but still getting same error. Is there any other solution.
0
jitendra kumar16y ago
Read this article
http://ziya.suzen.net/2009/01/mysql-high-volume-connection-issue-when.html
and see the given link where a lots of connectionstrings are given there for different database.
http://connectionstrings.com/
0
Vikram16y ago
Thanks Lalit,

     Actually Database is working fine and also I tried start and stop of MySQL Service. My problem is that I can not connect it from .NET. It gives MySQLException that "Unable to connect server".

Thanks
   VIkram

0
Lalit M16y ago
Try start/stop the mysql service on the server by logging into the server as root from the command line interface and run the following command/s.

service mysql stop
service mysql start
service mysql restart

You can also use the following.

/etc/init.d/mysql start
/etc/init.d/mysql stop
0