01.$hostname = '192.168.1.99';
02.$port = 1433;
03.$dbname = "dbname";
04.$username = "user";
05.$pw = "psw";
06.
07.try {
08. $db_pdo = new PDO ("dblib:host=$hostname:$port;dbname=$dbname","$username","$pw");
09. echo 'pdo Connection established.<br />';
10.} catch (PDOException $e) {
11. echo "Failed to get DB handle: " . $e->getMessage() . "\n";
12. exit;
13.}
14.
15.
16.$connectionInfo = array( "Database"=>$dbname, "UID"=>$username, "PWD"=>$pw);
17.$db_sqlsrv = sqlsrv_connect( $hostname, $connectionInfo);
18.if( $db_sqlsrv ) {
19. echo "sqlsrv Connection established.<br />";
20.}else{
21. echo "Connection could not be established.<br />";
22. echo '<pre>'; print_r(sqlsrv_errors()); echo '</pre>';
23.}
