Transaction problem

[Nassos]

Hi All,
I have a connection to an SQL dataBase, sitting on the server, the
connection timeout is set to 150, when the client try to save in the db with
transaction, in 15 seconds it return
"Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding."
the Server and the client are running Windows 2000, and i install MDAC 2.8
SP1, this problem ocur only in our client and not in development, in other
words, When i run the insert or update statment from my pc it takes < 5s!!!,
I checked my code extensibly but no proble there!
Does anybody have any ideas why this is happening
Thanx in advance

 

[Miha Markic [MVP C#]]

Try increasing SqlCommand.CommandTimeout property.

 

[Nassos]

Hi Miha,

First of all thanx for the reply, this is one of the first thinks I did, but
with no success :-( , the timeout occurs before the assigned value (I put it
to 150s and in 10s I got this message), the statement is not large to
justify this behaviour, so the Timeout property of the connection and of the
SqlCommand have no effect in the problem, but any other thought are welcome

Best Regards,

Reyzidis Nassos

Try increasing SqlCommand.CommandTimeout property.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

Hi All,
I have a connection to an SQL dataBase, sitting on the server, the
connection timeout is set to 150, when the client try to save in the db
with transaction, in 15 seconds it return
"Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding."
the Server and the client are running Windows 2000, and i install MDAC
2.8 SP1, this problem ocur only in our client and not in development, in
other words, When i run the insert or update statment from my pc it takes
< 5s!!!, I checked my code extensibly but no proble there!
Does anybody have any ideas why this is happening
Thanx in advance