How to connect to ms sql 2000 with Windows 7 (x64) using php?

Question

PHP

Good afternoon colleagues!
There is a task to organize a small unloading by means of a web-interface (php) from a MS SQL database.
Windows 7 64 with XAMPP (php 5.5.11) is installed on the PC that is used as a "web server"
The server with the database is located somewhere far away, and MS SQL Server 2000 is installed on it. A module for working with mssql
was installed on the PC in php, and the ODBC 11 driver is installed (I simply could not find a driver of another version), then I made a test script and in response I get:

Connection could not be established.
Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 22 [code] => 22 [2] => [Microsoft][ODBC Driver 11 for SQL Server]Драйвер ODBC Driver 11 for SQL Server не поддерживает соединения с SQL Server 2000 и более ранними версиями. [message] => [Microsoft][ODBC Driver 11 for SQL Server]Драйвер ODBC Driver 11 for SQL Server не поддерживает соединения с SQL Server 2000 и более ранними версиями. ) [1] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => 22 [code] => 22 [2] => [Microsoft][ODBC Driver 11 for SQL Server]Клиенту не удается установить связь [message] => [Microsoft][ODBC Driver 11 for SQL Server]Клиенту не удается установить связь ) )

Actually, the question is how to be in this situation, as well as what to do if from the same PC it may be necessary to organize a connection to another server (based on MS SQL Server 2008)
I had no experience in setting up MS SQL servers before, therefore I will be glad for any help..

Answer 1

You need to start by checking the availability and settings of the server, which is somewhere there.
Maybe the new ODBC driver doesn't want to work with the old server - install SQL 2000 server on your local computer - the driver is usually bundled.
You can also try to connect from Excel and Access - to find out if the problem is in the driver.

Answer 2

The official Microsoft driver includes several drivers:
You need SQLSRC20, it runs on PHP 5.2.4 - 5.3, SQL Native client 2008 R2 and can connect to both 2000 and 2008.