I have been supplied...
Server IP Address
username
password
port number
database name
from looking throught the php.net i am more confused lol...a lot of posts mention the php_dblib.dll or php_mssql.dll files missing?
What does this mean? does it mean i need to contact the webhost where the script is running from and tell them to add these file to the php.ini?
Anyway, my script is as follows...
Code: Select all
<?php
$myServer = "xx.xxx.xx.xxx:1433";
$myUser = "xxx";
$myPass = "xxxx";
$myDB = "xxxxxx";
// 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");
echo "You are connected to the " . $myDB . " database on the " . $myServer . ".";
// close the connection
mssql_close($dbhandle);
?>
ANY IDEAS?