Hi List -
I am working on a plugin that's is using for connections
(QgsAbstractDatabaseProviderConnection) to several types of databases,
including Postgres, GeoPackage and MS SQLServer.
I was hoping to use the method "createSqlVectorLayer
<https://api.qgis.org/api/classQgsAbstractDatabaseProviderConnection.html#a2c6e55db0df105012f0936c84df0b14d>"
for converting some fairly complex SQL queries into QGIS vector layers.
This works super nice for Postgres and GeoPackage. However the current
version (QGIS 3.26) doesn't support this method for MS SQLServer. As
illustrated in this piece of code:
conns =
QgsProviderRegistry.instance().providerMetadata('mssql').connections(False)
conn = conns['geodata @ localhost'] # SQL server connection
capabilities = conn.capabilities()
print(bool(capabilities & QgsAbstractDatabaseProviderConnection.SqlLayers))
The last statement shows "False" for MS SqlServer connections,
indicating the missing functionality. (QGIS ver. 3.26 or older)
My first question is: Has there been done any work on this for MS SQL
Server connections in QGIS master (next version) ?
The second question: Is it possible for someone in the group of Core
developers to provide me with a ballpark figure for implementing the
missing functionality for the mssql driver ??
To be specific: get method "createSqlVectorLayer
<https://api.qgis.org/api/classQgsAbstractDatabaseProviderConnection.html#a2c6e55db0df105012f0936c84df0b14d>"
to work for MS SQL Server connections.
If somebody steps up to the challenge I will send the information to my
customers so they can consider making QGIS better instead of paying me
for an ugly workaround.
Med venlig hilsen / Kind regards
Bo Victor Thomsen
_______________________________________________
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
