Eric,
I'm not sure, but I would venture a guess that SQLServer isn't receiving the date string in a format it can do something with.
So here's an alternative: make your stored proc parameter a datetime (drop the convert), and call your proc by like this:
GetEvents '20011023'
. Note that if you always send a date as YYYYMMDD, SQLServer will always understand. (The single quotes are important)
HTH!
>Here is the code I use to execute it...
>
>strQuery = "GetEvents '" & srcDate & "'"
>Set objEventsRS = objEventsConn.execute(strQuery, ,adCmdStoredProc)
Sylvain Demers