connect to sql server

[raphaelf]

Hi Dimitri.
I have installed QT4.1.1 not from binary..from the exe file

My output of QSqlDatabase::drivers() is: QODBC, QODBC3, QSQLITE

My last Post was a example for QT3 thats why QODBC3...

Example SQL Browser show me QSQLITE and QODBC and not QODBC3

[wysota]

Do you get any messages from Qt? What exactly happens?

[raphaelf]

hi,
with following code i ca not read the message complete, but it say something about Error on connecting user "sa". Reason: no security SQL Server connection..

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("localhost");
         db.setDatabaseName("DRIVER={SQL Server};SERVER=localhost;DATABASE=inventar;UID=sa;PWD=raphaelf");
        db.setUserName("sa");
        db.setPassword("raphaelf");
        if(!db.open()){
	QMessageBox::information(this,"",db.lastError().text());
	return false;
    }
 	return true;

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("localhost");
         db.setDatabaseName("DRIVER={SQL Server};SERVER=localhost;DATABASE=inventar;UID=sa;PWD=raphaelf");
        db.setUserName("sa");
        db.setPassword("raphaelf");
        if(!db.open()){
	QMessageBox::information(this,"",db.lastError().text());
	return false;
    }
 	return true;

To copy to clipboard, switch view to plain text mode 

If i try like following i get this error: Data Source Name not found and no default driver specified QODBC3 : Unable to connect

..
 db.setDatabaseName("inventar");
..

..
 db.setDatabaseName("inventar");
..

To copy to clipboard, switch view to plain text mode 

[wysota]

So the problem lies not in Qt or your application but in the database engine configuration. Try to connect with a different user, MS SQL may have non-secure connections for "sa" (system-admin) user disabled.

[sungaoyong]

/************************************************** ******
**连接sqlserver
**
************************************************** *******/
bool UpgradeWizardPage::ConnectionSqlServer(QString user,QString password,QString host,QString database)
{
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC","QODBC1");//and connectionName

// db= QSqlDatabase::addDatabase("QODBC","QODBC1");
db.setDatabaseName("DRIVER={SQL Server};Server="+host+";Database="+database+";Uid= "+user+";Pwd="+password+";");
db.setHostName(host);

db.setUserName(user);
db.setPassword(password);
db.setConnectOptions("SQL_ATTR_CONNECTION_TIMEOUT= 60");

if (!db.open()) {
return false;
}else{
return true;
}
}


it's worked well,why you have programe?have you installed the sqlserver's odbc driver???

[raphaelf]

hi everybody,

I have tried at my Office to connect from client to our Server and it run Perfekt! We have MS SQL Server 7.0 installed there..hmmm..could by that ODBC doesent support the newer Version?

Thanks for all replies

here the code:

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("pcpsr5");
        db.setDatabaseName("DRIVER={SQL Server};SERVER=pcpsr5;DATABASE=inventar;UID=sa;PWD=xxxxx");
        db.setUserName("sa");
        db.setPassword("xxxxx");
        if(!db.open())
        {
	        QMessageBox::information(this, "Application name",
    "not connected");
    return false;
 
        }
        else
        QMessageBox::information(this, "Application name",
    "connected");
        return true;

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("pcpsr5");
        db.setDatabaseName("DRIVER={SQL Server};SERVER=pcpsr5;DATABASE=inventar;UID=sa;PWD=xxxxx");
        db.setUserName("sa");
        db.setPassword("xxxxx");
        if(!db.open())
        {
	        QMessageBox::information(this, "Application name",
    "not connected");
    return false;
	        
        }
        else
        QMessageBox::information(this, "Application name",
    "connected");
        return true;

To copy to clipboard, switch view to plain text mode 

[wysota]

It could be that in the office the server is configured differently. Try to connect to the server without Qt, using regular sql console provided with the dbms (if there is one) to see if you can connect to the server at all.

[raphaelf]

Hi Wysota!

You are right..It was not a QT Problem. It was on my SQL Server at my Machine..
It was a Authentification Setting. I had to choose: "SQL Server and Windows"

Thank you very much...

Thanks for open my mind

This is the best forum!