U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » [solved]crash when execute sql command

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

[solved]crash when execute sql command [message #46602]

Thu, 09 June 2016 05:40

akebee
Messages: 90
Registered: August 2011
Location: China

Member

i use MSSQL, i don`t know why this happened! Sad

please see the code:

void ConnectMSSQL()
{
	MSSQLSession mssql;
	for(;;) {
		String cs = "Driver={SQL Server};";
		cs << "SERVER=" << Config::ip << ';';
		String h = "sa";
		if(IsNull(h))
			cs << "Trusted_Connection=Yes;";
		else {
			cs << "UID=" << h << ';';
			cs << "PWD=" << "YanG78lNa4diw3ATs" << ';';
			h = "";
			if(IsNull(h))
				cs << "Database=" << h << ';';
		}
		if(!mssql.Connect(cs))
		{
			RLOG("Connect failed: " << mssql.GetLastError());
			Cout() << "failed\n";
			return;
		}
		else
			break;
	}
	SQL = mssql;

#ifdef _DEBUG
	mssql.SetTrace();
#endif
String sqlstr = "select * from TEST";
	SQL.Execute(sqlstr);
}

CONSOLE_APP_MAIN
{
ConnectMSSQL();

}

it`s no problem!

void ConnectMSSQL()
{
	MSSQLSession mssql;
	for(;;) {
		String cs = "Driver={SQL Server};";
		cs << "SERVER=" << Config::ip << ';';
		String h = "sa";
		if(IsNull(h))
			cs << "Trusted_Connection=Yes;";
		else {
			cs << "UID=" << h << ';';
			cs << "PWD=" << "YanG78lNa4diw3ATs" << ';';
			h = "";
			if(IsNull(h))
				cs << "Database=" << h << ';';
		}
		if(!mssql.Connect(cs))
		{
			RLOG("Connect failed: " << mssql.GetLastError());
			Cout() << "failed\n";
			return;
		}
		else
			break;
	}
	SQL = mssql;

#ifdef _DEBUG
	mssql.SetTrace();
#endif
}

void Query(
{
String sqlstr = "select * from TEST";
	SQL.Execute(sqlstr);

}

CONSOLE_APP_MAIN
{
ConnectMSSQL();
Query();

}

it crash!

[Updated on: Tue, 21 June 2016 09:19]

Report message to a moderator