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();
    @





  • 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]



  • Thanks very much guys using your two responses i was able to fix my problem.


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.