Connect to SQL Server database on a specified port.

[sigurdne]

The port information is missing.
One will need to set the port - if anything else than standard.

Something like this in the function ADODB_mssqlnative::_connect()

if (!empty($this->port)) { $argHostname .= ", $this->port"; }

Regards

[dregad]

This is included in upcoming 5.21.0 release, see #314

[sigurdne]

Yes, that is true for ADODB_mssql, but I can't see it in ADODB_mssqlnative.

Regards

[dregad]

Right, sorry... So not a duplicate then.

@mnewnham as I don't use mssql, would appending the port number to the hostname before calling sqlsrv_connect() at line 493, like so, be sufficient ?

if (!empty($this->port)) {
    $argHostname .= "," . $this->port;
}

[mnewnham]

Yes, absolutely. I think I've done this before. I think I've not done anything official because unlike most connections , its server,port instead of server:port. It doesn't appear to be a widely used option either.

[mnewnham]

Will appear in 5.20.19