pyodbc adapter doesn't support host:port syntax

[Former user]

When migrating from adodbapi to pyodbc, I ran into a connection failure with the connect URL including a port number:

from sqlalchemy import * global_connect( 'mssql://localhost:1234/testdb' ) default_metadata.engine.connect()

The last statement will fail when using pyodbc, but works fine in adodbapi.

The attached patch addresses the issue and is backward compatible, allowing host,port and host:port syntax (host,port is handled the same way it currently is, where the entire string is parsed as the hostname).

[Former user]

proposed patch

[Former user]

another suggested patch to handle host,port assembly.

[Former user]

I just added a second revision to the patch (supercedes the first patch) that handles the common functionality in the parent class.

[Former user]

(original author: ram) Committed a simple fix in 2867