What extension of PHP should I use with SQL Server 2000?

Question

What extension of PHP should I use with SQL Server 2000?

Navigation

#1 by (2 votes)

3

I am trying to connect to the SQL Server 2000 database using PHP PDO SQLSRV, but when access to index returns me the catch() with the following error

SQLSTATE [08001]: [Microsoft] [SQL Server Native Client 11.0] SQL Server Native Client 11.0 does not support connections to SQL Server 2000 or earlier versions.

Any tips on how I can resolve?

php sql-server pdo

asked by anonymous 16.02.2016 / 00:32

1 answer

How to take the opposite rotation of the camera in unity 5 What is the difference between .data () and JQuery.data ()?

score 2 · Accepted Answer

Unfortunately this version of SQL Server Native Client does not work with SQL. Server 2000.

You need to use Microsoft Drivers 2.0 for PHP for SQL Server in this case and Microsoft SQL Server 2008 R2 Native Client.

However, to use version 2.0, you need to use maximum PHP 5.3. Use this table as a comparison:

| Versão do Driver | Versão do PHP  | Versão SQL Server |
|------------------|----------------|-------------------|
| 3.2              | 5.4, 5.5 e 5.6 | 2005+             |
| 3.1              | 5.4 e 5.5      | 2005+             |
| 3                | 5.3 e 5.4      | 2005+             |
| 2                | 5.2 e 5.3      | 2000+             |

More information here .