I connect it from my program.
I solve it. It must be
static bool createConnection
(QString driver
= "QODBC",
QString connectionstr
="DRIVER={SQL Server Native Client 10.0};" "Server=IP\\Instance;Trusted_Connection=yes;"
"Database=Databasename;Uid="";Pwd="";"
)
{
db.setDatabaseName(connectionstr);
if (!db.open()) {
return false;
}
return true;
}
static bool createConnection(QString driver= "QODBC",
QString connectionstr="DRIVER={SQL Server Native Client 10.0};"
"Server=IP\\Instance;Trusted_Connection=yes;"
"Database=Databasename;Uid="";Pwd="";"
)
{
QSqlDatabase db = QSqlDatabase::addDatabase(driver);
db.setDatabaseName(connectionstr);
if (!db.open()) {
QSqlError err = db.lastError ();
QMessageBox::information(0, QObject::tr("Cannot open database"), err.text());
return false;
}
return true;
}
To copy to clipboard, switch view to plain text mode
And you have to install the native sql client.
Yes I use Qt4.5.0 ans compile it with the ODBC flag etc..
thanx
Bookmarks