|–> (Word)||–> (PDF)||–> (Epub)||–> (Text)|
|–> (XML)||–> (OpenOffice)||–> (XPS)||–> (MHT)|
|This article has been published 4 years, 197 days ago|
The estimated time to read this article is 3 minutes
This article has been read (567) times.
This article has been read (0) times today.
This article has been read (0) times this month.
This article has been read (0) times this year.
This article has 202 total words. (Including header)
This article has been updated on 5th June'13 at 8:07am
Follow @HeelpBook Tweet
I am programming with visual basic and I have a large query wich takes too long for execution. After 30 seconds I get a timeout error. Is there any way to raise the timeout to 90 seconds or something.
On Error Resume Next
Set cn = New ADODB.Connection
cn.Provider = "SQLOLEDB"
cn.Properties("Initial Catalog").Value = "DatabaseName"
cn.Properties("Data Source").Value = "ServerName"
cn.Properties("Connect Timeout").Value = 90
cn.Properties("General Timeout").Value = 90
cn.Properties("Persist Security Info").Value = False
cn.ConnectionTimeout = 90
cn.CommandTimeout = 90