PDA

View Full Version : Error on QODBC



METEOR7
11th January 2012, 11:31
Hi Everyone

I Get Error in ODBC when i open connect To DataBase
Error:


[Microsoft][ODBC Driver Manager] Data Source Name Not Found and No Default Driver
specified QODBC3: Unable To Connect


and I Used This Code:


QString servername="LOCALHOST\\SQLEXPRESS";
QString dbname="Test";
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setConnectOptions();
QString dsn=QString("Driver=(SQL Native Client);SERVER=%1;DATABASE=%2;Trusted_Connection=Y es;").arg(servername).arg(dbname);
db.setDatabaseName(dsn);
if(db.open())
{
QMessageBox::about(this,"","OK");
}
QMessageBox::about(this,"",db.lastError().text());


Thanks

pkj
11th January 2012, 16:12
Have you installed your server with a named instance, instance being SQLEXPRESS? if not try..


QString serverName = "localhost";
QString dbName = "Test";

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
QString dsn = QString("DRIVER={SQL Native Client};SERVER=%1;DATABASE=%2;UID=sa;PWD=;").arg(serverName).arg(dbName);

db.setDatabaseName(dsn);

db.open();

METEOR7
11th January 2012, 19:44
I Change Instance
And I Trying Change Code
But This Error Love Me