MSSQL Server - tables are invalid layers for Build 116

[qgib]

Author Name: Carlos da Ponte (Carlos da Ponte)
Original Redmine Issue: 5407
Affected QGIS version: master

Assignee: Tamas Szekeres

---

All tables imported fine using build 115. Updated to build 116, tried to import the same layers and all (~20 layers) yield error msg - "dbname='XX' host=XXX,1433 user='synergy' password='XXXXXX' srid=3005 type=POINT table="dbo"."site" (geolocation) sql= is an invalid layer and cannot be loaded"

---

Related issue(s): #15074 (relates), #15075 (relates)
Redmine related issue(s): 5409, 5410

---

[qgib]

Author Name: Nathan Woodrow (@NathanW2)

---

This is a problem with the host name getting passed to the provider. Tamas is working on a fix.

As a workaround you can create a ODBC DSN and use it. It still workes correctly with a DSN.

[qgib]

Author Name: Nathan Woodrow (@NathanW2)

---

• assigned_to_id was configured as Tamas Szekeres

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Fixed in changeset "e5d97f53e29c90b5b8d695c604e2540f2f499070".

---

• status_id was changed from Open to Closed