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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy