>>>Nomi:when i use dsn, all CA are present in DS. but when i use connection handle:
>>>goge=SQLSTRINGCONNECT("Driver={MySQL ODBC 5.1 Driver};Server=localhost;charset=UTF8;Database=school;User=root; Password=;Option=3;")
>>>my problem is same:is string is true
>>>my
>>
>>Looks OK from the quick glance. Did you try to verify at www.connectionstrings.com ?
>>
>>To test CA in command window:
>>
>>loCA = createobject('myCAClass')
>>loCA.CursorFill()
>String is true. but not working

Sorry :(

Try

create a text file with udl extension. Then double click on this file. Then connect to MySQL. The connection string will be saved in this file.