У кого есть доступ в Issue Tracker, добавьте, пожалуйста, ошибку, можно сюда
The same problem.
SQL:
---------------------------
SELECT *
INTO test
FROM
(
SELECT 1 ID, geometry::Parse('LINESTRING (37.5213796 47.1254473, 37.5234009 47.1251464, 37.5236238 47.1251132)') Geo
UNION ALL
SELECT 2, geometry::Parse('LINESTRING (37.5131171 47.1227004, 37.5119065 47.122804, 37.5114139 47.1229543, 37.5108024 47.1232576, 37.5101528 47.1235379, 37.5097069 47.1237922, 37.5088067 47.12424, 37.5074309 47.1249825, 37.5073969 47.1250345, 37.5073969 47.1251154, 37.5074691 47.1251963, 37.5102037 47.1279814, 37.5103055 47.1281257)')
) q
INSERT INTO [geometry_columns]
([f_table_catalog]
, [f_table_schema]
, [f_table_name]
, [f_geometry_column]
, [coord_dimension]
, [srid]
, [geometry_type])
VALUES
('mydb'
, 'dbo'
, 'test'
, 'Geo'
, 2
, 4326
, 'LINESTRING')
---------------------------
Connection:
---------------------------
<!DOCTYPE connections>
<qgsMssqlConnections version="1.0">
<mssql port="1433" saveUsername="false" savePassword="false" sslmode="1" service="" host="localhost" database="mydb" name="test" estimatedMetadata="true"/>
</qgsMssqlConnections>
---------------------------
error message:
---------------------------
Invalid Layer
---------------------------
dbname='mydb;tables=test(Geo)' host=localhost srid=4326 type=Line table="dbo"."test" (Geo) sql= is an invalid layer and cannot be loaded.
---------------------------
OK
---------------------------