Greeting,

I am having problems calling a VFP7 stored procedure from ADO.

The error I am getting from the browser when I execute the ASP page is:

Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/edsi/Asp Pages/BuyerReceptor_new.asp, line 64

The ASP code is:

Set oConn = Server.CreateObject("ADODB.connection") 

oConn.Open "Provider=vfpoledb;" & _ 
         "Data Source=C:\EDSDATA\edsdata.dbc;" & _ 
         "Mode=ReadWrite|Share Deny None;" & _ 
        "Collating Sequence=MACHINE;" & _ 
       "Password=''" 

Set cmdTemp = Server.CreateObject("ADODB.Command") 
Set rsPDFs = Server.CreateObject("ADODB.Recordset") 

cmdTemp.CommandType = adCmdStoredProc
cmdTemp.CommandText = "sp_GetBuyerSeller('1-01240,'Jones','B')"
Set cmdTemp.ActiveConnection = oConn 
rsPDFs.CacheSize = 10 

Line 64, where the error occurs, is the line:

cmdTemp.CommandType = adCmdStoredProc

I found an article in Microsoft support area which seems to indicate that passing parameters as in my CommandText line above should work.

Here is the url of the article:

http://download.microsoft.com/download/4/3/f/43fbe7c7-81ae-4a0e-acc1-8532a99c5d2d/VFP8_OLEDBProvider_Readme.doc

Any help will be greatly appreciated.

Thanks,

-Steve