|
|
|
|||||||
| Notices |
 |
|
|
Thread Tools | Display Modes |
11-12-2007, 04:47 PM
|
#1 |
|
Guest
Posts: n/a
|
timeout error while open-view
Hi,
When i tried to open-view it says '.net sqlclient dataprovider error' timeout expired.I have change timeout value(Tools--options-- executiontimeout),eventhough getting the same error. Please help me to fix this. But when i execute the query in query analyser i got the output.query completes in 12 minutes to display the result. Regards, Vijay |
|
|
11-12-2007, 04:47 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: timeout error while open-view
Maybe you should increase .NET timeout by properly defined connection
string? -- Regards Pawel Potasinski [ Uzytkownik "Vijay" <> napisal w wiadomosci news:... > Hi, > > When i tried to open-view it says '.net sqlclient dataprovider > error' timeout expired.I have change timeout value(Tools--options-- > executiontimeout),eventhough getting the same error. > Please help me to fix this. > > But when i execute the query in query analyser i got the output.query > completes in 12 minutes to display the result. > > Regards, > Vijay |
|
|
|
11-12-2007, 04:47 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: timeout error while open-view
Oh, sorry, didn't notice you're using SSMS :-) Forget about my previous
post. -- Regards Pawel Potasinski [ Uzytkownik "Vijay" <> napisal w wiadomosci news:... > Hi, > > When i tried to open-view it says '.net sqlclient dataprovider > error' timeout expired.I have change timeout value(Tools--options-- > executiontimeout),eventhough getting the same error. > Please help me to fix this. > > But when i execute the query in query analyser i got the output.query > completes in 12 minutes to display the result. > > Regards, > Vijay |
|
|
|
| Thread Tools | |
| Display Modes | |
|
|
< Windows Help - MS Office Help - Hardware Support >
| New To Site? | Need Help? |
Linear Mode
