SQLServer 2000 looks for a date to be passed in as a string. You define the parameter as a datetime in the stored procedure but in your VB
code you need to pass it as a string.
strSQL =" Select * from Orders Where OrderDate >= " + "' mm/dd/yyyy + '"
you can specify the date in any acceptable format yyyy/dd/mm ... etc .. . but it must be a string.