Article View: borland.public.cppbuilder.database.ado
Article #4585How to connect MySQL database by ADO and MyODBC
From: Liu Haizhou
Date: Fri, 07 Dec 2001 10:25
Date: Fri, 07 Dec 2001 10:25
20 lines
1580 bytes
1580 bytes
Hi! I want to access MySQL database via MyODBC and ADO components. I've setuped the ODBC as MyODBC required, i.e., checked the "Don't optimize column widths" and "Return matching rows" options. But I faced a very strange question: C++ Builder cannot identify the MySQL's varchar field type. I wanted to add fixed fields to the ADOTable or ADOQuery component. So I chose "Add all fields", some VARCHAR fields were distinguished as "TStringField", at the same time, the other were "TMEMOField". All of these occured in the same table. I've tried many times, but these didn't changed. I really don't know why. I've updated C++Builder to update pack1 and ADOUpdate1. And I aslo installed MSDAO2.6 and MyODBC2.50.39. But these still happen. Can anyone help me? Thank you very much!
Technical Details
Message-ID:
<MPG.167b19d79996fab1989680@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,e0991f248ed587e2,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-12-07 02:30:30 PST From: Liu Haizhou <zeroliu@163.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: How to connect MySQL database by ADO and MyODBC Date: Fri, 7 Dec 2001 18:25:01 +0800 Message-ID: <MPG.167b19d79996fab1989680@newsgroups.borland.com> Organization: whiov X-Newsreader: MicroPlanet Gravity v2.30 NNTP-Posting-Host: 159.226.126.60 X-Trace: dnews 1007720638 159.226.126.60 (7 Dec 2001 02:23:58 -0800) Lines: 20 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews