static public SqlConnection CreateSqlConnection(DBLGDatabaseLogin dblgLogin)
{
SqlConnection sqcnResult = new SqlConnection(CreateLoginString(dblgLogin));
sqcnResult.Open();
return(sqcnResult);
}
public static string CreateLoginString(DBLGDatabaseLogin dblgLogin)
{
//cwrKey.SetValue(C_SW_RegConStr,"Data Source=.;Initial Catalog=CrawlWave;User ID=sa;Password=ln^!@xs!4;Persist Security Info=True;pooling=false");
//string strResult=string.Format("database={0};server={1};user id={2};password={3};Network Library=DBMSSOCN;pooling=false",
//cwrKey.SetValue(C_SW_RegConStr,"Data Source={0};Initial Catalog={1};User ID={2};Password={3};Persist Security Info=True;pooling=false");
string strResult=string.Format("initial catalog={0};user id={2};data source=\"{1}\";persist security info=True;connect timeout={4};pooling=false;password=\"{3}\"",
dblgLogin.InitialCatalog, dblgLogin.Server, dblgLogin.UserName, dblgLogin.Password,dblgLogin.ConnectionTimeout);
//initial catalog=CrawlWave;user id=sa;data source=".";persist security info=True;connect timeout=0;pooling=false;password="******"
return strResult;
}
static public string CreateLoginString(DBLGDatabaseLogin dblgLogin)
{
//cwrKey.SetValue(C_SW_RegConStr,"Data Source=.;Initial Catalog=CrawlWave;User ID=sa;Password=ln^!@xs!4;Persist Security Info=True;pooling=false");
//string strResult=string.Format("database={0};server={1};user id={2};password={3};Network Library=DBMSSOCN;pooling=false",
//cwrKey.SetValue(C_SW_RegConStr,"Data Source={0};Initial Catalog={1};User ID={2};Password={3};Persist Security Info=True;pooling=false");
string strResult = string.Format("initial catalog={0};user id={2};data source=\"{1}\";persist security info=True;connect timeout={4};pooling=false;password=\"{3}\"",
dblgLogin.InitialCatalog, dblgLogin.Server, dblgLogin.UserName, dblgLogin.Password, dblgLogin.ConnectionTimeout);
//initial catalog=CrawlWave;user id=sa;data source=".";persist security info=True;connect timeout=0;pooling=false;password="******"
return(strResult);
}
public static SqlConnection CreateSqlConnection(DBLGDatabaseLogin dblgLogin)
{
SqlConnection sqcnResult = new SqlConnection(CreateLoginString(dblgLogin));
sqcnResult.Open();
return sqcnResult;
}
