Hi guys,

I am trying to connect to MS SQL Server on a remote machine from my Win XP box (php 4). The following line in my code:

$live = mssql_connect($server, $user, $passwd);

causes the following error:

Warning: MS SQL error: Db-library network communciations layer not loaded. (severity 9) ...

Before you start typing, yes I did uncomment the extension line in php.ini and yes I have copied the ntwdblib.dll from the 'dlls' directory to my system directory.

Anyone out there have any ideas?

    That looks like an error message from the MS SQL library, not from PHP. Are you sure things are set up correctly on the MS SQL end?

      --and does your phpinfo() show the MS SQL library loaded properly?

        I had similar problems getting MS SQL to work.
        Tried all sorts of things but in the end I had to admit defeat and use and ODBC connection which works just fine.
        I ahve two server one running IIS5 and the other running MS SQL2000. Give it a try!

          2 months later

          Hi,

          I have a similar problem trying to make a Delphi program work via DBLib on XP (works fine on W9x/NT/2K) the same way by just copying ntwdblib.dll. No success so far. Have you tried full MSSQL client install on the XP box?

            Write a Reply...