none
Connecting to SQL Server 2000 with PDO drivers

    Question

  • I read that the PHP PDO drivers use the SQL Server 2012 Native Client ODBC Driver to connect to SQL Server. The SQL Server 2012 Native Client says it supports connecting to SQL Server 2000, but the PHP PDO drivers say that it's for 2005 and higher. Does that mean I can use the PHP PDO 3.0 drivers to connect to SQL Server 2000 afterall?


    • Edited by timmerk Tuesday, January 29, 2013 1:39 AM
    Tuesday, January 29, 2013 1:37 AM

Answers

  • Hi timmerk,

    As my understanding, it cannot be used to connect sql server 2000. The limitation is the PHP PDO drivers say that it's for 2005 and higher. It seems PHP PDO driver always connect SQL Server using Native client 2012, and the limitation for 2005 and higher also apply to using native client 2012 if you are using PHP PDO.

    The SQL Server 2012 Native Client says it supports connecting to SQL Server 2000, it means if you use SQL Server 2012 Native Client directly, you can connect to SQL Server 2000.


    Iric Wen
    TechNet Community Support

    Friday, February 01, 2013 8:08 AM

All replies

  • Hi timmerk,

    As my understanding, it cannot be used to connect sql server 2000. The limitation is the PHP PDO drivers say that it's for 2005 and higher. It seems PHP PDO driver always connect SQL Server using Native client 2012, and the limitation for 2005 and higher also apply to using native client 2012 if you are using PHP PDO.

    The SQL Server 2012 Native Client says it supports connecting to SQL Server 2000, it means if you use SQL Server 2012 Native Client directly, you can connect to SQL Server 2000.


    Iric Wen
    TechNet Community Support

    Friday, February 01, 2013 8:08 AM
  • Hi Iric,

    Can you elaborate on this? Once the SQL Server 2012 Native Client is installed how do we connect?

    Also, the page where you download that (http://www.microsoft.com/en-ca/download/details.aspx?id=29065) says:

    Microsoft SQL Server Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2012 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server code name ‘Denali’ features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API.

    There is no mention of 2000.

    Tuesday, September 17, 2013 7:36 PM