Article View: borland.public.cppbuilder.database.ado
Article #1194Re: MSacces, mysql, how to question.
From: Viatcheslav V. Vassiliev
Date: Wed, 15 Sep 2004 12:55
Date: Wed, 15 Sep 2004 12:55
45 lines
2701 bytes
2701 bytes
ADO is good way and does not need BDE. However there is only one OLEDB provider for MySQL and as I know it does not work good with newest releases of MySQL. For MS SQL Server, MS Access ADO is OK. For flat file you will need OLEDB provider (or use MS Jet (it is the same as MS Access) that could work with text files, as well as Excel files). //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "Jay Walsh" <yoheeb@yahooREMOVE_THE_ANTIBOT_PART_HERE.com> �������/�������� � �������� ���������: news:41479c1d$1@newsgroups.borland.com... > Hi all, > > I am making a simple app that stores basic data (eventually might need to > store an image) that, from the start will be reading the data from access, > or even a flat file. And eventually will need to work on MySql, and/or SQL, > or some other more advanced db system. It could eventually be a remote > system. > > would hte ADO components be the way to go? also, will this, or any mehtod > work without installing the BDE? at first I would "like" to just put it on > a cd and go, in read only mode for feasibility testing. Anyway, what is the > best method given my requirements and goals? Finally, can anyone walk me > though it, I don't normally do DB development with BCB, have been out of dev > for about 3 years, and bcb has changed quite a bit. I am using 6 enterprise > now. It would be access2000 > > Thanks and ALL help apreciated, even if it seems "simple" assume I am a > poorly trained monkey when it comes to db dev. > > Thanks, > > Jay > >
Technical Details
Message-ID:
<41483bd5$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<41479c1d$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,e5cd53eee31b3ab X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <41479c1d$1@newsgroups.borland.com> Subject: Re: MSacces, mysql, how to question. Date: Wed, 15 Sep 2004 16:55:50 +0400 Lines: 47 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 213.234.218.42 Message-ID: <41483bd5$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1095252949 213.234.218.42 (15 Sep 2004 05:55:49 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail