Thanks for your help, this has pointed me in the right direction once I develop the complete solution i will post.

Thanks for the reply, I will need to read about that stuff before i can attempt it but its a good starting point thank you

Is there a way to determine the SQL Server configuration from vb.net? I would like to be able to determine what the memory allocation is weather its an express or full version and what version it is. Any information on this would be great,

I am trying to monitor network bandwidth usage on a per user basis and am new to vb.net. I have a list of users with their IP addresses already if that helps. Basically trying to mimic the remote desktop service manager. I am lost when it comes to this so any information about how to accomplish this would be greatly appreciated. Is this even possible?

http://www.codeproject.com/Articles/111430/Grabbing-Information-of-a-Terminal-Services-Sessio Works perfectly

Thanks for the reply, I will look into what you have suggested, do you by any chance have any code samples of how this works? If not no worries, Thanks!!

Thanks for the reply, I am trying to get all users that are on the server that have remoted in and their IPAddresses. Similar to what is showing in the task manager under the users tab and in the terminal service manager.

Thanks so much for the reply What I am trying to do is determine all users logged on to a server and then get their IPAdresses and any other information I can get on them. I did what you suggested but for some reason this also included Local Services,Network Services and others in the list of users. Also every user in the list was triplicated. This is the first project I have done in VB.net so forgive me if i come off as a novice. Any information or code samples would be greatly appreciated.

I am trying to get all logged on users and their IPAddresses and display them in a data grid veiw in a windows form using VB.net I have tried the below code and it appears to get the users on a windows 7 machine but not on servers. Any information on this would be greatly appreciated.

Public Shared Function GetUsers() As List(Of Users)

Dim UserList As New List(Of Users)

Try
    ' WhereDomain=""BLABLA"""
    Using searcher = New ManagementObjectSearcher("root\\CIMV2", "SELECT \* FROM Win32\_LogonSession WHERE LogOnType = 2")

        For Each queryObj As ManagementObject In searcher.Get()

            Dim qry As String = "Associators of " \_
                             & "{Win32\_LogonSession.LogonId=" & queryObj.GetPropertyValue("LogonId") & "} " \_
                             & "Where AssocClass=Win32\_LoggedOnUser Role=Dependent"

            Using iSearch = New ManagementObjectSearcher(qry)

                For Each res As ManagementObject In iSearch.Get()

                    Dim ret As New Users(res.GetPropertyValue("Name"), \_
                                     "", "")

                    UserList.Add(ret)
                Next


            End Using
        Next
    End Using

    Return UserList

Catch err As ManagementException

    MessageBox.Show(err.Message)
    Return UserList

End Try

End Function

I have figured out the issue i was a little off but got it working with the following code.

$to = "Brad.Harris@prosodiecrm.com";

	$from = "John Do";
	
	$subject = "Test Email With WAV";
	
	$message = "This is your test email";
	
	$fileatt = "Removed\\E1002.wav";
	
	$fileatt\_name = "E1002.wav";
	
	$type = "audio/x-wav";
	
	$name = "E1002.wav";
	
	$headers = "From: $from";
	
	//Add MIME content 
	$semi\_rand = md5( time() );
	
	$mime\_boundary="==Multipart\_Boundary\_x".md5(mt\_rand())."x";

   $headers = "From: $from\\r\\n" .
   "MIME-Version: 1.0\\r\\n" .
   "Content-Type: multipart/mixed;\\r\\n" .
   " boundary=\\"{$mime\_boundary}\\""; 
	
	$message = "This is an example" ;
	
	$message = "This is a multi-part message in MIME format.\\n\\n" .
  	"--{$mime\_boundary}\\n" .
  	"Content-Type: text/plain; charset=\\"iso-8859-1\\"\\n" .
  	"Content-Transfer-Encoding: 7bit\\n\\n" .
	$message . "\\n\\n";
	
	//Open File
	$file = fopen( $fileatt, 'rb');
	
	$data = fread( $file, filesize( $fileatt ) );
	
	fclose( $file );
	
	$data = chunk\_split(base64\_encode($data));
	
     $message .= "--{$mime\_boundary}\\n" .
        "Content-Type: {$type};\\n" .
        " name=\\"{$name}\\"\\n" .
        "Content-Disposition: attachment;\\n" .
        " filename=\\"{$fileatt\_name}\\"\\n" .
        "Content-Transfer-Encoding: base64\\n\\n" .
     $data . "\\n\\n";
	
     $message.="--{$mime\_boundary}--\\n";
     
	//Send Email
	$mail\_sent = mail($to,$subject,$message,$headers);
	
	//if the message is sent successfully print "Mail sent". Otherwise print "Mail failed" 
	echo $mail\_sent ? "Mail sent" : "Mail failed";

