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 |
liewsb
Starting Member
4 Posts |
Posted - 2010-03-08 : 02:41:00
|
I face the error msg: Micosoft OLE DB Provider for SQL Server: Timeout expired when executing a Vbscript program that contained a SQL statement that inner join and query data from 2 tables in SQL 2005 DB. I have set the Execution time-out is set to 0(no time-out) in SQL Server Management Studio. Is there any codes that can written in the Vbscript to slove for time-out error. Appreciate on any advises. Thanks.Regards,LSB |
|
liewsb
Starting Member
4 Posts |
Posted - 2010-03-09 : 00:49:08
|
Anyone can advise on these. Thanks alot..quote: Originally posted by liewsb I face the error msg: Micosoft OLE DB Provider for SQL Server: Timeout expired when executing a Vbscript program that contained a SQL statement that inner join and query data from 2 tables in SQL 2005 DB. I have set the Execution time-out is set to 0(no time-out) in SQL Server Management Studio. Is there any codes that can written in the Vbscript to slove for time-out error. Appreciate on any advises. Thanks.Regards,LSB
|
|
|
|
|
|