I am using QGIS with SQL server 2008. I need to save project on one computer and then copy project to another 20 clients!

After I save project and try to open it on another computer I am getting error. HANDLE BAD LAYERS

How I can setup project that can be used on another computer?

  • 1
    i think it uses odbc connection, so you need to have System odbc connection with same name in other computer – simplexio Mar 4 '14 at 14:31
  • Question , how your QGIS + MS SQL is working . My 32bit worked ok for a while , then some strange problems and my 64 bit installation didn't work at all with 2008R2 – simplexio Mar 5 '14 at 8:24

Good question. You need to add the database connection to each computer. Unfortunately this is stored as a registry setting (see the MSSQL section in the image below).

But you can script the installation of registry settings, so if you roll our QGIS to many computers somehow, include the registry settings for the QGIS database connections. The way I have them set up it uses the ODBC connection, so you'll need to script up that too.

I have an example of a registry script for installing ODBC connections for SQL Server, which is here: https://gist.github.com/alexgleith/9358893#file-sqlservergisdatabase-reg.

registry setting

  • I would be interested in seeing this Alex, can you post it? Hope you are well! – Morgan Ellingham Mar 4 '14 at 22:28
  • 1
    Hi Morgan, I added a link. Let me know if it doesn't make sense. – Alex Leith Mar 5 '14 at 0:38
  • Love your work, should come in handy! – Morgan Ellingham Mar 5 '14 at 1:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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