Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pass a web variable to a stored procedure
Message
From
24/10/2008 17:28:14
 
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
01257541
Message ID:
01357088
Views:
32
>>clip . . .
>>
>>
>>Hi Viv
>>You once showed me how to execute a stored procedure from ASP. Can you show me how to do it from VB NET? I have
>>
>>Dim oConnVFP As New Data.OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings("VFPLibrary").ConnectionString)
>>Dim objCommandCSV As New System.Data.OleDb.OleDbCommand("do createCSV", oConnVFP)
>>
>>objCommandCSV.CommandType = Data.CommandType.StoredProcedure
>>
>>oConnVFP.Open()
>>objCommandCSV.ExecuteNonQuery()
>>oConnVFP.Close()
>>
>>But this doesn't work. Thanks
>
>Just use the name of your SP instead of DO mySp and it should work. At least this is how it works for SQL Server.

I had already tried that and it didn't work, but I found the problem. Apparently the output features of VFP are not available to the OLE driver. If I strip them out of the SP then it works OK, but since my purpose was to create a CSV file I may be out of luck with this simple approach.
Previous
Reply
Map
View

Click here to load this message in the networking platform