J
Jim in Arizona
I've made an application that is a computer problems (tickets) system. The
employee goes to a web page and posts the comptuer problem they're having.
Then, the IS staff goes to another webpage (both pages aspx of couse) which
shows the posts by the employees. From there, we assign the problems
(tickets) to each other, set priorities and add notes as neccessary.
What I want to do is, when an employee posts a new problem, have an email
sent out to our email address so we know when a new problem has been posted.
I thought about doing it with SQLMail but i've had all kinds of problems
making that work and I've given up on it. There's a bit more to learn with
that since I've never created any kind of trigger or strored procedure
before.
We have a win2000 AD setup and use exchange2000 as our email server. I was
thinking of some kind of code that will execute when they click the button
that does the DB insert statement. I absolutely hope that, if anyone does
have an example, that it is in VB.
Also, since exchange authentication is done via AD, how would I go about
setting up something like that on the server(s) side? Since anonymous access
is turned off on my IIS 5.0 server, how would this work, or would that even
matter?
TIA!
Jim
employee goes to a web page and posts the comptuer problem they're having.
Then, the IS staff goes to another webpage (both pages aspx of couse) which
shows the posts by the employees. From there, we assign the problems
(tickets) to each other, set priorities and add notes as neccessary.
What I want to do is, when an employee posts a new problem, have an email
sent out to our email address so we know when a new problem has been posted.
I thought about doing it with SQLMail but i've had all kinds of problems
making that work and I've given up on it. There's a bit more to learn with
that since I've never created any kind of trigger or strored procedure
before.
We have a win2000 AD setup and use exchange2000 as our email server. I was
thinking of some kind of code that will execute when they click the button
that does the DB insert statement. I absolutely hope that, if anyone does
have an example, that it is in VB.
Also, since exchange authentication is done via AD, how would I go about
setting up something like that on the server(s) side? Since anonymous access
is turned off on my IIS 5.0 server, how would this work, or would that even
matter?
TIA!
Jim