| mssql_connect syntax when using port muber [message #174640] |
Thu, 23 June 2011 16:19  |
Chris Percol
Messages: 5
Registered: November 2010
Karma: 0
|
Junior Member |
|
|
Hi,
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?
Many thanks,
Chris
|
|
|
|
| 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: 0
|
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
--
|
|
|
|
| Re: mssql_connect syntax when using port muber [message #174658 is a reply to message #174641] |
Fri, 24 June 2011 07:56 |
Chris Percol
Messages: 5
Registered: November 2010
Karma: 0
|
Junior Member |
|
|
On Jun 23, 5:36 pm, "Álvaro G. Vicario"
<alvaro.NOSPAMTH...@demogracia.com.invalid> wrote:
> 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
> --
Álvaro,
Thank you for your detailed answer to my question.
I had looked at mssql_connect examples in the manual but not read the
contents properly, missing hostname: port (Linux).
Thanks again,
Chris
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]