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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 OLE DB Timeout Expired

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

Go to Top of Page
   

- Advertisement -