Access Exsisting MSSQL databasse

[deepal_de]

How can i get data from existing MSSQL database to a Qt applicaion.. im using sql with Qt for the first time....so
if u can,please include a complete example code.. thanks

[mcosta]

You have to use a QODBC driver.

for example code see the official documentation

[deepal_de]

WebDataBase is a DB thats in my MSSQLEXPRESS sever..

QSqlDatabase qDb = QSqlDatabase::addDatabase("QODBC");
	qDb.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=WebDataBase.mdb");
	if (qDb.open()) 
	{
		QMessageBox::information(NULL,"Message", "DB open");
	}
	else
	{
		QMessageBox::information(NULL,"Message", "DB close");
	}

QSqlDatabase qDb = QSqlDatabase::addDatabase("QODBC");
	qDb.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=WebDataBase.mdb");
	if (qDb.open()) 
	{
		QMessageBox::information(NULL,"Message", "DB open");
	}
	else
	{
		QMessageBox::information(NULL,"Message", "DB close");
	}

To copy to clipboard, switch view to plain text mode 

this doesn't work!
how to chage the "qDb.setDatabaseName" to work with MSSQLEXPRESS

[mcosta]

I never used MSSQL,

however you have to set a correct ODBC configuration string (you used a Access Driver)

I found this

"Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"

"Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;"

To copy to clipboard, switch view to plain text mode