Click here to Skip to main content
Rate this: bad
good
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
Edited 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
0 OriginalGriff 358
1 Sergey Alexandrovich Kryukov 239
2 MT_ 175
3 Yogesh Kumar Tyagi 165
4 ChauhanAjay 156
0 Sergey Alexandrovich Kryukov 6,205
1 OriginalGriff 5,333
2 CPallini 2,473
3 Richard MacCutchan 1,617
4 Abhinav S 1,530


Advertise | Privacy | Mobile
Web01 | 2.8.140814.1 | Last Updated 30 Sep 2012
Copyright © CodeProject, 1999-2014
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