
passing optional parameters to the parameters collection
The provider is simply passing your parameters in order, so they're seen as
#1, #2, and #3. You'll need to create that 3rd parameter also in the
collection, even if you want its default value to be used and don't intend
to supply one, for the last parameter to be treated as #4.
MDAC 2.6 now also supports Named Parameters, please see Bill Vaughn's
article
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsq...
html/NamedParameters.asp.