Just updated MySQL to 4.1.8 and MyDAC to 3.30 and now I can't access a tinyint(1) field using
TMyQuery1->FieldByName("XYZ")->AsInteger
Using BCB5.
Also, the connection process now takes several seconds instead of the old 1 second or so. Why so slow now?
Thanks,
InfoSight
Cant retrieve tinyint(1) with AsInteger
Re: Cant retrieve tinyint(1) with AsInteger
Since MyDAC 3.10.1.7 TinyInt(1) fields are represented as TBooleanField. To solve problems declare these fields as TinyInt(4) or set TCustomMyDataSet.Options.EnableBoolean := False
> Also, the connection process now takes several seconds instead of the old 1
> second or so. Why so slow now?
Does this time depends on MyConnection.Options.Direct property?
> Also, the connection process now takes several seconds instead of the old 1
> second or so. Why so slow now?
Does this time depends on MyConnection.Options.Direct property?
Thanks for the info on boolean type. Using AsBoolean fixed the problem.
Regarding the long connection time, yes it is the same regardless of the setting of the Direct property. However, when Direct is False, after the delay I get an error:
"Client does not support authentication protocol requested by server; consider upgrading MySQL client."
Options->Protocol is set to mPDefault.
Thanks,
InfoSight
Regarding the long connection time, yes it is the same regardless of the setting of the Direct property. However, when Direct is False, after the delay I get an error:
"Client does not support authentication protocol requested by server; consider upgrading MySQL client."
Options->Protocol is set to mPDefault.
Thanks,
InfoSight
> Regarding the long connection time, yes it is the same
> regardless of the setting of the Direct property. However,
> when Direct is False, after the delay I get an error:
> "Client does not support authentication protocol requested by server; consider upgrading MySQL client."
You should update libmysql.dll to actual version.
> regardless of the setting of the Direct property. However,
> when Direct is False, after the delay I get an error:
> "Client does not support authentication protocol requested by server; consider upgrading MySQL client."
You should update libmysql.dll to actual version.