Bug report #16716

QGIS MSSQL connection creation issue

Added by Jerome Anthony over 7 years ago. Updated about 7 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Data Provider/MSSQL
Affected QGIS version:2.18.1 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:No Copied to github as #:24615

Description

I am on OSX (mac)

I have created a DSN using iODBC Administrator.

When I try to create a MSSQL layer using the DSN connection, the connection times out with the attached prompt.

If anyone has any useful documentation on how to configure a MSSQL connection, appreciate it a lot.

Thanks for QGIS

qgis-error.jpeg (119 KB) Jerome Anthony, 2017-06-16 10:05 AM

Screenshot_20170616_092826.png (22.5 KB) Giovanni Manghi, 2017-06-16 10:28 AM

qgis-error-connect.jpeg (74.9 KB) Jerome Anthony, 2017-06-16 10:45 AM

qgis-mssql-gibberish.jpeg (90.3 KB) Jerome Anthony, 2017-06-16 10:52 AM

Related issues

Related to QGIS Application - Bug report #16718: QGIS MSSQL Layer creation error in OSX Closed 2017-06-18

History

#1 Updated by Giovanni Manghi over 7 years ago

Use the native MSSQL provider that QGIS has. See attached image.

#2 Updated by Jerome Anthony over 7 years ago

  • Status changed from Closed to Reopened

Hi Giovannie,

I am still getting errors, and it's not very obvious on how to proceed further

#3 Updated by Jerome Anthony over 7 years ago

Image attached

#4 Updated by Jerome Anthony over 7 years ago

Attached the image with gibberish in error message

#5 Updated by Jerome Anthony over 7 years ago

Giovanni Manghi wrote:

Use the native MSSQL provider that QGIS has. See attached image.

I am using this one

#6 Updated by Giovanni Manghi over 7 years ago

  • Status changed from Reopened to Closed

Jerome Anthony wrote:

Image attached

in "host" use the IP address or host name of the server, you don't need to create a DSN with ODBC and use it. QGIS connects natively and directly to mssql server.

#7 Updated by Giovanni Manghi over 7 years ago

Jerome Anthony wrote:

Attached the image with gibberish in error message

could you please try an see if it happens also on Windows or Linux?
in any case this would be a separate issue and needs a separate ticket.

#8 Updated by Jürgen Fischer over 7 years ago

#9 Updated by Mick Collopy about 7 years ago

I have no trouble connecting to MSSQL from Windows desktop but Linux (Ubuntu) desktop produces 'driver not laoded' error.
There's an issue for that #16718

Also available in: Atom PDF