1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
public void connexion_sgbd()
{
//récupération du contenu du fichier de conf
string driver = ConfigurationManager.AppSettings["sgbd_driver"];
string protocol = ConfigurationManager.AppSettings["sgbd_protocol"];
string host = ConfigurationManager.AppSettings["sgbd_host"];
string port = ConfigurationManager.AppSettings["sgbd_port"];
string service_name = ConfigurationManager.AppSettings["sgbd_service_name"];
string user = ConfigurationManager.AppSettings["sgbd_user"];
string user_uncrypt = MaFonction.decrypt(user, "lacle");
string pwd = ConfigurationManager.AppSettings["sgbd_pwd"];
string pwd_uncrypt = MaFonction.decrypt(pwd, "lacle");
//hachage des variables
connection_odbc.ConnectionString =
"Driver=" + driver + ";" +
"SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=" + protocol + ")(HOST=" + host + ")(PORT=" + port + "))(CONNECT_DATA=(SERVICE_NAME=" + service_name + ")));" +
"Uid=" + user_uncrypt + ";" +
"Pwd=" + pwd_uncrypt + ";";
connection_odbc.Open();
} |
Partager