Click here to Skip to main content
13,202,706 members (55,272 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
Hi,
Can anyone tell me how to set the command timeout to 0, or any other number for that matter using the following recordset connection and open string?
objConn.Open "Driver={SQL Server}" & _
           "Server=x.x.x.x;" & _
           "Address=x.x.x.x,1433;" & _
           "Network=DBMSSOCN;" & _
           "Database=yyy;" & _
           "Uid=user" & _
           "Pwd=pass"
 
sSQL = "SELECT InvoiceYear, InvoiceMonth, InvoiceDay, InvoiceDate, InstituteName, CourseName, ItemNet , ItemTax FROM dbo.Table_Sales ORDER BY InvoiceDate"
 
rsData.Open sSQL, objConn, adLockReadOnly, adCmdText

Many thanks in advance
Martin
Posted 16-Jan-13 5:18am
Updated 16-Jan-13 6:45am
RedDk18.5K
v2
Comments
RedDK 16-Jan-13 12:49pm
   
If by timeout you mean "to zero because when I run this query I get a timeout error" I'd say you need to fix the connection string. And by the way, what version of Excel are you running and on what Windows?

Might be a driver issue too. 32-bit?
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Try changing your connection string to one found on this page.

Perhaps setting the Connect Timeout parameter to 300 seconds (5min) like this:
"Server=ServerName\InstanceName;Database=yyy;User Id=user;Password=pass;Connection Timeout=300;"


Alternatively you could set one of these properties found on the ADO connection object:
objConn.ConnectionTimeout
objConn.CommandTimeout
  Permalink  
v5
Comments
RedDK 16-Jan-13 14:12pm
   
ConnectionStringsdotcom ... amazing, isn't it?
BC @ CV 16-Jan-13 14:36pm
   
Yes indeed. The one stop shopping destination for solving connection conundrums!
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

In case anyone interested I managed to solve the problem by changing the provider
Provider=SQLNCLI10
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web03 | 2.8.171020.1 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100