I see. Have you confirmed connectionstring setting is right and if in production IIS APS.Net configuration is right? It works for me. My suspicion is that you're connecting to another dbc in fact (no error, right?).
Cetin
>Aside from my typing error in the message in UT, all code works.
>
>In fact the code worked on another computer and on about 10 customer computers. I am testing this program on my PC after upgrading the ASP.NET part to the .NET 2.0. This is where I came across the problems.
>
>>Dmitry,
>>And this code really work from within VFP?
>>Cetin
>>
>>>No error message. The code in Stored Procedure is very simple:
>>>
>>>
>>>user ("DataFolder" + "mytable") in 0 alias MYTABLE
>>>append blank in MYTABLE
>>>replace myfield with "ABC" in MYTABLE
>>>
>>>
>>>But no record gets inserted to the MYTABLE.
>>>
>>>>Any errors? Could you post your code?
>>>>
>>>>
>>>>
>>>>
>>>>>I am having problem where the VFP Stored Procedure (called from .NET application) does not update .DBF tables. I inserted a test code in the Stored Procedure that creates a TEST table and inserts dummy value, and that part works. But none of the application tables are updated.
>>>>>
>>>>>The version of VFP Ole DB driver used for .NET application to call store procedure is 9.0.00.3504.
>>>>>
>>>>>I have been running all kind of tests but to no avail.
>>>>>
>>>>>Any suggestions of what I can do to pinpoint the cause of the problem?
>>>>>
>>>>>Any suggestions would be appreciated.