Hi Everyone,

I need to establish a connection to a SQL Server instance, but all I have access to is the IP Address (+ user name and all that stuff). Can anyone help me construct the mssql_connect statement using the IP Address, if this is possible.

Thanks

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

Hi!!

Try this...

<?php
$con = mssql_connect ("<ip of the server SQL>", "sa", "");
mssql_select_db ("<Data Base>", $con);
$sql= "SELECT * FROM <Table>";
$rs= mssql_query ($sql, $con);
echo "The field number one is: ";
echo mssql_result ($rs, 0, 0);
mssql_close ($con);
?>


For more help check out here

http://us3.php.net/mssql

-------
Thanks,
Umesh