Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- mssql_connect syntax when using port muber
June 23, 2011, 4:19 pm
rate this thread
I have a cron job successfully querying a random mssql database from
numerous servers using php cli (5.3.2) in conjunction with openvpn.
Connection strings are in the form of ip\instance. The one case where
the script doesn't work is for mssql instances that are on the other
side of an iptables box and the port number is required.
This same connection string works fine in sql management studio,
'192.168.1.1\instance_name,10000' but not as part of mssql_connection
in my script.
$link = mssql_connect('192.168.1.1\instance_name,10000', user, pass);
Anyone any thoughts as to why this isn't working when including a
June 23, 2011, 4:36 pm
Re: mssql_connect syntax when using port muber
Some guessing... The PHP manual says that «[the MSSQL] is not available
anymore on Windows with PHP 5.3 or later.» so you must be using Linux:
In that case, you are not using the the syntax described in the manual:
resource mssql_connect ([ string $servername [, string $username [,
string $password [, bool $new_link = false ]]]] )
The MS SQL server. It can also include a port number, e.g.
hostname:port (Linux), or hostname,port (Windows).
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com