Bug report #6259

Сan not connect to MSSQL Server with FreeTDS driver

Added by Evgeniy Nikulin about 8 years ago. Updated about 8 years ago.

Status:Closed
Priority:Normal
Assignee:Tamas Szekeres
Category:Data Provider/MSSQL
Affected QGIS version:master Regression?:No
Operating System:Linux Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:15565

Description

If on create a MSSQL connection not specify DSN and enter the server settings manually, the connection is not working. By default will be selected FreeTDS driver. But the driver does not work if the port is not specified! On connection ODBC throw exception.
If create DSN with explicit port specified, connection will be working.
So there is no way to specify the port to connect for Windows version of QGIS.
IMHO need additional field for connection from - Port, with default value 1433.

Associated revisions

Revision c322cd52
Added by Tamas Szekeres about 8 years ago

Specify port 1433 for FreeTDS by default. Allow to specify server/database/uid/password when the driver setting is present (fixes #6259, fixes #6263)

History

#1 Updated by Nathan Woodrow about 8 years ago

  • Assignee set to Tamas Szekeres

#2 Updated by Tamas Szekeres about 8 years ago

  • Status changed from Open to Closed

#3 Updated by Tamas Szekeres about 8 years ago

Tamas Szekeres wrote:

Fixed in changeset c322cd52cf82afeb10beefa6efa42da2bdcea46f.

Port setting is now specified by default

Also available in: Atom PDF