Re: Databases - DAO and ADO

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Cor.
:-)

Webbiz


"Cor Ligthert[MVP]" <Notmyfirstname@xxxxxxxxx> wrote in message
news:OvbyW8%23uJHA.248@xxxxxxxxxxxxxxxxxxxxxxx
Webbiz,

I surely would go in your situation for Ado recordset and try to use
simply a freeware SQL Server Express

Around the Ado recordset is still pretty much documentation, DAO is fast
but the documentation on Internet is poor.

http://msdn.microsoft.com/en-us/library/aa905900(SQL.80).aspx

Have a look at this one to and use SQL Server Express like the Jet
databasefile (Jet=What is called often Access)

http://www.connectionstrings.com/

Cor


"Webbiz" <nospam@xxxxxxxxxxxxxxx> wrote in message
news:S9wEl.31387$%e2.10019@xxxxxxxxxxxxxxx
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

  • Databases - DAO and ADO
    ... A couple programmers here suggested that I use a database instead and SQL to ... For example, there is talk of using Jet, data controls, DAO or ADO, etc. ... Because most of the books on VB6 are old now, ...
    (microsoft.public.vb.general.discussion)
  • Re: Crosstab REPORT, not query
    ... you can use the 'Database Tuning Advisor' against the SQL ... other books on ADP? ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server in SBS2000
    ... There are a couple of other "For Dummies" books on MS SQL. ... SQL is just the database backend. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Creating tables
    ... Frederico has recommended you to replace the solution with an ADO one. ... DAO is "Data Access Objects". ... direct interface to the database engine and it is being implemented in open ... SQL Server with stored procedures and triggers, ...
    (comp.lang.cobol)
  • Re: Databases - DAO and ADO
    ... I surely would go in your situation for Ado recordset and try to use simply a freeware SQL Server Express ... Around the Ado recordset is still pretty much documentation, DAO is fast but the documentation on Internet is poor. ... 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. ...
    (microsoft.public.vb.general.discussion)