| View previous topic :: View next topic |
| Author |
Message |
GlennDJones@hotmail.com
Guest
|
 Posted: Fri May 13, 2005 1:18 am Post subject: Delphi 5 to mySQL ODBC |
 |
|
I am trying to access mySQL via ODBC - this bit is sucessful. If I
create a BDE alias and access the tables via the standard TQuery my
VARCHAR fields are returned as strings (i.e. the Field Defs are
TStringField).
If I use TADOConnection and TADOQuery and connect directly to the ODBC
configuration (bypassing BDE) my VARCHAR fields are returns as memo
fields (TMemoField).
I assume there is a noticable performance hit in using BDE to get to
ODBC - does anyone disagree?
Does anyone know how to 'fix' the problem with mismatch field types? I
have applied the Delphi 5 ADO Update 2 patch.
Thanks in advance
G
|
|
| Back to top |
|
 |
ramu
Guest
|
| Posted: Thu May 19, 2005 4:38 am Post subject: Re: Delphi 5 to mySQL ODBC |
|
|
| Quote: | I assume there is a noticable performance hit in using BDE to get to
ODBC - does anyone disagree?
Yes there is lots of performace issue with BDE. |
Which type you want to have Memo or String. ?
Depending on that u can change the field type in the query field
editor.
Hope this helps you
Regards
Rams.
|
|
| Back to top |
|
|
GlennDJones@hotmail.com
Guest
|
| Posted: Sat May 21, 2005 10:28 pm Post subject: Re: Delphi 5 to mySQL ODBC |
|
|
I want a String back (the field is only 14 characters long). I've
tried changing the field type but get the same error. Thanks for the
suggestions.
Glenn
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
