I am facing below error while insert a table into for your info i am uploading excel data into data table from the data table ,after this writing datatable into MYSQL database. Facing above error while uploading into sql table ? [image]

Hi @nabisab.18 I feel like this is purely due to compatibility issue Have a view on this knowledge base from UiPath team [image] Database Insert Activity Is Failing Knowledge Base Why error [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.23] is thrown. You have an error …

Insert: ERROR [: MySQL][ODBC 8.1(a) Driver][mysqld-8.1.0]You have an error elena na that corresponds to your MySQL server version for the right syntax to use near DEFAULT VALUES’ at line 1

Help Activities

Palaniyappan (Forum Leader) September 15, 2023, 5:57am 7

Hi @nabisab.18
I feel like this is purely due to compatibility issue
Have a view on this knowledge base from UiPath team

Cheers

Topic		Replies	Views
Insert DB activity throw an error Studio datatable , database , studio , question , activities_panel , read-range , mysql	3	588	October 15, 2023
Database Insert Activity Is Failing Knowledge Base activities	0	1079	March 1, 2022
Read Range - INSERT db Error Unexplained Studio datatable , excel , database , activities , studio	7	1784	December 14, 2021
Getting error while connecting to mysql database from UI path Studio uiautomation	3	185	December 30, 2023
UIPATH mariaDB Insert 오류 Korea RPA 개발자를 위한 공간 uipath-database-activities , sql-database	8	519	November 22, 2023

Most Active Users - Yesterday
Anil_G
mukesh.singh
postwick
anjani_priya
Anelisa_Bolosha1
More details...

Insert: ERROR [: MySQL][ODBC 8.1(a) Driver][mysqld-8.1.0]You have an error elena na that corresponds to your MySQL server version for the right syntax to use near DEFAULT VALUES’ at line 1

Related Topics