C / C++ / MFC

int WINAPI WinMain(HINSTANCE currentInst, 
				   HINSTANCE prevInst, 
				   LPSTR args, 
				   int showVar)
{
	////////////////////////////////
	//Initializing WinSock library//
	////////////////////////////////

	WSADATA wsaData;
    if(WSAStartup(0x0202, &wsaData))
    {
		MessageBox(NULL,"Call to WSAStartup() failed at line #", "Error!", MB_ICONEXCLAMATION | MB_OK);
        WSACleanup();
        return wsaFail;
    }
    else
    {
        if(wsaData.wVersion != 0x0202)
        {
			MessageBox(NULL,"Wrong socket version! at line #", "Error!", MB_ICONEXCLAMATION | MB_OK);
            WSACleanup();
            return wsaFail;
        }
    }

	////////////////////////////
	//Declaration of variables//
	////////////////////////////

	WNDCLASSEX windowClass;
	HWND handleToWindow;
	SOCKET serverSocket;
	sockaddr_in serverSockAddrIn;
	MSG Msg;

	///////////////////////////////////////////////////////////////
	//Registering the Window Class and creating an actuall window//
	///////////////////////////////////////////////////////////////

	windowClass.cbSize = sizeof(WNDCLASSEX);
	windowClass.style = CS_HREDRAW | CS_NOCLOSE | CS_VREDRAW;
	windowClass.lpfnWndProc = WndProc; //Window Procedure
	windowClass.lpszClassName = class_name;
	windowClass.cbClsExtra = 0;
	windowClass.cbWndExtra = 0;
	windowClass.hInstance = currentInst;
	windowClass.hIcon = LoadIcon(NULL, IDI_APPLICATION);
	windowClass.hCursor = LoadCursor(NULL, IDC_ARROW);
	windowClass.hbrBackground = (HBRUSH)(COLOR_WINDOW + 6);
	windowClass.lpszMenuName = NULL;
	windowClass.hIconSm = LoadIcon(NULL, IDI_APPLICATION);

	if(!RegisterClassEx(&windowClass))
	{
		MessageBox(NULL, "Window Registration Failed at EntryPoint.cpp line #", "Error!", MB_ICONEXCLAMATION | MB_OK);
		return windowRegistrationFail;
	}

	//Creating the window
	handleToWindow = CreateWindowEx(WS_EX_CLIENTEDGE | WS_EX_OVERLAPPEDWINDOW | WS_EX_TOPMOST, 
									class_name, 
									"Server Console",
									WS_OVERLAPPED| WS_VISIBLE, 
									400, 500, 800, 500, NULL, NULL, currentInst, NULL);
	
	if(handleToWindow == NULL)
	{
		MessageBox(NULL, "Window Creation Failed at line #", "Error!", MB_ICONEXCLAMATION | MB_OK);
		return windowCreationFail;
	}
	UpdateWindow(handleToWindow);
	////////////////////////
	//Seting up the scoket//
	////////////////////////

	//sockaddr_in struct
	memset(&serverSockAddrIn, 0, sizeof(serverSockAddrIn));
    serverSockAddrIn.sin_family = AF_INET;
    serverSockAddrIn.sin_port = htons(2567);
    serverSockAddrIn.sin_addr.s_addr = htonl(INADDR_ANY);
	
	//socket
	serverSocket = socket(AF_INET, SOCK_STREAM, IPPROTO_TCP);

	if(serverSocket == INVALID_SOCKET)
	{
		MessageBox(NULL, "Socket Creation Failed at EntryPoint.cpp line#", "Error!", MB_ICONEXCLAMATION | MB_OK);
		WSACleanup();
		return socketFail;
	}
	
	//Making it async//

	WSAAsyncSelect(serverSocket, handleToWindow, NetworkNotification, FD_ACCEPT | FD_READ | FD_WRITE | FD_CLOSE);
	//Binding it//
	if(bind(serverSocket, (sockaddr*)&serverSockAddrIn, sizeof(serverSockAddrIn)) == SOCKET_ERROR)
		return 0;
	
	while(GetMessage(&Msg, NULL, 0, 0) > 0)
	{
		TranslateMessage(&Msg);
		DispatchMessage(&Msg);
	}
	return 0;
}

LRESULT CALLBACK WndProc(HWND hwnd, UINT msg, WPARAM wParam, LPARAM lParam)
{
	switch(msg)
	{
	case NetworkNotification:
		{
			switch(WSAGETSELECTEVENT(lParam))
			{
			case FD_ACCEPT:
				{
					MessageBox(hwnd, "Success!", "Test", NULL);
					break;
				}
			case FD_READ:
				break;
			case FD_WRITE:
				break;
			case FD_CLOSE:
				break;
			}
		}
	case WM_COMMAND:
		{
                  //bla bla bla
		}
	case WM_CREATE:
		{
                  //creating controlls here
		}
	default: 
		return DefWindowProc(hwnd, msg, wParam, lParam);
	}
}

#define NetworkEvent (WM_USER + 5)

HWND hnwd;
	hnwd=::GetForegroundWindow();
	TCHAR filename[120];
	TCHAR buffer[120];
	::GetWindowText(hnwd,filename,120);
	DWORD  dwProcessID;
        ::GetWindowThreadProcessId(hnwd, &dwProcessID);

//vSource is the the query below
//vConnection is a active open connection
//eCursorType = adOpenStatis
//eLockType = adLockOptimistic
//eOption = adCmdText.  I tried combining this with adExecuteRecord using 
//                      Bit OR with an error.  Bit AND caused no errors
//                      but also returned a closed recordset
pRst->raw_Open(vSource, vConnection, eCursorType, eLockType, lOptions);

DECLARE @Id bigint 
SET @Id = 2539
if OBJECT_ID('tempdb..#dumpTable','local') IS NOT NULL
	BEGIN 
		DROP TABLE #dumpTable
	END
	
CREATE TABLE #dumpTable
(
	Depth bigint,
	Parent bigint,
	Type bigint,
	ID bigint,
	Name nvarchar(80)
)
BEGIN
  --SOME WORK
  SELECT * FROM #DumpTable

  DROP TABLE #DumpTable
END