MySQL Forums
Forum List  »  Connector/ODBC

You have an error in your SQL syntax; check the manual that corresponds
Posted by: Anthony GA
Date: June 01, 2023 02:52AM

I am having great trouble creating a data pipeline using MySQL connector 8 with SSIS. I can view the tables, but it gives me this error: "TITLE: Microsoft Visual Studio ------------------------------

ERROR [42000] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"sample_table"' at line 1 Error at Data Flow Task [ADO NET Source [16]]: System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [ma-3.1.18][10.4.24-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"sample_table"' at line 1 at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.ReinitializeMetaData() at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostReinitializeMetaData(IDTSManagedComponentWrapper100 wrapper)

I am getting this error when Im using MySQL SQL specific, its the same issue with Mariadb although i use SQL specific to the db.

Options: ReplyQuote


Subject
Written By
Posted
You have an error in your SQL syntax; check the manual that corresponds
June 01, 2023 02:52AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.