Guest_imported
New member
- Jan 1, 1970
- 0
I have two copies of database with same tables and views: one is my own local copy and the other one is in the server.
I created new "view" in my local database and it works fine. That particular view links three different views together. They work perfectly fine ( meaning: I can query the whole table and display all the data). Then, same thing I did to the server database. There I also created a new "view" using same select statements and I got the error saying : [Microsoft][ODBC]SQL Server Driver] Timeout expired
I thought it has something to do with the connection timeout, I set the server property timout to max value, it doesn't seem to make any changes. Also, the three views which is forming this new view, are displaying the row fine. It is quite wierd since both of the table in local and server database are OK.
Can anybody give me a suggestion? Thanks alot!!!
I created new "view" in my local database and it works fine. That particular view links three different views together. They work perfectly fine ( meaning: I can query the whole table and display all the data). Then, same thing I did to the server database. There I also created a new "view" using same select statements and I got the error saying : [Microsoft][ODBC]SQL Server Driver] Timeout expired
I thought it has something to do with the connection timeout, I set the server property timout to max value, it doesn't seem to make any changes. Also, the three views which is forming this new view, are displaying the row fine. It is quite wierd since both of the table in local and server database are OK.
Can anybody give me a suggestion? Thanks alot!!!
