none
SQL Native Client 2012

    Question

  • Hi - I would like to install Microsoft Driver 3.0 for PHP for SQL Server in order to get PHP and MS SQL Server 2008R2 Developer's Edition to communicate.  The PHP manual lists Microsoft SQL Server 2012 Native Client as a requirement to get this driver to work.  The machine that I'd like to use has Windows 7 Professional OS and the following:

    Other specs include: Apache/2.4.2 (Win32) OpenSSL/1.0.1c PHP/5.4.4, using XAMPP

    Here are my questions:

    1. Can SQL Native Client 10.0 and SQL Native Client 2012 co-exist on the same machine?

    2. Should I download the 32bit and the 64bit versions?


    • Edited by Knot Monday, October 22, 2012 2:03 AM
    Monday, October 22, 2012 1:57 AM

Answers

All replies

  • Hi

    Yes you can install both SQL Server Native Clients at the same time.  The Native Clients each contain a uniquely named ODBC driver and OLE DB driver, so all versions can be used simultaneously.

    If your Windows 7 is 64 bit, you will only be allowed to install the X64 version; if you have 32-bit Windows, install the X86 version...  the installer will not allow you to install the wrong one.


    Rob

    Monday, October 22, 2012 9:02 AM
  • Yes, the machine is 64bit.  I wonder why it appears to have both the 32bit and 64bit version of SQL Native Client 10.0 if the installer will not allow the 32bit to be installed on a 64bit machine...?

    Also, are there any issues trying to get Microsoft Driver 3.0 for PHP for SQL Server to work on a 64bit machine?

    Monday, October 22, 2012 2:38 PM
  • The 64 bit Native Client contains both 32+64 bit drivers, so that 32-bit programs will run on 64-bit Windows.

    The PHP driver 3.0 works fine on a 64-bit machine, but you must install the official 32-bit version of PHP from http://windows.php.net/download


    Rob

    Monday, October 22, 2012 3:08 PM
  • The PHP version that's installed on this machine was installed when XAMPP got installed.  I read the directions at the link above but no mention is made of what to do in this circumstance.  If an attempt is made to download PHP from the link provided, will it overwrite the existing version of PHP?  Are there any installation "gotchas" I should be aware of when attempting to swap PHP versions?  Also, will MySQL still work with the official 32bit version of PHP?  I need to be able to use both MySQL and MS SQL Server with PHP.
    • Edited by Knot Monday, October 22, 2012 11:40 PM
    Monday, October 22, 2012 11:14 PM
  • If you're using XAMPP you do not need to download PHP.

    Follow the instructions on this page to install Microsoft's PHP driver (ignoring any orange text which does not apply to you):

    http://robsphp.blogspot.co.uk/2012/09/how-to-install-microsofts-sql-server.html


    Rob

    • Marked as answer by Knot Wednesday, October 24, 2012 2:51 AM
    Tuesday, October 23, 2012 12:31 PM
  • Thank-you for the top notch help!  I will follow the instructions on the link.
    Wednesday, October 24, 2012 2:53 AM