PHP and SQL Server connection problem

[myefforts]

Hi

I am trying to connect to the SQL Server 2000 database from PHP. I have a page that contains just

<?php

mssql_connect("mssql.active-ns.com,1433", "mib_code", "***") or die("error");

?>

and this fails every time even though the username and password are correct.

Any suggestions would be gratefully received!

[aiBET]

Any suggestions to this issue? I'm using the following and the connection is failing:

$link_id = mssql_connect('mssql.catalyst2.com', 'name', 'password') or die('Message');

[myefforts]

I couldn't get the PHP mssql functions to work at all. I set up an ODBC data source instead and used:

PHP Code:

odbc_connect($dsn, $user, $password); 


hope this helps

[paulredpath]

Hi,

Sorry this must have been overlooked. If you can pm me your domain I will make sure the mssql module is enabled properly in PHP.