mostly whine ADO & DAO and ODBC

[Guest]

Can anyone explain why the ODBCtimeout property only exists for the QueryDef
object in DAO..... and why QueryDef is DAO only?

Okay... so it's more of a general whine... programming is hard enough when
you have one set of rules... but this ADO and DAO thing is truly driving me
mad. I've tried to only use ADO, but I just can't.... Should I have even
tried?

Thanks for the forum

Karrie

 

[Brendan Reynolds]

In my opinion, the answer to your final question would be no. In an MDB,
there is no reason to go out of your way to avoid using DAO.

 

[Tom Wickerath]

Hi Karrie,

Here is an article posted by Michael Kaplan nearly 5 years ago, which I assume is still current:

What does DAO have that ADO/ADOx/JRO do not have (and might never have!)
http://www.trigeminal.com/usenet/usenet025.asp?1033

Should I have even tried?

Not if you are just hitting data in a JET database, in my opinion.

Sorry, I don't know the answer to your first question.


Tom
__________________________________


Can anyone explain why the ODBCtimeout property only exists for the QueryDef
object in DAO..... and why QueryDef is DAO only?

Okay... so it's more of a general whine... programming is hard enough when
you have one set of rules... but this ADO and DAO thing is truly driving me
mad. I've tried to only use ADO, but I just can't.... Should I have even
tried?

Thanks for the forum

Karrie

 

[Roger Carlson]

I agree with others about using DAO in an Access-only solution. I use it
almost exclusively. Still, there is value in learning new things and if you
are ever called to hit some other engine or program in VB.NET or some such,
knowing ADO is valuable.

Since ADO uses OLEDB and not ODBC, I assume that's why there is no
ODBCtimeout property.

As to why there is no querydef object, I can only respond: "Because whoever
created ADO didn't want to use QueryDef." However, while there is no
QueryDef object, there IS a Catalog object and a Command object that can be
used to create a stored query (actually a View).

There is a nice little Microsoft whitepaper called: "Migrating from DAO to
ADO" which shows the ADO equivalent to many DAO operations. You can
download it direct from Microsoft. I also have a copy on my site here:
http://www.rogersaccesslibrary.com/knowledge.html

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L