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?

  6. Great and useful article. Creating content regularly is very tough.Thanks you.Write more and visit site

  7. It’s time to watch UFC 249 live stream online without TV cable right? This article will help you to watch Khabib vs Ferguson fight online without tv from anywhere. UFC lightweight champion Khabib Nurmagomedov Watch UFC 249 online will defend former UFC interim champion Tony Ferguson at the Barclays Center in Brooklyn, New York, April 18, 2020.

  8. I wonder how you became so capable to write such interesting and informative articles, anyway you are one of the best blogger in my eyes, Keep it up. computer network assignment help

  9. Are you checking for definite data identified with quickbooks mistake then you can go through this article to have nitty gritty data in regards to quickbooks startling outcome 5quickbooks unexpected error 5: A QBs Repairing Guide

  10. The quickbooks unrecoverable error
    can occur at any time for QuickBooks Desktop users. Your desktop may display this error when you attempt to open QuickBooks. When trying to view the QuickBooks Desktop Database Server Manager, this may also happen.

  11. I truly love your site.. Great colors & theme.
    Did you make this amazing site yourself? Please reply
    back as I’m hoping to create my own personal website and would love
    to know where you got this from or just what the theme is called.
    Many thanks!

  12. However I wish to say that this write-up very compelled me to take a look at and do it! Your writing taste has been surprised me. Thank you

  13. Spot on with this write-up, I absolutely believe that this website needs a lot more attention. I’ll probably be returning to read more, thanks for the advice!

  14. An intriguing discussion may be worth comment. I’m sure you should write much more about this topic, may well be described as a taboo subject but generally folks are too little to chat on such topics. An additional. Cheers 토토사이트