Bug #63070
closedADOdb: mssqlnative driver does not properly define the port
100%
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']);