Loading

connection problem to my database in C# and MySql

connection problem to my database in C# and MySql

Stalin Antony Huallullo Cirineo

Stalin Antony Huallullo Cirineo

9y1.4kVisual Basic .NET

Hello friends my name is Stalin and I have a connection problem to my database

I made a software and I connect through my local database;

When I install it on others PCs in my environment, the connection fail and prints this error:

Error: "host" Stalin-PC "is not allowed to connect to this mysql server"

My connection is via App.exe.config with the "System.Data.SqlClient" extension.

This is my connection. I did it dynamically for this reasons :

1) Connection to the database

2) License by installation date.

3) Disappear the button that makes possible the creation of the connection

Note: The language is C # (WPF) and Mysql (AppServer)

3 Replies

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

Amit Gupta9y ago
Yes, totally agreed with @Nitin.

Apart from this, if the remote pc is unable to connect through the code, just ping to that machine to assure that it is connected.

Make proper intranet connection and then retry.
0
Hariharan Krishnamoorthi9y ago
Hi Stalin,
Please change your providerName as below in your connection string.
providerName="MySql.Data.MySqlClient"
Thanks,
Hari
0
Nitin Sontakke9y ago
Your first screen shot indicates that you are using MySQL. I don't believe you can use System.Data.SqlClient for connecting to MySQL. It is exclusively written for Microsoft SQL Server only.

To the best of my knowledge (because I never used) you will have to use Oledb for connecting to all other databases than SQL Server.

I just googled and it seem a dedicated connector (dll) is available for MySQL.

See:
https://dev.mysql.com/downloads/connector/net/6.9.html

...and
https://www.codeproject.com/Articles/43438/Connect-C-to-MySQL
0