❔ Error while trying to connect to MySql using MySql .Data
While trying to connect to maria db using mysql.data i get this error:
Unhandled task exception:System.IndexOutOfRangeException: Index was outside the bounds of the array.at System.Diagnostics.TraceInternal.get_AppName () [0x0000e] in <e804fc8285a9419784599893ed028695>:0at System.Diagnostics.TraceInternal.TraceEvent (System.Diagnostics.TraceEventType eventType, System.Int32 id, System.String format, System.Object[] args) [0x0003d] in <e804fc8285a9419784599893ed028695>:0at System.Diagnostics.Trace.TraceError (System.String message) [0x00000] in <e804fc8285a9419784599893ed028695>:0at MySql.Data.MySqlClient.MySqlTrace.LogError (System.Int32 id, System.String msg) [0x00026] in <89b4d3936e0b4e49b8d299ddbfe7933d>:0 [ script:LLL_CORE_CS] at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x0002e] in <89b4d3936e0b4e49b8d299ddbfe7933d>:0at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x0001c] in <89b4d3936e0b4e49b8d299ddbfe7933d>:0at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00245] in <89b4d3936e0b4e49b8d299ddbfe7933d>:0at TestDB.Class1.DBTESTAsync () [0x0002f] in C:\Users\Maurice\source\repos\TestDB\TestDB\Class1.cs:22Recreating Infos:Builder: dotnet on Debian 10.13Code:using System;using System.Threading.Tasks;using MySql.Data.MySqlClient;namespace TEST.Server{public class ServerMain{public static void DBTEST(){var connString = "server=localhost;user=NAME;database=NAME;port=3306;password=***";MySqlConnection conn = new MySqlConnection(connString);try{Console.WriteLine("Connecting to MySQL...");conn.Open();}catch (Exception ex){Console.WriteLine(ex.ToString());}}public ServerMain(){DBTEST();}}}
4 Replies
bump
You probably have checked the connection string correctly, but If you would like to double check the connection string format as given here... https://www.connectionstrings.com/mysql/ !
Also, I'm just wondering if the "NAME" is a variable or an actual value because if you're going for the variable you're missing the string interpolation and stuff!
MySQL connection strings - ConnectionStrings.com
Connection strings for MySQL. Connect using MySqlConnection, MySQLDriverCS, SevenObjects MySqlClient, Devarts MySqlConnection, MySQLProv.
Thanks for the link, but i tried many variations of the connect string. seems to be allright.
really stuck at this point. dont know why the error occurs
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.