I a pretty sure that I am getting close here. When the following code executes I receive an error message that it cannot convert nvarchar to datetime :

oConn.connectionstring = "provider=sqloledb;data source=sweetpea;Integrated Security=SSPI;database=memsales "
oConn.Open

If oConn.State = 1
oRs = oConn.Execute("sp_ndcusage_xml memno,ndcnum,sdate,edate")

The procedure has not changed it's parameters are
memno text
ndcnum text
sdate datetime
edate datetime

The text variables hold and xml value to be converted to a table. This work fine for the following code:

lcsql="exec sp_ndcusage_xml ?memno,?ndcnum,?sdate,?edate"
lnresult=SQLEXEC(hConn,lcsql,"testdata")

Where and how would I find what is going on and how to fix this data type screw up?

Thanks again
Kelly