1000th topic!!

[kenneth]

This isn't spam though, because I have a very serious question.

When I try doing a mssql connection to our mssql server on the web-hosting machine(s), it does not work. This is a code example:

Code: Select all

<?php
echo "Testing NFO-Server's mssql server connection function....";
$connection = mssql_connect("96.31.75.130,1403","sa","*Removed*");
if(!$connection)
{
	echo "<br />Failed to connect.";
}
else
{
	echo "<br />Successfully connected.";
}
echo "<br />Test has been completed.";
?>

here is a example of hosted1 box:
http://cool.site.nfoservers.com/test.php

here is a example of hosted2 box:
http://boutcheetah.zylongaming.com/test.php

(the above does not work)
this one does(not hosted on nfo web-hosting)
http://96.31.75.130/test.php

[Edge100x]

MSSQL should be supported here (otherwise your script would be failing in a different way, actually). That means that we have to look at possible connection (firewall) and MSSQL server-side concerns. Are you restricting connections by IP address on that end?

[kenneth]

nope, I can connect to it on my pc with navicat

[kenneth]

Problem resolved.

Many thanks Vanderburg.

(The problem was the comma, aparantly it is depreciated in php 5 or something.)

Also, thank you too edge, just cuz you edge