PHP with MS SQL 7 Server Service Pack 4 - Cannot Connect

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jack Smith

    PHP with MS SQL 7 Server Service Pack 4 - Cannot Connect

    Hello,

    I have PHP 4.3.1.1 running on Windows 2000 Server with IIS 5. This
    connects to an MS SQL 7 server running on a seperate NT4 box.
    Recently, this SQL7 Server had SQL7 Service Pack 4 applied to it.
    After this Service Pack, the PHP apps could no longer connect to the
    database.

    Warning: mssql_connect() [function.mssql-connect]: Unable to connect
    to server: <mySQLServer> in <myPHPapp.php > on line 12.

    From what I understand, SP4 broke something in named pipes
    connections, and the fix is to update the client to MDAC 2.7 or later.
    This update was applied to the PHP server, but PHP still cannot
    connect.

    Anyone else run into this?

    Thanks,
    Jack Smith
Working...