Page 1 of 1

MSSQL Remote Connection with PHP

Posted: Sat Oct 02, 2010 4:42 pm
by mssqlphp
Hi guys,

ROOT 1 DEDICATED SERVER: Holds WEBSITE (running on ISS) and database (1)
ROOT 2 DEDICATED SERVER: Holds database (2)

Im trying to get my website to connect to database (2) on root 2 dedicated server, they are both on the same internal network but I cant seem to connect to the database correct.

The code works fine on root 1 connecting to database (1) , heres config I use to connect to root 2:

define(sql_host,'STEAMCOST-1983');
define(sql_user,'sa');
define(sql_pass,'password');
define(sql_db,'GAME_DBF');

Can anyone help, would using odbc connection be better and easier?