March 11, 2003 at 10:26 am
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
March 11, 2003 at 11:22 am
Do you get the timeout when you run the same select in Query Analyzer?
Andy
March 11, 2003 at 11:30 am
quote:
Do you get the timeout when you run the same select in Query Analyzer?No
Andy
http://www.sqlservercentral.com/columnists/awarren/
March 11, 2003 at 11:34 am
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/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply