Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pass a web variable to a stored procedure
Message
De
24/10/2008 17:28:14
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
01257541
Message ID:
01357088
Vues:
31
>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform