Try adding "OPTION=3" to the connection string. What version of MySql? Try the latest released 5.x version if you can.

Carlos

>str1="Driver={MySQL ODBC 3.51 Driver};Server=x;Database=x;Uid=root;Pwd=123"
>nHandle=sqlstringconnect(str1)
>x=sqlexec(nHandle,'select * from testtable')
>
>I noticed that it takes one full second for just 200 records to be
>returned. for 20000 records it takes 100 seconds.
>The database server is not in a network so the delay is in the ODBC translation. Is this normal? Can sql passthrough not use odbc and use oledb drivers instead? i cant find the connection string to make connection to
>mysql faster..also numeric fields are returned as strings so i have to use
>val()..