connect to sql server

[raphaelf]

Hi everybody,

QT: 4.1.1
Compiler: MINGW 4.1
OS: WINXP

I am trying to connect to my local sql server, and i was not able:

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("localhost");
        db.setDatabaseName("DRIVER={SQL Server};SERVER=localhost;DATABASE=inventar;UID=rapha;PWD=raphaelf");
        db.setUserName("rapha");
        db.setPassword("raphaelf");
        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("localhost");
        db.setDatabaseName("DRIVER={SQL Server};SERVER=localhost;DATABASE=inventar;UID=rapha;PWD=raphaelf");
        db.setUserName("rapha");
        db.setPassword("raphaelf");
        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 

Postgres connection works perfect:

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("localhost");
        db.setDatabaseName("DRIVER={PostgreSQL};SERVER=localhost;DATABASE=inventar;UID=rapha;PWD=raphaelf");
        db.setUserName("rapha");
        db.setPassword("raphaelf");
        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("localhost");
        db.setDatabaseName("DRIVER={PostgreSQL};SERVER=localhost;DATABASE=inventar;UID=rapha;PWD=raphaelf");
        db.setUserName("rapha");
        db.setPassword("raphaelf");
        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 

What need i to connect to my sql server?

[wysota]

What kind of SQL server is that?

[raphaelf]

Hi,
Microsoft SQL Server 2000 Version 8.0

[wysota]

Did you try skipping that DRIVER parameter in your database name?

[raphaelf]

hi wisota,
yes it not works

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("localhost");
        db.setDatabaseName("inventar");
        db.setUserName("rapha");
        db.setPassword("raphaelf");

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
        db.setHostName("localhost");
        db.setDatabaseName("inventar");
        db.setUserName("rapha");
        db.setPassword("raphaelf");

To copy to clipboard, switch view to plain text mode 

with the QT example SQL Browser, i was also not able to connect using ODBC

if i configure a "inventar.dsn" file in administrative tools (control panel winxp). I was able to connect OVER the SQL Browser Example but not from my app.
I will have in the future my database in a server. So i must be shure that on clients are no configurations needed or required. At my office where i work i have a app running that i can connect from client to server without to configure something special. (This program was programmed with QT3.3.4.)
I am using the same strategy to solve my problem, so i am not understanding whats wrong

[wysota]

Did you make an entry in the odbc manager for your database?

[raphaelf]

hi wysota..
with my old program (QT3). I could connect me without to configure anything on the client and on the server like this:

bool MainWindow::Verbinden()
{   QSqlDatabase *db = QSqlDatabase::addDatabase("QODBC3");
    db->setHostName("pcpsr5");
    db->setDatabaseName("DRIVER={SQL Server};SERVER=PCPSR5;DATABASE=inventar;UID=AdminCI;PWD=xxxxx");
    db->setUserName("AdminCI");
    db->setPassword("xxxxx");
    if(!db->open()){
	db->lastError().showMessage();
	return false;
    }
 	return true;
}

bool MainWindow::Verbinden()
{   QSqlDatabase *db = QSqlDatabase::addDatabase("QODBC3");
    db->setHostName("pcpsr5");
    db->setDatabaseName("DRIVER={SQL Server};SERVER=PCPSR5;DATABASE=inventar;UID=AdminCI;PWD=xxxxx");
    db->setUserName("AdminCI");
    db->setPassword("xxxxx");
    if(!db->open()){
	db->lastError().showMessage();
	return false;
    }
 	return true;
}

To copy to clipboard, switch view to plain text mode 

Why should the same strategy not work with qt4

[dimitri]

Has Qt been built with ODBC support? What is the output of QSqlDatabase::drivers()?

The name of the driver is QODBC, not QODBC3.

[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