How to establish a connection to the database from aspnet?

Question

MySQL

I'm trying to connect to a free remote database:

"UserConnection": "Server=sql7.freesqldatabase.com,3306;Database=db;User Id=user;Password=psw;",

But when creating it, it gives an error:

InvalidOperationException: Internal connection fatal error.
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, uint waitForMultipleObjectsTimeout, bool allowCreate, bool onlyOneCheckConnection, DbConnectionOptions userOptions, out DbConnectionInternal connection)

How to fix it?

Answer 1

First, you have a fundamentally wrong connection string, second, the server address is passed in the connection string, not the dns name, for connecting via dns, see the last part https://dev.mysql.com/doc/connector-net/en/connect ...

Answer 2

Where is the connection string from?
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;