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 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| <?php
/** Configuration Variables **/
define ('DEVELOPMENT_ENVIRONMENT',false);
// Connexion à la base de données 1
$server1 = 'server1\instance1';
$username1 = 'user1';
$password1 = 'mdp1';
$database1 = 'base1';
//$connexion1 = mssql_connect($server1, $username1, $password1, true);
$connexion1 = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server1;Database=$database1;", $username1, $password1);
if(!$connexion1)
{
die("Not connected to : " . odbc_error());
}
$db_selected1 = mssql_select_db($database1, $connexion1);
if(!$db_selected1)
{
die("Can't use db 1 : " . mssql_get_last_message());
}
//Connexion 2
$server2 = 'server2\instance1';
$username2 = 'user2';
$password2 = 'mdp2';
$database2 = 'base2';
// $connexion2 = mssql_connect($server2, $username2, $password2, true);
$connexion2 = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server2;Database=$database2;", $username2, $password2);
if(!$connexion2)
{
die("Not connected to : " . odbc_error());
}
$db_selected2 = mssql_select_db($database2, $connexion2);
if(!$db_selected2)
{
die("Can't use db 2 :" . mssql_get_last_message());
}
?> |
Partager