Guest User

Untitled

a guest
Oct 19th, 2017
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. $db = new PDO("sqlsrv:Server=YouAddress;Database=YourDatabase", "Username", "Password");
  2.  
  3. new PDO("sqlsrv:server=[sqlservername];Database=[sqlserverdbname]", "[username]", "[password]");
  4.  
  5. //use any of these or check exact MSSQL ODBC drivername in "ODBC Data Source Administrator"
  6. $mssqldriver = '{SQL Server}';
  7. $mssqldriver = '{SQL Server Native Client 11.0}';
  8. $mssqldriver = '{ODBC Driver 11 for SQL Server}';
  9.  
  10. $hostname='127.0.0.1';
  11. $dbname='test';
  12. $username='user';
  13. $password='pw';
  14. $dbDB = new PDO("odbc:Driver=$mssqldriver;Server=$hostname;Database=$dbname", $username, $password);
  15.  
  16. $dsn = "sqlsrv:Server=server.dyndns.biz,1433;Database=DBNAME";
  17. $conn = new PDO($dsn, "root", "P4sw0rd");
  18. $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
  19.  
  20. $sql = "SELECT * FROM Table";
  21.  
  22. foreach ($conn->query($sql) as $row) {
  23. print_r($row);
  24. }
  25.  
  26. try
  27. {
  28.  
  29. $conn = new PDO("sqlsrv:Server=$server_name;Database=$db_name;ConnectionPooling=0", "", "");
  30. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  31.  
  32. }
  33. catch(PDOException $e)
  34. {
  35.  
  36. $e->getMessage();
  37.  
  38. }
Add Comment
Please, Sign In to add comment