1

I have a production support site that runs on Windows Server 2003, SQL Server 2008 r2, php 5.2.6 and I have to connect it to a new server with windows server 2019 with SQL Server 2019.

When I try to connect from the old server to the new one, the mssql_connect() function gives me an error. I think it's the fault of wrong drivers, but I'm afraid that the versions take too many years.

Is there any solution? Is there a driver that is compatible with server 2003 that allows you to connect to SQL Server 2019?

Dale K
  • 25,246
  • 15
  • 42
  • 71
MarcoAgu
  • 11
  • 3
  • Yes I have searched for drivers, but those that are compatible with Windows 2003, I understand are too obsolete for sql server 2019. So I seemed to understand from some guidelines on the microsoft website – MarcoAgu Jun 05 '20 at 08:42
  • I'm able to connect to SQL Server 2017 with PHP 5.2.10 and `mssql_connect()`, but I can't test the connection with SQL Server 2019. What is the error? – Zhorov Jun 05 '20 at 08:45
  • mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.1.4,1433 in C:\... which driver version are you using? – MarcoAgu Jun 05 '20 at 08:48
  • Library version 7.0, php-mssql.dll (5.2.10.10) and ntwdblib.dll (8.00.194). – Zhorov Jun 05 '20 at 08:58
  • sorry for the question, for library version 7 what do you mean? ntwdblib and php_mssql (5.2.6.6) are ok. – MarcoAgu Jun 05 '20 at 09:12
  • From ``, section `mssql`. Only a note, but I'm not able to connect to `Microsoft Azure`. – Zhorov Jun 05 '20 at 10:26
  • PHP Driver for SQL Server does not [support](https://learn.microsoft.com/en-us/sql/connect/php/microsoft-php-drivers-for-sql-server-support-matrix?view=sql-server-ver15#supported-operating-systems) Windows Server 2003. So, using ODBC is probably the first option. – Zhorov Jun 05 '20 at 10:34
  • 2
    I had already tried through odbc but without success. Now I am trying to move the site to the new server to have more elasticity with the drivers – MarcoAgu Jun 05 '20 at 12:38

0 Answers0