show sorted table in crystall report - C# Discussion Boards

23-May-07 11:57

So I have this app that has been creating some odd errors. Sadly, it has been throwing some odd and inexplicable error messages. No one I've sought help from has been able to help me with it. Mostly due to the fact that no one knows what's been causing the errors.

So after recoding many a thing and adding in some error handling, the errors are no longer occuring, but at the cost of reduced functionality. And then it donned on me...

What if I were to add some kind of error reporting that send me an error report through the email system we have in place...??? That way, I would know of the error as well as have an error dump of sorts. That way, I'll be able to find out what is causing the various errors that have been occuring.

Only 1 problem.

I don't know how to send mail through an Exchange server. I know you can make an email using SMTP, but that doesn't work here. I tried.

So where can I find some GOOD info on creating an app that will send an email through an exchange server? Unless someone knows how already. If you know how, could you bestow upon me such knowledge? Any and all help is always appreciated...

Thanks.

ekynox23-May-07 15:33

23-May-07 15:33

Sending an email programmatically through exchange is no big deal.
well .NET 2.0 has the ability create and send email via a specified SMTP server address. Have you tried looking at the System.Net.Mail namespace ?

Also here is a code snippet.
MailMessage mail = new MailMessage();
MailAddress ToMailAddress = new MailAddress("hello@helloworld.com");
MailAddress FromMailAddress = new MailAddress("goodbye@helloworld.com");
mail.From = FromMailAddress;
mail.To.Add(ToMailAddress);
mail.Subject = "Test Email";
mail.Body = "This is a test email";

System.Net.Mail.SmtpClient smtpServer = new System.Net.Mail.SmtpClient("192.168.0.1");
smtpServer.Send(mail);

Also you can try Lumisoft.NET dll which allows you to receive and send emails. You will need to google to get the Lumisoft .NET dll. Its free to use as well.

Hope this helps.
cheers
V

Spyder_Snyper26-May-07 4:53

26-May-07 4:53

I took a look at the namespace, but 3/4 of it is just gibbersih to me...lol...

But I didn't know I could use the SMTP class to send VIA an Exchange server... I have need to try that. Thanks.

BTW... I *THINK* the exchange server has need of a username/password... Do you know how to use add that at all?

ekynox26-May-07 17:17

26-May-07 17:17

Spyder_Snyper wrote:

BTW... I *THINK* the exchange server has need of a username/password... Do you know how to use add that at all?

can you please clarify as to why you think you need the username/password ? As far as sending email via SMTP via MS Exchange you dont need to supply any username or password. Only when it comes to retreiving email via a user's mailstore on exchange then you do need the username/password.

If you can be a bit more specific with your problem I can attempt to help you a bit more.

Spyder_Snyper27-May-07 5:30

27-May-07 5:30

I think I need the username password because everytime I try to send an email, I get an authentication error.

But then again, if, as you say, I don't need a username and password, THAT might be the problem.

I shall make an attempt with both, and make note of any errors that occur. If they do, I'll post the error messages here.

Thanks for the help man!

Spyder_Snyper27-May-07 9:53

27-May-07 9:53

as far as why I think that the server requires authentication...

when I try to send an email, I get an error. It reads:

"5.7.3 Client does not have permission to submit mail to this server."

I think the message is a pretty dead giveaway...

ekynox27-May-07 16:30

27-May-07 16:30

does the client have an exchange mailstore associated with it ?
try this:
go to START->RUN type in cmd
from the command shell type in TELNET severIPaddress 110
110 is the POP3 protocol port number.

Type in USER username press enter
Type in PASS password press enter

Telnet should response with user successfully logged in. If it doesnt then you know that the user doesnt have access to the exchange server.

I dont have Exchange server installed on my test box yet. But when I did build my automated email client which sent emails out to my exchange server, i never had to supply a username/password to my email client software.

ekynox28-May-07 2:35

Re: MS Exchange Server 'Client' [modified]

28-May-07 2:35

g'day mate,

sorry my earlier post does not make any sense. Tomorrow when I get to work I will install Exchange server on my test server and run that snippet of code i posted earlier. Just one thing did you actually run that snippet of code I post couple days ago ?

Will update tomorrow with my progress regarding username/password sending email.

sorry for not being too useful.

Spyder_Snyper28-May-07 5:00

28-May-07 5:00

It's cool... No worries here.

The code that you have is what I am using at the moment.

I'll check out telnet and see what happens with that.

**EDIT**

So i checked out the telnet trick there. It sorta kinda worked. I could get to the login section where I typed USER and PASS. No matter the combination that I used, I could not get logged in. It may (or may not) be because I don't know where to put in the domain info. I tried with the user, but to no avail.

I *DO* know that the user name and password have access to the exchange server because I have Outlook set up, and it is using the exact same credentials as the user that I was using. And Outlook works just fine.

-- modified at 11:17 Monday 28th May, 2007

ekynox28-May-07 21:12

28-May-07 21:12

hi again,
today I installed Exchange 2003 on my test server running windows server 2003. The same test server was my domain controller. I just did a default installation of Exchange and Active Directory. I didnt change any security settings etc because I have zero idea about active directory security maintenance.

I ran a test network with my test server being the exchange and domain controller. In this network I ran another Win XP client machine which was not part of my test domain. I wrote the SMTP code I gave you a few days ago as win app and ran it on this Win XP client machine and I was not prompted for any username or passwords.

This would leads me to believe that your configuration of active directory and exchange must be running some high security configuration which needs the user to be authenticated before any email can be sent out or received.

There are 3 solutions you can try:
1) The first solution is that the machine you are using to run the SMTP code I gave before needs to logon to the domain and authenticate the user. The user needs to be part of the active directory. Then run the email sending application you wrote. Maybe check with whoever setup the exchange server on its user authentication requirements.

2) You use an alternative .NET based SMTP class. I gave you the reference Lumisoft.dll. Go to this website and download this dll library:
http://www.lumisoft.ee/lsWWW/Download/Downloads/Net/LumiSoft.Net.zip
Create a new .NET windows application and use the Lumisoft dll to create an email sending application. You will need to use the LumiSoft.Net.SMTP.Client.SMTP_Client namespace. There is a chm helpfile which describes how to use the dll. I dont have the time right to write you a code snippet but read through the helpfile and there are code fragments to get you started.

If you get stuck go to the author's webpage he has a forums section and put a post there. The author is a very nice guy and he has an article on codeproject regarding the lumisoft.dll.

3) In the code I had provided earlier ensure that you used the defaultcredentials property take a look below:

System.Net.Mail.SmtpClient smtpServer = new System.Net.Mail.SmtpClient("192.168.0.1");
smtpServer.UseDefaultCredentials = true;

What this does is that whoever is logged on to the machine that is executing this code their credentials will be used to authenticate against the SMTP server. You have to makesure that the username and password are actually validated against active directory being used by your exchange server.

Let me know how you go and I will see if I can write some code using Lumisoft.

Good luck.

Spyder_Snyper30-May-07 6:27

30-May-07 6:27

You give me much to work with... Big Grin | :-D

Sadly, that first one isn't exactly an easy option to explore. What with the ungodly number of miles of red tape and all...

So that third one looks a little promissing. I was taking a look at a few other things that might help with that. I think it was called User Impersonation.

Do you know of this?

From what I've read, I *THINK* it may help me in this task.

But before I overcomplicate things, I first want to try your third option there, and if that doesn't work, I'll go for #2.

Once again, thanks for the help. I'll post the results when I get some... Wink | ;)

ekynox30-May-07 14:36