-----Original Message----- From: Dan Shirah [mailto:mrsquash2@xxxxxxxxx] Sent: Wednesday, December 10, 2008 8:46 AM To: David Stoltz Cc: Daniel Brown; Bastien Koert; php-general@xxxxxxxxxxxxx Subject: Re: MSSQL_CONNECT problem > > Try something like this: > > > > $dbhost=\\\\SERVER\\INSTANCE_NAME,PORT; > $dbuser="USERNAME"; > $dbpass="PASSWORD"; > $db_connect=mssql_connect($dbhost,$dbuser,$dbpass) or die ('Server > connection failed'); > > > > $mssql_database = mssql_select_db("DATABASE", $db_connect) or die ('DB > selection failed'); > > > > Same thing: > > > > Warning: mssql_connect() [function.mssql-connect]: Unable to connect to > server: \\10.10.103.222\INTRA_SQL,1433 in > D:\Inetpub\wwwroot\cratos\test.php on line 5 > > Server connection failed > Is INTRA_SQL your instance name or database name? If it is the instance name, is that instance setup to use 1433 as the port? I know 1433 is the default port for MSSQL, but the majority of people change that. Correct - intra_sql is the instance, yes, it's using default port 1433 (which is also specified in the php.ini file)....I've tried connecting with and without specifying the port - but both ways don't work.... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
