Advertisement
Guest User

Untitled

a guest
Jul 18th, 2017
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. $ yum list php56w-mssql
  2. Installed Packages
  3. php56w-mssql.x86_64 5.6.30-1.w7 @webtatic
  4.  
  5. $ cat /etc/php.d/mssql.ini
  6. ; Enable mssql extension module
  7. extension=mssql.so
  8.  
  9. $ php -i | grep 'PDO drivers'
  10. PDO drivers => dblib, mysql, sqlite
  11.  
  12. $ yum list php56w-odbc
  13. Installed Packages
  14. php56w-odbc.x86_64 5.6.30-1.w7 @webtatic
  15.  
  16. $ cat /etc/php.d/odbc.ini
  17. extension=odbc.so
  18.  
  19. $mssqldriver = 'ODBC Driver 13 for SQL Server';
  20. $hostname='1.2.3.4';
  21. $dbname='foobar';
  22. $username='';
  23. $password='';
  24.  
  25. $dsn = "odbc:Driver={$mssqldriver};Server={$hostname};Database={$dbname};MARS_Connection=yes";
  26. $pdo= new PDO($dsn, $username, $password);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement