I have created a php website which is linked to two mssql databases,
i want to keep one of these databases on my local server and put the other onto the webserver
The code below will work fine for the database on the webserver, but what changes do i have to make to this to be able to access the database that is on my local server?
also, is there any changes (security etc) i have to make on my network or to sql server to allow the website to gain access to it?
I'm only a beginner in php so please explain
$myServer = "server";
$myUser = "user";
$myPass = "pass";
$myDB = "websitedatabase";
$dbhandle = mssql_connect($myServer, $myUser,$myPass) or die("Could not connect to server");
$selected = mssql_select_db($myDB, $dbhandle) or die("Could not open Database");