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:
- db.setHostName("LOCALHOST\\SQLEXPRESS");
- db.setDatabaseName("test");
- db.setUserName("...");
- db.setPassword("...");
- if(db.open())
- {
- qDebug() << "Opened";
- db.close();
- }
- else
- qDebug() << "Error" << db.lastError().text();
3 replies
Example of SQL Server Conection :
- 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]
You must log in to post a reply. Not a member yet? Register here!