How can I set the query timeout property in my project? I am trying the following:
Dim cn As OleDbConnection
set cn.QueryTimeout = 120
Const strCN As String = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;User ID='';Initial Catalog=LH1_Replicate;Data Source=BS-120471\SQLEXPRESS;Initial File Name=''; Connect Timeout=60000; Server SPN=''"
but I receive a sintax error on the "set".
I am a beginner using Visual Studio 2008
Thank you very much.