Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who really uses the VFPOleDB.1 provider?
Message
From
06/10/2006 05:43:49
 
 
To
05/10/2006 23:13:37
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01158763
Message ID:
01159970
Views:
25
>>General Structure should be:
>>
>>*VFP Stored Procedure:
>>PROCEDURE DoSomething
>>  LPARAMETERS x
>>  SELECT * FROM myTable WHERE something = x INTO CURSOR myCursor
>>  RETURN SETRESULTSET("myCursor")
>>ENDPROC
>>
and in VB.NET something like:
>>...
>>With oCommand
>>  .CommandType = CommandType.StoredProcedure
>>  .CommandText = "DoSomething"
>>  '.Parameters.Add .....
>>End With
>>da.SelectCommand = oCommand
>>da.Fill(oDataSet)
>
>With the store procedure, I end up with the same result. I got an error after a few hundreds of transactions which is the same type of error I got before.

Oh well. The only upside is that since the errors occur using a SPROC you have to ability to add some logging from within the VFP proc itself.

Just to confirm: these errors are occurring when just running the basic aspx with a query returning a dataset? No framework, no other code in the global.asax ?

Regards,
Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform