C# with MySQL - Error: "Guid should contain 32 digits with 4 dashes" when trying to open the connection

Question

Im developed a software and it's now time to test it connection to a online server. Im developing in C# using Visual Studio and I'm trying to connect to a MySQL server. To be specifc Im trying to connect to a test server at db4free server. I changed my ConnectionString to:

connectionString = "SERVER=db4free.net;PORT=3306;DATABASE=prpsystem;UID=database;PWD=password;";

But when I try to open the connection to check if the login is OK the visual studio shows this message error:

Guid should contain 32 digits with 4 dashes.

Do you guys know what is happening? Thanks for the help.

Try to run `mysql check table` https://logicalread.com/check-repair-mysql-tables-mc13/#.W-RDmpNKhaQ — DanB, Nov 08 '18 at 14:09
Possible duplicate of [Guid should contain 32 digits with 4 dashes](https://stackoverflow.com/questions/11224493/guid-should-contain-32-digits-with-4-dashes) — Eray Balkanli, Nov 08 '18 at 19:03
@ErayBalkanli Not a duplicate of that question; see the call stack. — Bradley Grainger, Nov 08 '18 at 19:04

Bradley Grainger · Accepted Answer · 2019-07-13T15:47:51.797

0

Your crash is coming from Driver.LoadCharacterSets, which is executing SHOW COLLATION. This is bug 92982 that has been reported against the Connector/NET driver.

According to the OP on that case, he fixed the problem by disabling the skip-character-set-client-handshake setting in his my.cnf for MySQL Server. If you also have that setting, try disabling it to see if it resolves the problem.

Otherwise, you could switch to MySqlConnector, an alternate ADO.NET library for MySQL, which doesn't have this bug.

edited Jul 13 '19 at 15:47

answered Nov 08 '18 at 19:01

Bradley Grainger

27,458
4
91
108

1

It worked!!! Thank you soo much. The MySqlConnector from the NuGet Galeery works fine. – João Carlos Carvalho Pereira Nov 09 '18 at 10:40
2

I solved this issue with db4free and the MySql.Data nuget package by adding OldGuids=True; to the connection string – noontz Nov 09 '18 at 23:01
2

@noontz Just be aware that with `OldGuids=true`, any `BINARY(16)` column will be returned as a `Guid` rather than `byte[]`, which can be surprising behaviour. – Bradley Grainger Nov 09 '18 at 23:27
@BradleyGrainger Thx for the warning.. I had no idea about this. It was a try and error approach that lead me to the proposed fix – noontz Nov 09 '18 at 23:33

C# with MySQL - Error: "Guid should contain 32 digits with 4 dashes" when trying to open the connection

1 Answers1

Linked