PDA

View Full Version : Accessing Microsoft SQL server 2005



yuvarajragupathi
11th October 2010, 16:05
HI All,

I am trying to connect Qt application with MS sql server 2005 with below code


QSqlDatabase database = QSqlDatabase::addDatabase("QODBC3");
database.setDatabaseName("DRIVER={SQL Server};SERVER=ITDPC\SQLEXPRESS;DATABASE=MTA;UID=s a;PWD=1;");

if(!database.open())
{
qDebug() << database.lastError().text();
QMessageBox::information(0,"","DataBase Init Failed\n");
return 1;
}
else
{
return 0;
}


But i am getting error

"[Microsoft][ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found. [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). QODBC3: Unable to connect"

My Data source name is Addu. refer attached screen shot images

Please help to connect Qt application with MS Sql server.

Thanks

Yuvaraj

jpujolf
28th October 2010, 13:20
Perhaps changing \ to \\ or / in DatabaseName ?


QSqlDatabase database = QSqlDatabase::addDatabase("QODBC3");
database.setDatabaseName("DRIVER={SQL Server};SERVER=ITDPC\\SQLEXPRESS;DATABASE=MTA;UID= sa;PWD=1;");


In C++ \ is an escape character...