Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #2317

Re: mssql_connect syntax when using port muber

Show all headers | View raw

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

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

mssql_connect syntax when using port muber "chris.percol" <chris.percol@gmail.com> - 2011-06-23 09:19 -0700
  Re: mssql_connect syntax when using port muber "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2011-06-23 18:36 +0200
    Re: mssql_connect syntax when using port muber "chris.percol" <chris.percol@gmail.com> - 2011-06-24 00:56 -0700

csiph-web