Asynchronous ADO

[boggg1]

I'm part way through converting my asynchronous DAO's to ADO's and I cannot get the asynchronous part of the ADO to work...

This line works...
rstHistory.Open SQL1_, conPRS, adOpenStatic, adLockReadOnly

But this one does not...
rstHistory.Open SQL1_, conPRS, adOpenStatic, adLockReadOnly, adAsyncExecute

Here is the error...

Error Number: 0
IM002:[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified
Error Source: ODBC.Workspace

SQL1_ is valid SQL, conPRS is a valid connection (otherwise the synchronous query would not work).

In the past I have found the Oracle drivers to be better so I am using: Oracle ODBC Driver
The only reference I am using is: Microsoft ActiveX Data Objects 2,5 Library
I have Windows 2000 reading Oracle 8i data.

Note that asynchronous queries worked with DAO so I guess this is an ADO problem not a database problem.

Any ideas where to look ?

Boggg1