>>>>> Dim oConnVFP As New Data.OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings("VFPLibrary").ConnectionString) >>>>> Dim strCSV As String = "do createcsv" >>>>> Dim objCommandCSV As New System.Data.OleDb.OleDbCommand(strCSV, oConnVFP) >>>>> >>>>> oConnVFP.Open() >>>>> objCommandCSV.ExecuteNonQuery() >>>>> oConnVFP.Close()>>>>>but its not quite right.
>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 I am still getting an error. Here is the SP
>function CreateCSV() > >use c:\inetpub\wwwroot\aspxtest\app_data\library3 shared >set safety off >copy to c:\inetpub\wwwroot\aspxtest\app_data\PAGLibrary type csv >set safety on >use >endfuncHow about something like this:
'set some string variable to hold this: ' EXECSCRIPT([use c:\inetpub\wwwroot\aspxtest\app_data\library3 shared]+CHR(13)+CHR(10)+ ' [set safety off]+CHR(13)+CHR(10)+ ' [copy to c:\inetpub\wwwroot\aspxtest\app_data\PAGLibrary type csv]+CHR(13)+CHR(10)+ ' [set safety on]) 'Then use use Dim objCommandCSV As New System.Data.OleDb.OleDbCommand(That String, oConnVFP) objCommandCSV.ExecuteNonQuery()