ADO is just an access layer between the client and the database server. In
the example I gave, the ADO is using ODBC. MySQL also supports an OLEDB
driver, which will most likely be more efficient than the ODBC driver, and
more flexible

As for you error, just try

oRS.Open sSQL, oConn

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"bwreath " wrote in message
...
thanks for the replies.

I will tidy up the sql statement but first I want
to make a successful connection with ADO
I copied and pasted the code and
got an automation error, unspecified error -2147467259(80004005).
I have narrowed it down to the line
oRS.Open sSQL, oConn, adOpenStatic, adLockOptimistic
which seems to be causing the error?

I would like to what the disadvantages and advantages
are between using ODBC and ADO. It's not really clear to me
if you use one or the other or if ADO is used in conjunction
with ODBC.

Also, I would like to know if there are some references with
use ADO and mysql.

thanks very much.


---
Message posted from http://www.ExcelForum.com/