This project is read-only.
1

Resolved

SQLHELPER Connection Issue (SQLHelper_Connection.cs\vb)

description

If you have been experiencing connection issues with the SQLHelper component it is due to the following code in the "SQLHelper_Connection.cs" module.
 
          if (csConnectionString.ToUpper().IndexOf("CONNECT TIMEOUT") == -1)
          {
              if (piTimeOut == 0)
              {
                  if (csConnectionString.Substring((psConnectionString.Length - 1), 1) != ";")
                  {
                      csConnectionString = "; Connect Timeout=60" + piTimeOut.ToString().Trim();
                  }
                  else
                  {
                      csConnectionString = " Connect Timeout=60";
                  }
              }
              else if (csConnectionString.Substring((psConnectionString.Length - 1), 1) != ";")
              {
                  csConnectionString = "; Connect Timeout=" + piTimeOut.ToString().Trim();
              }
              else
              {
                  csConnectionString = " Connect Timeout=" + piTimeOut.ToString().Trim();
              }
          }
 
This code resides in the "SQLHelper_Connection" constructor and is in error in both the C# and VB.NET classes.
 
A new version of SQLHelper will be uploaded over the weekend of 3/20-3/21.
 
Sincere apologies for this error...

comments