#include <sql.h>
#include <sqlext.h>
#include <iostream>
#include <string>
 
using namespace std;
 
void extract_error(
    string fn,
    SQLHANDLE handle,
    SQLSMALLINT type)
{
    SQLINTEGER   i = 0;
    SQLINTEGER   native;
    SQLCHAR      state[ 7 ];
    SQLCHAR      text[256];
    SQLSMALLINT  len;
    SQLRETURN    ret;
 
    cout << "\nThe driver reported the following diagnostics whilst running " << fn << "\n\n";
 
    do
    {
        ret = SQLGetDiagRec(type, handle, ++i, state, &native, text,
                            sizeof(text), &len );
        if (SQL_SUCCEEDED(ret))
            printf("%s:%ld:%ld:%s\n", state, i, native, text);
    }
    while( ret == SQL_SUCCESS );
}
 
 
 
int main()
{
    cout << "Program had started.." << endl;
 
    SQLHENV env;
    SQLHDBC dbc;
    SQLRETURN ret;
    SQLCHAR outstr[1024];
    SQLSMALLINT outstrlen;
 
    SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
    SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
    SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);
 
    SQLRETURN SR;
 
    cout << "Attempting Connection " << endl;
    SQLCHAR sqlConnectionString [] = "DRIVER={ODBC Driver 17 for SQL Server};SERVER=localhost, 1433;UID=SA;PWD=yourPassword;";
    ret = SQLDriverConnect(dbc, NULL, sqlConnectionString, SQL_NTS,
                         outstr, sizeof(outstr), &outstrlen,
                         SQL_DRIVER_NOPROMPT);
 
    cout << "Connecting ... " << endl;
    extract_error("SQLDriverConnect", dbc, SQL_HANDLE_DBC);
 
    if (SR!= SQL_SUCCESS && SR != SQL_SUCCESS_WITH_INFO)
    {
        cout << "fail to connect" << endl;
 
    }
    else
    {
        cout << "connected" << endl;
    }
 
 
    return 0;
}