Connection with MS SQL

[Zatraz]

You will connect to SQL Server using FreeTDS plugin with something like this:

// Note: QT4
  QSqlDatabase db = QSqlDatabase::addDatabase("QTDS7");
  db.setDatabaseName(database);
  db.setHostName(host);
  db.setUserName(user);
  db.setPassword(pass);
 
  setenv("TDSVER", "8.0", 1);
  setenv("TDSPORT", dbport, 1);  //! setPort() does not work properly
 
  if (!db.open())
  {
    qWarning("Erro opening database connection: " + db.lastError().text());
    return 1;
  }

// Note: QT4
  QSqlDatabase db = QSqlDatabase::addDatabase("QTDS7");
  db.setDatabaseName(database);
  db.setHostName(host);
  db.setUserName(user);
  db.setPassword(pass);

  setenv("TDSVER", "8.0", 1);
  setenv("TDSPORT", dbport, 1);  //! setPort() does not work properly

  if (!db.open())
  {
    qWarning("Erro opening database connection: " + db.lastError().text());
    return 1;
  }

To copy to clipboard, switch view to plain text mode 

[manish_pesit]

You will connect to SQL Server using FreeTDS plugin with something like this:

// Note: QT4
  QSqlDatabase db = QSqlDatabase::addDatabase("QTDS7");
  db.setDatabaseName(database);
  db.setHostName(host);
  db.setUserName(user);
  db.setPassword(pass);
 
  setenv("TDSVER", "8.0", 1);
  setenv("TDSPORT", dbport, 1);  //! setPort() does not work properly
 
  if (!db.open())
  {
    qWarning("Erro opening database connection: " + db.lastError().text());
    return 1;
  }

// Note: QT4
  QSqlDatabase db = QSqlDatabase::addDatabase("QTDS7");
  db.setDatabaseName(database);
  db.setHostName(host);
  db.setUserName(user);
  db.setPassword(pass);

  setenv("TDSVER", "8.0", 1);
  setenv("TDSPORT", dbport, 1);  //! setPort() does not work properly

  if (!db.open())
  {
    qWarning("Erro opening database connection: " + db.lastError().text());
    return 1;
  }

To copy to clipboard, switch view to plain text mode 

If I am using the above code then it throws an error :

QSqlDatabase: QTDS7 driver not loaded
QSqlDatabase: available drivers: QODBC3

Can you tell me from where I will get QTDS7 driver?

thanks