Specify port 1433 for FreeTDS by default. Allow to specify server/database/uid/password when the driver setting is present (fixes #6259, fixes #6263)

szekerest · szekerest · commit c322cd52cf82 · 2012-09-03T11:01:10.000+02:00
diff --git a/src/providers/mssql/qgsmssqlprovider.cpp b/src/providers/mssql/qgsmssqlprovider.cpp
@@ -214,19 +214,20 @@ QSqlDatabase QgsMssqlProvider::GetDatabase( QString driver, QString host, QStrin
 #ifdef WIN32
     connectionString = "driver={SQL Server}";
 #else
-    connectionString = "driver={FreeTDS}";
+    connectionString = "driver={FreeTDS};port=1433";
 #endif
-    if ( !host.isEmpty() )
-      connectionString += ";server=" + host;
+  }
 
-    if ( !database.isEmpty() )
-      connectionString += ";database=" + database;
+  if ( !host.isEmpty() )
+    connectionString += ";server=" + host;
 
-    if ( password.isEmpty() )
-      connectionString += ";trusted_connection=yes";
-    else
-      connectionString += ";uid=" + username + ";pwd=" + password;
-  }
+  if ( !database.isEmpty() )
+    connectionString += ";database=" + database;
+
+  if ( password.isEmpty() )
+    connectionString += ";trusted_connection=yes";
+  else
+    connectionString += ";uid=" + username + ";pwd=" + password;
 
   if ( !username.isEmpty() )
     db.setUserName( username );
