Error message

Hello,

getting error message when trying to load data from local infile.

BUT ONLY when comment stands in front of query. If there is no comment, loadig data is working.

With comment before query, loading data doesn't work. Strange.

Example:

NOT WORKING:

WORKING:

Updated today to version 10.3.0.5771 (64Bit)

Cheers

Very odd. The server rejects it when there's a comment right before it?

Are you sure the second one imported the data from your csv file?

However, it could be I have to activate the MYSQL_OPT_LOCAL_INFILE option in HeidiSQL's connection handler for getting that running.

Could you please report the server version you are running there?

Yes, I am sure.

Query with comment in front is working fine on other machine with older version of HeidiSQL (Version 10.1.0.5464). On my lokal machine (with "Bug") I am running HeidiSQL with Version 10.3.0.5771. Yesterday I updated my lokal client to this version. Before this update Query with comment in front was working fine.

Both clients connecting to same SQL-Server (Version 5.6.20).

Ok, you did not mention before you were using different HeidiSQL versions. In that case it's likely the updated library which causes the error.

In the v10.3, you have a "Library" dropdown on the session manager. Please post what you have selected there. And try the alternatives there.

OK. I've got results:

Per default (I guess so) library libmariadb.dll was selected.

Tested with libmysql.dll -> no error message

Tested with libmysql-6.1.dll -> no error message

Tested with libmariadb.dll -> error message occurs

You are right: Changing the library solves this issue. So for me it's OK now.

Thank you very much for your help. Great!!!