I am having trouble attaching a wav file to email through PHP.

                $to = "John.Doe@TryHarder.com";
		
		$from = "John.Doe@TryHarder.com";
		
		$subject = "Test Email";
		
		$message = "This is your test email";
		
		$fileatt = "[Removed]\E1002.wav";
		
		$fileatttype = "application/wav";
		
		$fileattname = "E1002.wav";
		
		$headers = "From: $from";
		
		
		//Open File
		$file = fopen( $fileatt, 'rb');
		
		$data = fread( $file, filesize( $fileatt ) );
		
		fclose( $file );
		
		
		//Add MIME content 
		$semi_rand = md5( time() );
		
		$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
		
		$headers .= "nMIME-Version: 1.0n". 
		
		"Content-Type: multipart/mixed;n" .
		
		" boundary= {$mime_boundary}";
		
		$message = "This is a multi-part message in MIME format.nn" .
		
		"–{$mime_boundary}n" .
		
		"Content-Type: text/plain; charset= iso-8859-1 n".
		
		"Content-Transfer-Encoding: 7bitnn" .

		$message . "nn";

		$data = chunk_split( base64_encode( $data ) );
		
		$message .= "–{$mime_boundary}n" .
		
		"Content-Type: {$fileatttype};n".
		
		" name= {$fileattname} n" .

		"Content-Disposition: attachment;n".
		
		" filename={$fileattname} n".
		
		"Content-Transfer-Encoding: base64nn" .
		
		$data . "nn" .
		
		"–{$mime_boundary}–n";
		
		//Send Email
		$mail_sent = mail($to,$subject,$message,$headers);
		
		//if the message is sent successfully print "Mail sent". Otherwise print "Mail failed" 
		echo $mail_sent ? "Mail sent" : "Mail failed";

It seems what ever MIME is doing ends up being the body of the email and the attachment doesn't come though. If someone could point out what i am doing wrong i would be forever grateful. I am fairly new to PHP so please forgive me if this comes of as basic.

I am having a problem understand how to work with time zones in PHP I am trying to create a function where i can pass it a time zone and it will calculate the time in that time zone. i have read countless forms about this and still have hit a brick wall. If any one has any links or information they can share on how to do this i would be forever grateful. All i need to do is find out what the current time is in eastern pacific and central time zones.

Thanks for your help i have found a work around from this i am still not 100% sure exactly what MyZip(its company specific). Thanks for all your help !!! Dino

