Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » MSSQL error management
Re: MSSQL error management [message #49597 is a reply to message #49546] Fri, 09 March 2018 18:40 Go to previous messageGo to previous message
Giorgio is currently offline  Giorgio
Messages: 218
Registered: August 2015
Experienced Member
mirek wrote on Mon, 26 February 2018 16:22

How does your connection code look like?


This is the method I use to connect (I tried both Driver={SQL Server Native Client 11.0} and {SQL Server} with the same result):

bool ImportData::OpenMsSql()
{
	String username = "sa";
	String pwd = "secret";
	String dbname = "ADB_TEST";
	String server = "servername\\sqlserver";
	String cs = "Driver={SQL Server};Server=" + server +
					";UID=" + username + ";PWD=" + pwd + ";Database=" + dbname + ";";
	
	if(!mssql.Connect(cs))
	{
		Exclamation(t_("Unable to connect to database due to the following error: ") + mssql.GetLastError());
		return false;
	}

	mssql.SqlSession::ThrowOnError();
	mssql.LogErrors();
	mssql.SetTrace();

	return true;
	
}

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ODBC crash
Next Topic: MSC configure with VS 2017 Professional
Goto Forum:
  


Current Time: Sun Jul 13 06:59:17 CEST 2025

Total time taken to generate the page: 0.05677 seconds