9

When trying to create a new MSSQL Connection, I get an error saying: Error opening connection: Driver not loaded Driver not loaded.

Create a New MSSQL Connection dialog

I have tried both QGIS 3.8.0 and the newest pre-compiled QGIS 3.8.1 on MacOS Mojave. I am not sure how to run QGIS in a mode that might provide a better error message.

Anyone have ideas on what to change to make this work?

Improve this question

1 Answer 1

Reset to default
5

When you click "Test Connection" you get the "Driver not loaded Driver not Loaded" error at the top. However, if you ignore the Test Connection button, and instead click the "List databases" button, you will find that the connection works just fine, and the databases get listed.

I had the same issue, and was surprised nobody has answered this question yet. I had to find it buried in another question about MSSQL settings in QGIS, and it warned the user not to use the "Test Connection" button because it would not work correctly...

I found the hint not to click the Test Connection button here: MSSQL Connection settings for QGIS on Windows

Note I've created an issue on GitHub, the button should be fixed or removed: https://github.com/qgis/QGIS/issues/37177

Improve this answer
3
  • When I do this, QGIS crashes
    – Ben
    Commented Feb 18, 2021 at 23:59
  • I get the error for list Databases as well.
    – mckenzm
    Commented May 28, 2023 at 4:28
  • Since I get the error on latest QGIS (v3.36.1), I tried to reopen this issue github.com/qgis/QGIS/issues/33392
    – Cheshire Cat
    Commented Apr 10 at 9:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.