PHP & MSSQL. Script Problem, Works on localhost but not online

Lucas · #1 (**permalink**) 10-03-04, 01:45 PM

I have a PHP website running on localhost with MSSQL and it can be accessed through the web with no problems, works fine and everything. BUT when I put the website on the web so it just connects to the MSSQL in my computer and everything else run from the web so it does not take so much bandwidth and resources it gives this error: "Fatal error: Call to undefined function: mssql_connect() in /home/musource/public_html/config.php on line 47".

The config files refers to this line: //Database Connection

$msconnect=mssql_connect("$host","$alogin","$apass ") or die ("We seem to be having problems with MSSQL Server. We Should be back shortly.");
$msdb=mssql_select_db("$db",$msconnect) or die("We seem to be having problems with MSSQL Database. We should be back shortly.");

Help is appriciated.

moronovich · #2 (**permalink**) 10-03-04, 02:12 PM

Ask your host whether they have enabled mssql extension or not.

Lucas · #3 (**permalink**) 10-03-04, 02:34 PM

Awww, thanks, it was that, but no, they do not allow remote database connections, oh well, thanks anyways.