QODBC plugin compile
-
Hi everyone,
Just wondering if anyone had any guidance for how to get QODBC to work inside visual studio 2008? So far I have downloaded Qt libraries 4.8.0 for Windows (VS 2008, 273 MB), and followed the online instructions for compiling the plugin, navigating to C:\Qt\4.8.0\src\plugins\sqldrivers\odbc, then running qmake odbc.pro, then nmake, however when i try to open a connection to the server I get
'Error "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified QODBC3: Unable to connect" 'Does any one have any ideas my code is as follows:
@
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC", "MyDatabase");
db.setHostName("LOCALHOST\SQLEXPRESS");
db.setDatabaseName("test");
db.setUserName("...");
db.setPassword("...");if(db.open())
{
qDebug() << "Opened";
db.close();
}else
qDebug() << "Error" << db.lastError().text();
@ -
Take a look "here":http://stackoverflow.com/questions/3060916/connection-mssql-with-qt.
Hope this helps.
-
Example of SQL Server Conection :
@
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC", "MyDatabase");db.setDatabaseName("DRIVER={SQL Server};Server="+ipserver+";Database="+database+";Uid="+LoginName+";Port=1433;Pwd="+Pass+";WSID=");
if(db.open())
{
qDebug() << "Opened";
db.close();
}
else
qDebug() << "Error" << db.lastError().text();
@the WSID =. "is used to hide the client machine to the database server log
[EDIT: code formatting, please use @-tags, Volker]