Querydef migration

[Venanzo Teatini]

With DAO i've this querydef :

insert into [odbc;DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.5.129;PORT=3306;DATABASE=gestris;
USER=user;PASSWORD=abc;OPTION=3;].[Macchine] select * from macchine

It work fine and i've no problem (work in VISDATA utility too).

Now i wont to do the same whit ADO

i think that this is the right way :

My_Connection.Execute "insert into [odbc;DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.5.129;PORT=3306;DATABASE=gestris;
USER=user;PASSWORD=abc;OPTION=3;].[Macchine] select * from macchine"

i obtain this error :

-2147467259 ODBC: connessione a '{MySQL ODBC 3.51 Driver}192.168.5.129' non riuscita.

The my_connection is a connection on my local access db.