Databases - DAO and ADO

Greetings.

Some weeks ago I asked a question about how I might handle a situation where
I would want to access price data (such as for stocks) based on the Year,
Month and Day. For example, I may wish to gather the price data for March 13
to 17 for the years 2001 to 2009 only.

In my original question, I was wondering if I should create a
multidimensional array where the indexes represented the month, day and
year, such as:

arrPrices(Year, Month, Day)

Which type would be a structure to hold the open, high, low, close values.

A couple programmers here suggested that I use a database instead and SQL to
query this database.

So with those recommendations in mind, I have spent the last few weeks
reading books on VB6 Database programming and skimming the web for
information on creating databases, etc. I'm confronted with choices that are
quite frankly confusing me.

For example, there is talk of using Jet, data controls, DAO or ADO, etc.
Because most of the books on VB6 are old now, mostly around the Windows
95/98 era, the reasons for using DAO over ADO back then may or may not apply
today with our faster systems, XP or higher, etc. etc.

So I'm wondering...

Should I be focusing my attention on learning ADO or DAO as my time is
limited to finishing this particular project I'm working on. The project is
purely a desktop application and the data would be on the desktop computer
as well in the form of Metastock data downloaded from a data service.

Much of one book I have deals with using Data Controls which I do not
believe applies to my needs. So that time is a waste.

Jet or ODBC? DAO or ADO? SQL?

While I wait for additional books to arrive (just bought VB6 Database for
Dummies and SQL in less than 500 Years type books), I was wondering what
your thoughts may be in this regard.

Thank you in advance. :-)

Webbiz



.

Relevant Pages

  • Re: Knowledge Base Help Not working
    ... Database is a DAO object. ... both Access 2000 and 2002 use ADO. ... Microsoft DAO 3.6 Object Library, ... For example, to ensure that you get a DAO recordset, you'll need to ...
    (microsoft.public.access.formscoding)
  • Re: ADO and the Find method
    ... You cannot compare DAO and ADO. ... database, which has OLEDB provider. ... >>>> Opening of the whole table was not a good design anytime. ...
    (microsoft.public.vb.database.ado)
  • Re: Crosstab query error 3104
    ... Thankfully very few compile errors had to ... I have both DAO & ADO references checked but DAO is higher so it is taking ... Thanks - I inherited the original database & am gradually working through ... then perhaps you've removed the reference to ADO. ...
    (microsoft.public.access.queries)
  • Re: How do I use ADO in VC++ 6.0 to get the columns names of the t
    ... you're using DAO rather than ADO ... (ActiveX Database Objects). ... robust library for working with Jet databases. ...
    (microsoft.public.data.ado)
  • Re: Database variable change from 97 to 2003
    ... Access 2003 has references set to both DAO ... and ADO and, perhaps unfortunately, the ADO reference is set higher in ... use Dim rcd As ADODB.Recordset) ... > modules, however, I get errors on the database variable ...
    (microsoft.public.access.modulesdaovba)
Loading