Error on Old MySQL Database that I tried to Connect too

ServiceStack.OrmLite MySql
1

What is the oldest MySql version do you support?

I have this error when I try to connect to my database

MySql.Data.MySqlClient.MySqlException
HResult=0x80004005
Message=Unknown system variable 'lower_case_table_names’
Source=MySql.Data
StackTrace:
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at MySql.Data.MySqlClient.Driver.LoadServerProperties(MySqlConnection connection)
at MySql.Data.MySqlClient.Driver.Configure(MySqlConnection connection)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at ServiceStack.OrmLite.OrmLiteConnection.Open() in C:\BuildAgent\work\27e4cc16641be8c0\src\ServiceStack.OrmLite\OrmLiteConnection.cs:line 91
at ServiceStack.OrmLite.OrmLiteConnectionFactory.OpenDbConnection() in C:\BuildAgent\work\27e4cc16641be8c0\src\ServiceStack.OrmLite\OrmLiteConnectionFactory.cs:line 95
at MascomaConversion.Program.Main(String[] args) in C:\DEV\MascomaConversion\Program.cs:line 18

This exception was originally thrown at this call stack:
MySql.Data.MySqlClient.MySqlStream.ReadPacket()
MySql.Data.MySqlClient.NativeDriver.GetResult(ref int, ref long)
MySql.Data.MySqlClient.Driver.GetResult(int, ref int, ref long)
MySql.Data.MySqlClient.Driver.NextResult(int, bool)
MySql.Data.MySqlClient.MySqlDataReader.NextResult()
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(System.Data.CommandBehavior)
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
MySql.Data.MySqlClient.Driver.LoadServerProperties(MySql.Data.MySqlClient.MySqlConnection)
MySql.Data.MySqlClient.Driver.Configure(MySql.Data.MySqlClient.MySqlConnection)
MySql.Data.MySqlClient.MySqlConnection.Open()
…
[Call Stack Truncated]

2

You should at minimum use a version of MySQL that’s still supported by MySQL, the oldest of which is v5.6.

The lower_case_table_names variable isn’t used anywhere in OrmLite, maybe it’s in your my.ini MySQL configuration file?

3

I tried with nuget version 4.5.8 and I was able to connect with no change to the server (my.cnf)
Because we do a conversion from mySql to SqlServer I will isolate the conversion program.

So I will need the latest version to support both DB…

4

Then that’s an incompatibility with the MySQL ADO .NET Driver used, OrmLite.MySql v5.8 references Mysql.Data v8.0.18 whilst v4.5.8 uses the older MySql.Data (>= 6.9.9).