Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cbuschel
Starting Member
3 Posts |
 Posted - 2002-06-17 : 16:02:25
|
| I'm trying to create a new view via Enterprise Manager and when I run the view I receive an error:"[ODBC SQL Server Driver] Timeout expired"The new view (ie. 'MyView') I'm trying to create is based on two views I made previously (ie. 'View1' and 'View2'). The two views are linked on a single ID field by and inner join (described below)...SELECT [attributes...]FROM View1 INNER JOIN View2 ON View1.[Lab ID] = View2.[Lab ID](Note - To Run View1 alone it takes about 30 seconds to process and to Run View2 alone it takes about 15 seconds to process)Does anyone know why I'm receiving this timeout error and how I can resolve it??? Should I just simplify this all into one view? Or is there a timeout setting I just have to modify?Thanks for your help!Cam |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-06-17 : 16:07:43
|
| See if these links help:How to troubleshoot SQL Server ODBC timeout errors?http://vyaskn.tripod.com/sql_odbc_timeout_expired.htmMy Enterprise Manager times out while connecting to a server over WAN (Internet). How can I specify timeout values for Enterprise Manager?http://vyaskn.tripod.com/sql_server_tools_faq.htm#q7--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
|
|
|
ODBC timeout expired