Hello friends,
I try to connect to a ms sql 2005 database. So I first try to use the QODBC driver ( QtSQL).
Here is my Code:
#include <QtGui>
#include <QtSql>
#include <QDebug>
int main(int argc, char* argv[]) {
db.setHostName("localhost");
db.setDatabaseName("ExapleDB");
db.setUserName("Admin");
db.setPassword("admin");
if (!db.open()) {
return 1;
}
// --- Alle Daten abfragen ---
model.setTable("Artikel");
model.select();
tableView.setModel(&model);
tableView.setWindowTitle("SQL-Demonstration");
tableView.show();
return app.exec();
}
#include <QtGui>
#include <QtSql>
#include <QDebug>
int main(int argc, char* argv[]) {
QApplication app(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setHostName("localhost");
db.setDatabaseName("ExapleDB");
db.setUserName("Admin");
db.setPassword("admin");
if (!db.open()) {
QSqlError err = db.lastError ();
QMessageBox::information(0, QObject::tr("Fehler"), err.text());
return 1;
}
QTableView tableView;
QSqlTableModel model;
// --- Alle Daten abfragen ---
model.setTable("Artikel");
model.select();
model.setEditStrategy(QSqlTableModel::OnFieldChange);
tableView.setModel(&model);
tableView.setWindowTitle("SQL-Demonstration");
tableView.show();
return app.exec();
}
To copy to clipboard, switch view to plain text mode
I search for the Driver QODBC but I d´ont find it. I have install Qt by the installer 4.3.1.
Than I read the Docu and I read this
Note: You should use native drivers in preference to the ODBC driver where they are available. ODBC support can be used as a fallback for compliant databases if no native drivers are available.
First: Where can I found a native Driver for MS Sql 2005?
Second: How can I install the QODBC driver, because in the standard installation I have only the qsqlite4.dll?
Bookmarks