new connection per thread

[as]

hi

i have a mysql client which creates a new connection to DB in a seperate thread, but as soon as more than one thread tries to connect at the same time, the client program crashes.

code in the thread looks like:


_ptrMysqlHandle = mysql_init (0);
if (_ptrMysqlHandle && mysql_real_connect (.....))
{

....

}

select calls ...

mysql_close (_ptrMysqlHandle);

maybe mysql_init () sets some global variables each time, which are getting modified by threads.

pls. help

thanks in advance

as