QGIS could not connect to MSSQL database

Today I was trying to connect QGIS to MSSQL database. I use Create a New MSSQL connection button and fill Connection name, Provider/DSN, Host and login credentials.

However, when I test the connection, it repeatedly saying

Error opening connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect

After searching on Google, I found that Host should be leaved blank. And, it works.

Problem : Error opening connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect

Solution : Keep Host blank

png.png

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s