Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Timeout in a Bulk Load application
Message
Information générale
Forum:
ASP.NET
Catégorie:
Formulaires
Titre:
Timeout in a Bulk Load application
Divers
Thread ID:
01201087
Message ID:
01201087
Vues:
71
I have an SP that takes approximately 35 min. to complete.

My catch of the error:
ex.Message "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

Here is the app config setting:
add name="RadDev" connectionString="server=MyServer;Initial Catalog=db_Iris; Integrated Security=SSPI;Connect Timeout=42000"/

My timeout error only takes 30 seconds.

The call for the command:
' Setup sql command
Try
lConn.Open()
With lCmd
.Connection = lConn
.CommandType = CommandType.StoredProcedure
.CommandText = "usp_System_LoadIncidents"

End With

lCmd.ExecuteNonQuery()

Any ideas?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform