A timeout particularly hard to resolve

Question

Post reply

A timeout particularly hard to resolve

kmerzak

SSC Enthusiast

Points: 103
More actions
March 11, 2003 at 10:26 am

#159445

I am facing a great problem of timeout on a simple Select statement (select * from customer) : customer has not a lot of columns and rows.
The code is written in Vb6 : a client class customer that doesn't handle date directly but through its server class customer : this one deal with data by calling a simple data provider (in form of dll). I tried many things: verify the indexes, the timeout parameter in commands (all set to 0) and the timeout on sql server. The timeout problem is still raising. Note : To handle data the simple date provider use MTS to create data object. Thanks for replying. Merzak

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Do you get the timeout when you run the same select in Query Analyzer?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Andy
Connect with me on LinkedIn

kmerzak SSC Enthusiast Points: 103 More actions · Answer 2

quote:
Do you get the timeout when you run the same select in Query Analyzer?
No
Andy
http://www.sqlservercentral.com/columnists/awarren/

kmerzak SSC Enthusiast Points: 103 More actions · Answer 3

quote:
Do you get the timeout when you run the same select in Query Analyzer?
I think there is a relationship with MTS : as if the simple data provider take long time to create the data object. Isn't it ?
Andy
http://www.sqlservercentral.com/columnists/awarren/

A timeout particularly hard to resolve

Cookies on SQLServerCentral