Jeff
Mon Mar 28 17:05:49 CST 2005
Could it be because the two commands are sent separately?
That said, I'm not sure how to send them simultaneously, as two commands via
a single OleDbCommand object.
"Greg" <Greg@discussions.microsoft.com> wrote in message
news:72A4939A-51BE-448D-A9E2-5DDCC9DF14B1@microsoft.com...
> Jeff,
>
> I have tried the full path and it still errored out. I am aware of the
> topic you refer to. However, Append Procedures is supported in the Ole Db
> Provider. When I try to use something that is not supported, it comes
> back
> with a "Feature Not Available" error which is different from the error
> message I get when attemping the Append Procedures.
>
> But I appreciate your input.
>
> "Jeff Bowman" wrote:
>
>> Hi Greg, try providing the full path to the file. If this is ASP.NET,
>> which
>> is likely, the process executes in the WinSys folder and so won't be able
>> to
>> find your file.
>>
>> Also FYI, from this topic:
>>
>>
>>
http://msdn.microsoft.com/library/en-us/dv_foxhelp9/html/28f5cb8c-bf23-4d4f-bdc8-5ba2a8fd6219.asp
>>
>> APPEND PROCEDURES is not available in a distributed executable file. If
>> your
>> application uses this command, it will generate the error, "Feature is
>> not
>> available." For more information about restricted and distributable
>> Visual
>> FoxPro files, see Distributable and Restricted Visual FoxPro Features and
>> Files
>>
>> I don't know whether this might be the cause of your error.
>>
>>
>>
>> "Greg" <Greg@discussions.microsoft.com> wrote in message
>> news:FF3B64EC-3979-4C1C-8D43-555FE0EF8A93@microsoft.com...
>> >I have this c# code which is attemping to run a VFP command via the Ole
>> >Db
>> > Provider. It should work, but always errors out with a vague messae
>> > that
>> > there was an error in processing the command. I have verified the the
>> > path
>> > to the file is correct (it is in the same directory as the DBC) and it
>> > works
>> > from the command window in VFP. All I am trying to do is update the
>> > stored
>> > procedures of the database. The Append Procedures command is supported
>> > in
>> > the
>> > Provider, so it not that, but I can't get this to work.
>> >
>> > OleDbCommand oCommand1 = new OleDbCommand("OPEN DATABASE
>> > LEADS",this.oOleDbConnection);
>> > OleDbCommand oCommand2 = new OleDbCommand("APPEND PROCEDURES FROM
>> > NEWPROCS.TXT OVERWRITE",this.oOleDbConnection);
>> > this.oOleDbConnection.Open();
>> > oCommand1.ExecuteNonQuery();
>> > oCommand2.ExecuteNonQuery();
>> > --
>> > Greg Gum
>>
>>
>>