I set the Microsoft OLE DB Provider for ODBC Drivers and MySql as database, also the windows ODBC Data Sources have setted correctly. In appendix(1), you can see that i can test succeesfully. Then i click the ok, a dialog pop up and failed to create table in appendix(2). I also use the sql server with offical example to test, of course it's no problem. 

notes：Provider=MSDASQL.1;Password=admin;Persist Security Info=True;User ID=root;Data Source=LocalSqll;Extended Properties="DSN=LocalSqll;UID=root;PWD=admin;";Initial Catalog=archive