Bug report #6259
Сan not connect to MSSQL Server with FreeTDS driver
| 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
History
#1
Updated by Nathan Woodrow over 11 years ago
- Assignee set to Tamas Szekeres
#2
Updated by Tamas Szekeres over 11 years ago
- Status changed from Open to Closed
Fixed in changeset c322cd52cf82afeb10beefa6efa42da2bdcea46f.
#3
Updated by Tamas Szekeres over 11 years ago
Tamas Szekeres wrote:
Fixed in changeset c322cd52cf82afeb10beefa6efa42da2bdcea46f.
Port setting is now specified by default