Click here to Skip to main content
12,403,811 members (68,501 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-server-2005 C++ SQL , +
i have a server of windows server 2003 and its IP on my local network is 192.168.1.220

this server has SOL server 2005 express edition installed with user name sa and password amir

this SQL server has a database called amir

i want to connect to it from a Linux client on the same network

SQL server service using port 1617 on my server and i used this port to connect to the server using java

now i want to use QT C++ but i tried alot but my code don't want to work

this is my code
#include <QtCore/QCoreApplication>
#include<QWidget>
#include<ostream>
#include<iostream>
#include<QFile>
#include<QTime>
#include <stdio.h>
#include <QTextStream>
#include<QSqlDatabase>
#include<QSqlDriver>
using namespace std;
 
int main(int argc, char *argv[])
{
    QCoreApplication a(argc, argv);
    QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    bool test=db.isValid();//true
    test=db.isDriverAvailable("QODBC");//true
    db.setHostName("192.168.1.220\\SQLEXPRESS");
    db.setDatabaseName("DRIVER={SQL Server};SERVER=192.168.1.220\\SQLEXPRESS:1617;DATABASE=amir");
    db.setUserName("sa");
    db.setPassword("amir");
    db.setPort(1617);
    test=db.isValid();//true
    if(!db.open())
    {
        cout<<endl<<"not connected"<<endl;
        QString error=db.lastError().text();
        cout<<error.toLocal8Bit().data();
        return false;
    }
    else
        cout<<endl<<"connected"<<endl;
         return true;
 
}


every time i try this it out "not connected"

and the error is [unixODBC][Driver Manager]Data source name not found, and no default driver specified QODBC3: Unable to connect

using this parameters i can connect using java

so what is the wrong here? and if there is another fasting way to connect to the SQL server using qt c++ than ODBC driver please tell me
Posted 29-Sep-12 22:36pm
Updated 29-Sep-12 23:23pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160721.1 | Last Updated 30 Sep 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100