connecting to SQL Server in qgis-dev
Barrett Higman
Hi all,
Just wondering if anyone else has trouble connecting to SQL Server 2008 in the QGIS development build?
I have no issues when using 1.8 but with exactly the same credentials in 1.9 I get the following message:
Is it a k known issue? Have I not downloaded everything that I need?
Cheers,
Barrett
Barrett Higman
GIS Officer
Alpine Shire Council
Nathan Woodrow
--
You received this message because you are subscribed to the Google Groups "Australian QGIS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to australian-qgis-use...@googlegroups.com.
To post to this group, send an email to australian-qg...@googlegroups.com.
Visit this group at http://groups.google.com/group/australian-qgis-user-group?hl=en-GB.
For more options, visit https://groups.google.com/groups/opt_out.
Barrett Higman
For everyone else here is the solution (thanks Nathan!)...
J
The connect dialog is a bit dumb. This is the logic the driver takes:
· Is the provider/DSN supplied
o Yes
§ ConnectionString = DSN
o No
§ ConnectionString = server=host;database=database
I’ll put it on the todo list for 2.1 cleanup.
Note: You can also put a full connection string in the provider/DSN box, so something like driver={SQL Server};server=”balh”;database=’test’ but I would advise against that.
Regards,
Nathan
From: Barrett Higman [mailto:barr...@alpineshire.vic.gov.au]
Sent: Friday, June 07, 2013 8:51 AM
To: Nathan Woodrow
Subject: RE: connecting to SQL Server in qgis-dev
Ok... you need to explain why that worked :)
Barrett Higman
GIS Officer
Alpine Shire Council
From: Nathan Woodrow
Sent: Friday, 7 June 2013 8:50 AM
To: Barrett Higman
Subject: RE: connecting to SQL Server in qgis-dev
Try removing the host bit.
From: Barrett Higman
Sent: Friday, June 07, 2013 8:47 AM
To: Nathan Woodrow
Subject: FW: connecting to SQL Server in qgis-dev
Hi Nathan,
This is exactly the same as 1.8 but shows that error message when I hit OK.
I have tried putting in the systems admin user name and password instead of making it a trusted connection but that doesn't work, I have also played around with some of the other settings with no luck. The DSN is listed in both the 64bit and 32bit ODBC Administrator consoles (my machine is 64bit).
Let me know if you have any brainwaves!
Cheers,
Barrett
Barrett Higman
GIS Officer
Alpine Shire Council