Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Stored Procs and ADO - wassup?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00994113
Message ID:
00994116
Views:
13
You may want to try the latest VFP OLE DB provider http://support.microsoft.com/default.aspx?scid=894012

>
>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
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform