i am trying bulk insert activity for mysql db in UiPath.but getting following error.plz help.
The provided driver version does not support Bulk Insert operations. Please check the driver.
Bulk insert: ERROR  [MySQL][ODBC 8.0(a) Driver][mysqld-5.7.36]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DEFAULT VALUES’ at line 1
for bulk insert to work properly …first your drivers should be supporting bulk activities
then all the data type and the column names should be exactly matching…any deviation will fail the insert…first try with one single line and then increment the data
all column name are matching with each other.how to check drivers?
Data types are also matching?
Try changing the deivers by changing providers
This is pretty straightforward. Your MySQL driver doesn’t support Bulk Insert.
You can see if you have the latest version of the MySQL driver and upgrade if necessary. Or you can switch to looping and inserting one row at a time.
currently i am inserting single row but it is taking too much time…can any one tell me which version of mysql support bulk activity?
Try woth odbc drivers they generally support bulk insert