13 Replies Latest reply: Nov 16, 2016 1:16 PM by Evan Kurowski RSS

    Connection string Timeout - is it possible?

    Robert Evason

      I am having issues with connections to SQL Server 'locking up' and having to manually end the QV.exe and was wondering how to overcome the issue?


      This is my connection string;


      OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=QVUser;Initial Catalog=Cloudjh;Data Source=dbsxd;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=L2318;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is DITePYMGQBcCGaRObE);


      There is a Connect Timeout in the Advanced section of Data Link Properties, but it doesn't seem to do anything?


      Any ideas would be great.