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 |
|
parajuli95
Starting Member
1 Post |
 Posted - 2010-01-09 : 07:19:53
|
| I am having a timeout issue in vbscript using SQLOLEDB, which is as below. But i am having timeout problem very often. I did try with 0 but did not help. oCn.ConnectionString = "PROVIDER=SQLOLEDB" & _ ";SERVER=" & sServer & _ ";UID=" & sLogin & _ ";PWD=" & sPwd & _ ";DATABASE=" & sDB & " "oCn.ConnectionTimeout=600oCn.openI am using SQL server 2005 in windows server 2003 enviroment.Thanks. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-09 : 08:28:09
|
| Is the timeout for all situations or only on certain queries?Have you checked the SQL Server is OK , you could connect to SSMS and do some tests?Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
|
|
|
Connection Timeout