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; }