sqlsrv API vs PDO sqlsrv

  • I’m stumbling over my choice to select the “SQL Server using MS PHP driver”(sqlsrv API) or the “PDO SqlSrv.” I have:

    Srv2008R2, SQLExpress2012, or, I could connect to SQL Server 2008. I’m in IIS 7.5; I have php 5.4.4, and I have the drivers:

    php_pdo_sqlsrv_53_nts.dll, (non-thread-safe)
    php_pdo_sqlsrv_53_ts.dll, (non-thread-safe)
    php_pdo_sqlsrv_54_nts.dll, (thread-safe)
    php_pdo_sqlsrv_54_ts.dll (thread-safe)

    php_sqlsrv_53_nts.dll, (non-thread-safe)
    php_sqlsrv_53_ts.dll, (non-thread-safe)
    php_sqlsrv_54_nts.dll, (thread-safe)
    php_sqlsrv_54_ts.dll (thread-safe)

    These are all enabled via PHP Manager in IIS.

    I’m at the WordPress install (all the prerequisites checkout, which I can provide info on later).

    My options are (from the setup-config.php abstraction):

    MySQL (don’t need)
    MySQLi (don’t need)
    SQL Server using MS PHP driver
    PDO MySQL (don’t need)
    PDO SqlSrv

    I know “SQL Server using MS PHP driver” is the sqlsrv API and that “PDO SqlSrv” is the PDO version. I don’t think it should make a lot of difference, but which should I choose?

    How do they correspond to the drivers I have listed above??

    My install is inhouse. Any advice would be helpful.

    Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)

  • Do you have the most recent backup of your database?

    Thread Starter cxcsr2012

    (@cxcsr2012)

    This was a new install with new server. New DB, new everything (downloaded in the last 3 days). There was no current data, just a login and user for the database (SQLExpress2012). I’m a little disappointed with the lack of good documentation. Backup?–not yet.

    But Update!!!: I chose the “SQL Server using MS PHP driver” option, and after a few side issues with wordpress php files,,,I’m in! (at least up to the “Welcome to your new site” screen, which is local on my IIS).

    I’m not through, I’m sure of that. But the deal is working. I haven’t analyzed the database, the logs, or any other potential side effects yet. It looks good and I will follow up tomorrow.

    Thank you for replying. Stay with me–not done (keeping notes). I have to use this product this week–we shall see…

    Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘sqlsrv API vs PDO sqlsrv’ is closed to new replies.