What are the parameters for my connection QGIS

Question

I am new QGIS, I was wondering what the parameters are for the New MSSQL Connection in the dialog window?

Provider/DNS: ? when local ? tried leaving empty

Host: ? when local ? tried my computer user name/server instance name

Database: full path to file I assume

Dialog Window

Error:

Error

provider blank and host as localhost = invalid connection error — DonA, Commented Sep 11, 2014 at 19:18
lat/long, address, plus other stuff i hope to be able to ignore — DonA, Commented Sep 11, 2014 at 19:35

Community · Accepted Answer · 2017-04-13 12:33:59Z

2

Looking at the QGIS help for another type of "New Database Connection" showed these

Name = A name to identify the connection settings.

Provider/DSN = The database server IP address or DNS name (not sure about this I got this from http://tinyurl.com/kjpqm6k)

Host = Name or IP address of the computer hosting the database server (leave blank for local connections)

Database = Name of the database (leave blank for default database on server).

Username = Database user name.

Password = Database password.

enter image description here

EDIT: In this question Mapperz says "Provider/DSN parameters not needed if you have a host."

CommunityBot

1

answered Sep 11, 2014 at 19:38

landocalrissian

2,1461 gold badge14 silver badges27 bronze badges

My free version would not allow the help function.
– DonA
Commented Sep 11, 2014 at 19:47
I tried clicking the help for the MSSQL but it said there wasn't one written yet so I just got the help for another type. QGIS 2.4
– landocalrissian
Commented Sep 11, 2014 at 19:51
Still not sure what goes in the provider/DNS for a local Db, left host blank, and supplied the full file path
– DonA
Commented Sep 11, 2014 at 19:53
1

This is what a working one should look like i.imgur.com/8yc3x9G.png
– Nathan W
Commented Sep 11, 2014 at 22:32
1

@ChrisR can add the image to this answer. It was here first.
– Nathan W
Commented Sep 12, 2014 at 2:45

| Show 2 more comments

1 Answer 1