[Qgis-user] Provider errors: [Microsoft][ODBC SQL Server Driver]Communication link failure QODBC3: Unable to execute statement

[Henrik Mentz]

Hi,

I have a problem when I use Qgis together with a hosted SQL database.

I'm using Windows 10
My Qgis version is 3.16.16-Hannover
My SQL server is hosted by Microsoft Azure
I attach the information from my Qgis about window

I have several layers connected to the SQL database and from when I open Qgis everything is working fine. I can read and write new data to the database. After some time I cant write to the database anymore and I get the attached error message. The error has been present from when I began to use Azure SQL to store my Qgis data in.

After reading some articles I thought it was caused when the computer went into sleep mode. I the turned off automatic sleep mode but the error came back.

Hope someone can help - thanks in advance.


Best regards

Henrik Mentz
Mobil: +45 20466027

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220911/044747e6/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Azure connection error.PNG
Type: image/png
Size: 11311 bytes
Desc: Azure connection error.PNG
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220911/044747e6/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Qgis about dump.PNG
Type: image/png
Size: 26464 bytes
Desc: Qgis about dump.PNG
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220911/044747e6/attachment-0003.png>