Need MS SQL OLE DB provider with support of Command timeout as parameter within a connection string

I have Excel 2007 data sheet with connetion to external data source (SQL Server 2008). Sometimes server goes blocked for hours - so I need command timeout to switch to another server. I need it within the very connetion string, not within ADODB.Connection/Command there in VBA. I tried two Providers from Microsoft:

1. SQLOLEDB.1 (Microsoft OLE DB Provider for SQL Server) 2) SQLNCLI10.1 (SQL Server Native Client 10.0)
   They do not support command timeouts actually. NEED HELP!!!

P.s.: Connection string look like: "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=ADTS_Replica_CROWN_To_OLYMPUS;Data Source=OLYMPUS;Extended Properties="Timeout=1";Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=G-OFFICE104;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False"

0 answers