c++sql-servercdatabase

Handle login failure with CDatabase and SQL Server, SQLState 28000 and SQL server error 18456

I have a SQL Server and ODBC to connect to this server in C++. I am using the CDatabase class and the openEx method for the connection. Here a bit of my code:

inline void openConnection() 
{
    try
    {
        if (!database.IsOpen())
        {
            CString connectionString = "DSN=" + name + ";UID=" + user + ";PWD=" + pwd;              
            database.OpenEx(connectionString, CDatabase::noOdbcDialog);
        }
    }
    catch (CDBException* p)
    {
        //For later use.
    }
    
    cout << "Everythings alright!";
};

Everything works fine when I type in the correct parameters.Now I want to handle the problem where someone typed in the wrong parameters. The problem is that when I give the code wrong parameters (e.g. name = testDSN, UID = noUser, PWD = wrongPassword) I get no error message when the program is compiling. It just gives me "Everythings alright". When I change the 'CDatabase::noOdbcDialog' into 'CDatabase::forceOdbcDialog' I can click on my ODBC connection.

Image 1

After clicking on it I get the login window with my wrong login values.

Image 2

Now when I click on 'ok' I am getting the message giving me the:

SQLState '28000' and SQL server error 18456. "Login failed for user "noUser".

Image 3

Is it possible to check if the values are correct so the compiler tells me that something is wrong?

I tried wrong parameters and looked for some ways to maybe getting some SQLException but my program just don't care about the parameters.

Solution

  • Everytime using wrong parameters a CDBException appears. So just use the catch block:

        catch (CDBException* p)
    {
        cout << "Error!" << endl;
    }

    Alternatively I can output m_nRetCode, m_strError and m_strStateNativeOrigin from the CDBException class for getting more information about the exception.

            catch (CDBException* p)
        {
            cout << "m_nRetCode: " << p->m_nRetCode << endl;
            cout << "m_strError: " << p->m_strError << endl;
            cout << "m_strStateNativeOrigin: " << p->m_strStateNativeOrigin << endl;
        }