C / C++ / MFC

<br />
system("odbcconf /S CONFIGDSN \"MySQL ODBC 3.51 Driver\" \"DSN=MyDsn | Description=test dsn | SERVER=10.1.1.4 | User=user1 | Password=pw1 | Database=MyDb\"");<br />

/**********************************************************************************
# FUNCTION NAME			: CREATEDSN
# PAREMETERS			: driver, keyword
# PARAMETER DATATYPES		: ALL CHARACTER POINTERS
# RETURN TYPE			: INTEGER
# USE				: Create a system dsn
**********************************************************************************/
extern "C" int sqlClass::createDSN(char* driver, char* keyword)
{
	//creating a return value variable
	int returnValue;
	try
	{
		//create a systems dsn - specify a driver and a keyword -> connection string
		returnValue = SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN,(LPSTR)driver,(LPSTR)keyword);
		if (returnValue)
			return 0;
		return -1;
	}
	catch(...)
	{
		//display a message to user if a exception occured
		MessageBox(NULL,"Exception Occured - DSN not created","Error Occured",MB_ICONHAND);
		return -2;
	}
}

---

The only programmers that are better than C programmers are those who code in 1's and 0's.....

Programm3r
My Blog: ^_^

VC_RYK wrote:

what are the changes that i have to make

Cedric Moonen wrote:

that you need to secure the access to the variables using critical sections (for example), so that only one thread will access a variable at a time.

---

The only programmers that are better than C programmers are those who code in 1's and 0's.....

Programm3r
My Blog: ^_^

1. With a UI-thread you post a message with the information you want to pass to the thread
2. With a worker thread (like your example) you have a place where the thread knows it can find information, such as a queue, a struct on the heap or class member variables. When the thread is supposed to get the new information you signal an event or semaphore that the thread is waiting on with ::WaitForMultipleObjects(...).

Roger Stoltz wrote:

When the thread is supposed to get the new information you signal an event or semaphore that the thread is waiting on

---

The only programmers that are better than C programmers are those who code in 1's and 0's.....

Programm3r
My Blog: ^_^