this is first time connect php with mssql 2005
<?php $myServer = "srv\ins"; $myUser = ""; $myPass = ""; $myDB = "db1"; //connection to the database $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); //select a database to work with $selected = mssql_select_db($myDB, $dbhandle) or die("Couldn't open database $myDB"); ?>
but return error "mssql_connect(): Unable to connect to server"
i think something missing in my code when you have instance, because same code run successfully without instance
i hope to help me because iam seraching this problem and not found any solution