I am generating a zip file and then emailing it. I am using a temp directory to create this file but i will always be creating a number of different files using this directory. The problem i am having is when i go to delete the files inside my temp directory i get an error saying that the zip file is being used by another process. I have stepped through the code and waited until the email was sent to be sure that its not being locked there. I have also set the zipfile to null and that still didnt work. if anyone has any ideas as to what might be causing this i would be forever grateful.

                    if (!CreatedTempFolder)
                    {
                        //if not dir exists
                        if (!System.IO.Directory.Exists(TempFileLocation))
                            // create it
                            System.IO.Directory.CreateDirectory(TempFileLocation);
                        else
                        {
                            //delete all files from temp foleder
                                System.IO.Directory.Delete(TempFileLocation, true);
                                System.IO.Directory.CreateDirectory(TempFileLocation);
                        }
                        //set CreatedTempFolder to true


                string zipFileName = string.Format("{0}\\\\{1}.zip", TempFileLocation, DrSched\["GROUPNAME"\].ToString());
                MyZip zipfile = new MyZip(zipFileName,"W");
                

                foreach (string fileName in System.IO.Directory.GetFiles(TempFileLocation,"\*.csv"))
                    zipfile.AddFile(fileName);

                //zipfile.Save();
                zipfile.Close();

                zipfile = null;
                GC.Collect();

I am brand new to PHP and i am trying to figure out how to get it to find all its dll. I have tired to modify the ini file telling it were to find the dll with the extension_dir command but still nothing. When i went to uninstall and reinstall i came accross bigger problems with the dll, the code wouldnt compile. All i am trying to do is set it up to connect to mySQL on my machine as well as DBase. If anyone could give me any kind of information or maybe places were i could go look to find stuff out that would be much appreciated.

I am trying to call a web service multiple times inside a loop and it works fine locally on my computer but when i build it out to a server i get the following error. System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host I then added a try catch block as below

                    while (true)
                    {
                        tries++;
                        try
                        {
                            myFile = myWebService.GenerateReportFile(clientID, drSchedule\["password"\].ToString(), Report, drSchedule\["APPLICAT"\].ToString(), "");
                            break;
                        }
                        catch (Exception we)
                        {
                            if(we.ToString().Contains("Reporter.MaxTrackException: No data found with current parameters."))
                            {
                                nodata = true;
                                break;
                            }
                            Console.WriteLine(DateTime.Now.ToString() + " " + AppName + ": " + we.ToString());
                            if(DateTime.Now > wstime.AddSeconds(60))
                                throw new Exception("After " + tries.ToString() + " tries:", we);
                            System.Threading.Thread.Sleep(1500);
                        }
                    }

and i get the same error does anyone have any ideas as to what may be causing this?

I have created a report using excel but when i open it its centered on the last cell it wrote to. How can i save it to open on a specific cell ?? Thanks in advance

I have solved this problem and appreciate all the reply's. The problem was that if a call status came back that wasn't in one of my if statements the program was defaulting to the last line number used since i am not increamenting line numbers. I am sure this is a rookie mistake and i thank you.

Here is my Code

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data.Odbc;
using My;
using System.Data;

namespace FirstCitizensBank_DropOffReport
{
class Program : MyGeneral
{
public static string dataBasePath;
public static string dbname;
public static string strconn;
static void Main(string[] args)
{
StartUp("", "", true);
dataBasePath = ConfigPath + "Empathic\\FirstCit\\";
dbname = "Bank";
strconn = "";

        try
        {
            string repname = dataBasePath + "Reports\\\\Dropoff" + myDate.ToString("yyyyMMdd") + ".xls";

            DateTime enddate = myDate.AddDays(-myDate.Day);
            DateTime startdate = enddate.AddDays(1).AddMonths(-1);
            MyWriteExcel exl = new MyWriteExcel(repname, dataBasePath + "Reports\\\\Templates\\\\DropoffTemp.xls");

            //dbname = dbname + myDate.ToString("yyMM");
            //WriteMonth(ref exl, startdate, enddate, "B");

            enddate = startdate.AddDays(-1);
            //startdate = startdate.AddMonths(-1);
            dbname = "Bank";
            dbname = dbname + myDate.AddMonths(-1).ToString("yyMM");
            WriteMonth(ref exl, startdate, enddate, "C");

            enddate = startdate.AddDays(-1);
            startdate = startdate.AddMonths(-2);
            dbname = "Bank";
            dbname = dbname + myDate.AddMonths(-2).ToString("yyMM");
            WriteMonth(ref exl, startdate, enddate, "D");

            exl.Save();
            exl.Close();

            MyEmail email = new MyEmail("", "First Citizens Bank Dropoff Report", "Please see attached report");
            email.AddAttachment(repname);
            email.AddBCC(CommonEmail);
            email.sendEmail();

            endProgram();
        }
        catch (Exception e)
        {
            WriteToLog("@Failed: " + e.ToString());

            HelpPage(e.ToString(), "Failed");
        }

    }

    public static void WriteMonth(ref MyWriteExcel exl, DateTime startdate, DateTime enddate, string column)
    {
        string sql = "select count(\*) as total, sum(iif(mid(CALLSTATUS, 1, 2) >= '06', 1, 0)) as entered, sum(iif(DONE is not null, 1, 0)) as completed"
                + " from " + dbname + " where startdate