>this message eppears 'Alias not found

You get "Alias not found" because the cursor has not been created, because there was an ODBC error returned from MySQL.
You have not answered Yuri's question on what does AERROR() return. This function will populate an array with the ODBC error.

You could also try to using SQL Pas-Trhough (SPT) one you establish the connection and see what you get in return ( or what error with AERROR() ). Run your query wiith SQLEXEC().

Another - unrelated - problem I see in your example is that you are using the root account with no password. That is a major security hole. You should never use the root account on a database server (or any server) for routine work. Root (admin) is only for administrative maintenance. Furthermore you should never have an unprotected root account. Always issue a password if you value your data.