>>>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.
If it's not broken, fix it until it is.
My Blog