Connect to SQL Server through PDO using SQL Server Driver

Question

I am trying to connect to an existing SQL Server database using PDO with the drivers provided by Microsoft   I have seen examples using odbc  dblib  mssql  etc   however I believe the connection string with these drivers should use  sqlsrv    Are there any good examples of how to properly do this  If I should be doing this via some other method please let me know  Thanks

User · Answer

Figured this out  Pretty simple    new PDO  sqlsrv server  sqlservername  Database  sqlserverdbname       username      password

User · Answer

servername        username        password        database        port    1433   try        conn   new PDO  sqlsrv server  servername  port Database  database ConnectionPooling 0    username   password          array              PDO  ATTR PERSISTENT   gt  true              PDO  ATTR ERRMODE   gt  PDO  ERRMODE EXCEPTION                    catch  PDOException  e        echo   Error connecting to SQL Server       e- gt getMessage

User · Answer

Well that s the best part about PDOs is that it s pretty easy to access any database  Provided you have installed those drivers  you should be able to just do    db   new PDO  sqlsrv Server YouAddress Database YourDatabase    Username    Password

User · Answer

try         conn   new PDO  sqlsrv Server  server name Database  db name ConnectionPooling 0                 conn- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION      catch PDOException  e          e- gt getMessage

User · Answer

This works for me  and in this case was a remote connection  Note  The port was IMPORTANT for me   dsn    sqlsrv Server server dyndns biz 1433 Database DBNAME    conn   new PDO  dsn   root    P4sw0rd     conn- gt setAttribute  PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION      sql    SELECT   FROM Table    foreach   conn- gt query  sql  as  row        print r  row

User · Answer

Mind you that in my experience and also of other  PHP - Why is new SQLSRV driver slower than the old mssql driver   that using PDO SQLSRV is way slower than through PDO ODBC   If you want to use the faster PDO ODBC you can use     use any of these or check exact MSSQL ODBC drivername in  ODBC Data Source Administrator   mssqldriver     SQL Server      mssqldriver     SQL Server Native Client 11 0     mssqldriver     ODBC Driver 11 for SQL Server      hostname  127 0 0 1    dbname  test    username  user    password  pw    dbDB   new PDO  odbc Driver  mssqldriver Server  hostname Database  dbname    username   password

[php] Connect to SQL Server through PDO using SQL Server Driver

Examples related to php

Examples related to sql-server

Examples related to windows

Examples related to pdo