Issue Bug Closed

#63070ADOdb: mssqlnative driver does not properly define the port

Manuel Schneider 11/19/14, 14:50 updated 10/02/18, 11:49

Description

One of our extension has a depency on the adodb extension.

This extension connect to a mssql (Microsoft SQL 2005) server. If the connection use the default port (1433) there is no problem. But my dns string look like this:
@mssql://user:password@192.168.1.1:12345/databasename@

After I try to connect I get an error with the message

> coult not connect to server 192.168.1.1 ….

The port is missing. After a little debugging I found the bug. In file typo3/sysext/adodb/adodb/adodb.inc.php on line 4378 the adodb class try to connect with the function $this->Connect

$ok = $obj->Connect($dsna['host'], $dsna['user'], $dsna['pass'], $dsna['path']);

As you can see the port is missing, after inserting the port it works

$ok = $obj->Connect($dsna['host'] . ':' . $dsna['port'], $dsna['user'], $dsna['pass'], $dsna['path']);

Reviews 2