U++ forum: Welcome to the forum

Re: mySql - how to use - what is needed? [message #34699 is a reply to message #34681]

Tue, 06 December 2011 19:31

BioBytes
Messages: 310
Registered: October 2008
Location: France

Senior Member

Hi Wolfgang,

I have an application used where I am working in IRL and I pass only the IP adress of the server where the MySql (version 5.5) is installed. The application has been developped with U++ and connection is done using native MySql. Hereafter is the code snippet for your information. Server identifier contains the IP (193.xxx.xxx.xx) of the Win Server. "dbrisks" is the name of the MySql database.

if(rmSession.Connect(cnxStr.At(3),cnxStr.At(4),"dbrisks",server,ScanInt(cnxStr.At(2),NULL,10))){
SQL = rmSession;
SQL *Select(SqlCountRows()).From(TBLUSERS).Where(IDENTIFIER==cnx Str.At(3));

while(SQL.Fetch())
if(SQL[0]!=0)
{
SetLogonInUse(cnxStr.At(3));
msgStatusBar<<cnxStr.At(3);
msgStatusBar<<t_(" connect�");

rmImageDisplay.setConnectionStatus(true);
rmStatusBar.Set(0,msgStatusBar,200);
rmMenuBar.Set(THISBACK1(SetMainMenu,true));
}
else Exclamation("[*A2@5 "+DeQtfLf(t_("Cet utilisateur n'existe pas !.'\n'Il faut le cr�er."))+"]");
}
else {
errorMessage<<t_("ERREUR SQL: ")<<'\n'<<t_("Impossible d'�tablir une connexion au serveur !")<<'\n'<<t_("L'application va �tre ferm�e par s�curit�");
PanicMessageBox(t_("Erreur connexion"),errorMessage);
Close();
}
}

cnxStr.Clear();
}

Native connection is preferable to ODBC socket when database begin to contain a lot of records. Definitively it is better to use it in production.

if you need more information or help do not hesitate to ask Razz

.

Regards

Biobytes

Report message to a moderator