| Re: mssql_connect syntax when using port muber [message #174641 is a reply to message #174640] |
Thu, 23 June 2011 16:36   |
alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma:
|
Senior Member |
|
|
El 23/06/2011 18:19, chris.percol escribió/wrote:
> 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
> port?
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:
http://es2.php.net/manual/en/intro.mssql.php
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 ]]]] )
servername
The MS SQL server. It can also include a port number, e.g.
hostname:port (Linux), or hostname,port (Windows).
http://es2.php.net/manual/en/function.mssql-connect.php
--
-- 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
--
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]