We want to generate indexes on a table on the MySQL server (latest version).

The SQL command we give in the task is:

ALTER TABLE `article` ADD INDEX ( `Itemcode` );
ALTER TABLE `article` ADD INDEX ( `AssortmentID` );

When we run the task like this we get an error 42000. When we use only one of the above rules the task works fine.
Both rules work fine in the phpmyadmin console of the mysql server.

Does anyone has an idea what the problem could be?

Thanks in advance.

Erik

1. Could you paste the full error (verbose message)?
2. what kind of connection to you use (ODBC,MySQL Direct or OLEDB)?

---

Henrik,

Thanks for your reply.

I've made an export ot the log. This is the whole error:

Error in task sql: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.41]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 'ALTER TABLE `artikel` ADD INDEX ( `AssortimentID` );
ALTER TABLE `artikel` ADD I' at line 2

As you can see we use the ODBC 5.1 driver. The MySql server is on the localhost.

Hope to hear from you soon.

Erik

Thanks,

could you try connecting using MySQL Direct to see if that works? MySQL Direct is much faster.

---

This is the solution! Thanks.

Erik

Thanks for the update. I guess ODBC is limited in sending many commands at once. At least in the VisualCron implementation of it.

---