internal static string BuildConnectionString(bool integratedSecurity, string databaseName, string serverName, string userName, string password)
{
var connStr = new StringBuilder();
//ODBCSTUFF
//Provider=SQLOLEDB.1;Use Procedure for Prepare=1;Auto Translate=True;Use Encryption for Data=False;Tag with column collation when possible=False
if (integratedSecurity)
{
connStr.Append("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=");
connStr.Append(databaseName);
connStr.Append(";Data Source=");
connStr.Append(serverName);
connStr.Append(";Packet Size=4096;Workstation ID=");
connStr.Append(serverName);
}
//ODBC STUFF
//Provider=SQLOLEDB.1;Use Procedure for Prepare=1;Auto Translate=True;Use Encryption for Data=False;Tag with column collation when possible=False
else
{
connStr.Append("Persist Security Info=False;User ID=");
connStr.Append(userName);
connStr.Append(";PWD=");
connStr.Append(password);
connStr.Append(";Initial Catalog=");
connStr.Append(databaseName);
connStr.Append(";Data Source=");
connStr.Append(serverName);
connStr.Append(";Packet Size=4096;Workstation ID=");
connStr.Append(serverName);
}
//Default Timeout to 1 hour
connStr.Append(";Connect Timeout=3600");
return connStr.ToString();
}