Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SqlCommand.CommandTimeout
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
00924349
Message ID:
00924416
Vues:
19
Mat,
Did you check to see if you can run the same command in Query analyzer and see if it timesout there?

If it times out there maybe your server setting is timing you out not MM.
the Connection.Timeout feature is in the mmDataAccess object if i recall.
I think you have to override the facory object, and then add your settings to it.
I am doing this from memory, i will check later tonight in the help file and framework...i did see something like this but can't remember where.

HTH
--Shawn

>Shawn,
>
>Thank you for the reply, but I don't think this is the problem I am encountering. I had tried changing this in my app.config file, but it did not help. I could be wrong, but I don't think this setting applies to the individual queries. It looks like SqlCommand.CommandTimeout is the property I need to change, I am just not sure how.
>
>Kind Regards,
>
>Mat
>
>
>>Hi Mat,
>>
>>Right from the MM help file... :-)
>>
>>You can specify the timeout value of a SQL connection within the connection string. For example, you could put the following in your application configuration file:
>>
>><add key="maindata\Connection" value="server=(local);Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Connection Timeout=30" />
>>
>>You can also access this setting by means of the ConnectionTimeout property of the connection object.
>>
>>--Shawn
Shawn Dorion
Geo Sektor Dot Com
Website: http://www.geosektor.com

Web Hosting Plans
Visit : http://WebHosting.Applications4u.com/
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform