🚀 go-pugleaf

Thanks,

Got the ado method working.

I should of noted, later on, I wouldn't have a problem using the bde.

Here is are some additional questions:

Should I be using a ClientDataset in my datamodule?  Right now I connected
to the dataaware components from a standard dataset.  I really want to be
able to transition to something much larger (although, simultaneos users
will still be relatively small, worst case abouty 70, but realistically,
about 5).

that said, eventually I need to seamlessly migrate to SQL, MYSql, or
somehting better, well ,with little pain anyway.  On top of that I want to
eventually (once I learn) be able to have web application to view (and
potentially update) data, and the data will grow of course.  Right now it's
simple, but eventually, there will be more and more, somewhat realted data,
that ppl need to be able to view, and possibly update via the web, I am
assumig via some sort of web app, and sql queries.  again, not a db guy, so
if this all sounds off, let me know.

Ok, that said, I like this ado for what I need in the mediium-term.  what do
I need to do/know to set this up for a smooth, low-pain transition to the
bigger set of apps.  Or will those really be something entirely different.
I envision a small set of apps that eventually put this data into a db, or
set of dbs, and (potentially) pull data from other db's for the query
results, and a web app to view the differing data.  posting to/from a remote
db is really the concern for the transition.  As for the web app, I have no
idea, a decision cube seems nice, but for some reason I can't wrap my head
around it, and really has nothing to do with teh current (ap).

Can I just edit within my datamodule the datasource/dataset and pretty much
"poof" it works, assuming bde, or whatever is required in installed?

Anyway, sorry so long, lots of questions, and a windy way of attempting to
convey more of my twisted minds plans :D

Thanks again in advance.

Jay Walsh

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:41483bd5$1@newsgroups.borland.com...
> 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
> >
> >
>
>