I found the problem. I didn't know you can't pass adDate datatype as parameter for sp. I have to use adDBTimeStamp instead. It's under M$ knowledge base.
As far as the driver, yes I'm using ODBC instead of OLEDB right now. I'm having problems connecting to MSSQL using OLEDB and I don't know enough about it to figure it out. I get the error message:
"Not associated with trusted SQL Server connection" error. I have MSSQL setup to use Windows NT authentication (not MSSQL or mixed mode) and MSSQL is setup in my own computer and connected to our network. I had same problem with 2 notebooks with MSSQL installed that does the same thing. Only way around it was to use MSSQL authentication and create a user account in MSSQL.
>Based on the error message you got I would say that you are using OLE DB provider for ODBC instead of OLE DB provider for SQL Server.
>What connection string gstrConnectString looks like?
It's "my" world. You're just living in it.