Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Who really uses the VFPOleDB.1 provider?
Message
De
06/10/2006 05:43:49
 
 
À
05/10/2006 23:13:37
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01158763
Message ID:
01159970
Vues:
26
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform