| 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:
|
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
]