C++ (Cpp) SetDBName Examples

Example #1

File: ProgSettings.cpp Project: wulff007/FastStorage

void ProgSettings::openSettingConnection()
{
    DlgSettingConnect *dlg = new DlgSettingConnect(QApplication::activeWindow());

    dlg->SetDBType(DBType());
    dlg->SetDBName(DBName());
    dlg->SetDBHostName(DBHostName());
    dlg->SetDBUserName(DBUserName());
    dlg->SetDBPassword(DBPassword());
    dlg->SetDBPort(DBPort());

    if ((dlg->exec() == QDialog::Accepted) && (dlg->IsModified()))
    {
        SetDBType(dlg->DBType());
        SetDBName(dlg->DBName());
        SetDBHostName(dlg->DBHostName());
        SetDBUserName(dlg->DBUserName());
        SetDBPassword(dlg->DBPassword());
        SetDBPort(dlg->DBPort());

        if (QSqlDatabase::database().isValid() & QSqlDatabase::database().isOpen())
        {
            QSqlDatabase::database().close();
            QSqlDatabase::removeDatabase(QSqlDatabase::database().connectionName());
        }
    }
}

Example #2

File: DBSqlServer.cpp Project: teahouse/fuserver

DBSqlServer::DBSqlServer()
{
	SetDBIP("");
	SetDBUID("");
	SetDBPwd("");
	SetDBName("");
	SetIsLinking(false);
}

Example #3

File: DBSqlServer.cpp Project: teahouse/fuserver

bool DBSqlServer::Connect(const char* ip, const char* uid, const char* pwd, const char* db)
{
	if (GetIsLinking()) return false;
	SetDBIP(ip);
	SetDBUID(uid);
	SetDBPwd(pwd);
	SetDBName(db);

	std::string connString = GenerateLinkString();
	//SQLCHAR ConnStrIn[255] = "DRIVER={SQL Server}; SERVER=127.0.0.1;UID=test; PWD=test123456;Trusted_Connection=yes;DATABASE=mytest; ";
	
	//FULOG(connString);
	RETCODE retcode;
	SQLHENV henv = SQL_NULL_HENV;
	SQLHDBC hdbc = SQL_NULL_HDBC;
	//1.Á¬½ÓÊý¾ÝÔ´
	//1.»·¾³¾ä±ú
	retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv); /*µÚ¶þ¸ö²ÎÊýÔ­NULL*/
	retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER);
	//2.Á¬½Ó¾ä±ú 
	retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
	retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
	retcode = SQLDriverConnect(hdbc, NULL, (SQLCHAR*)(connString.c_str()), SQL_NTS, NULL, NULL, NULL, SQL_DRIVER_NOPROMPT);
	//ÅжÏÁ¬½ÓÊÇ·ñ³É¹¦
	if ((retcode != SQL_SUCCESS) && (retcode != SQL_SUCCESS_WITH_INFO))  
	{
		FULOG("connect db failed [%s],[%d]!", connString.c_str(), retcode);
		Destroy();
		return false;
	}
	m_hEnv = (char*)henv;
	m_hDbc = (char*)hdbc;

	SetIsLinking(true);
	return true;
}