🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4585

How to connect MySQL database by ADO and MyODBC

#4585
From: Liu Haizhou
Date: Fri, 07 Dec 2001 10:25
20 lines
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!dnews

Show 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