Friday, March 23, 2012

QGIS MS SQL provider has been added

Thanks to the support of Digital Mapping Solutions, Nathan Woodrow and I have now added the new native MS SQL provider in the QGIS mainstream. The new provider now supports full featured read-write access to the MS SQL databases. By using the dragdrop support in the browser window you can easily push layers up to the database. The driver creates fully registered layers (by adding entries to the spatial_ref_sys and geometry_columns metadata tables) which are compatible with the GDAL MSSQL driver as well (to take advantage of the author being the same :-). In the heat of the work we have also enabled the dragdrop upload capability for the PostGIS provider.
We encourage you to give it a try and let us know if you find issues, by adding an entry to the QGIS issue tracker.


  1. Very nice and useful addon. Many thanks to You and Nathan.


  2. Hey Tamas,

    Great blog!

    I was wondering if you would you be interested in sharing your articles with other like- minded people in the API and dev industry. We are building an online community containing links to informative articles about mobile & web apps, software dev, LBS & geo topics, hack events etc.

    If you are interested and want to learn more about this, please send an email to


  3. That works fine with geometry tables, but I got problem with geography objects, there aren't displays.

    Is it a limitation ?


    1. There have been a couple of fixes for the driver in the recent time. I wonder if things would work with the latest version

  4. Trying out this in QGIS 2.0.1 but getting error message "Driver not loaded Driver not loaded". I'm running QGIS 2.0.1 in Ubuntu 12.10, should it work in that environment or does it need Windows?

    1. I'm personally not familiar in the set up of the driver on Linux, you might want to contact with Nathan Woodrow who has tested the code on Linux specifically. You should anyway require an ODBC driver to be installed on your system first.

  5. I've heard that the iPhone 8 is going to be a game changer because it's release will mark iPhone's 10th anniversary. Really can't wait for the phone to roll out this September. My only concern is the price, that is rumored to go above $1000. Do you know about iPhone 8 Release Date?