Send trigger to VB Client app from SQL Server

I would like to notify administrators who are logged in to the server thru a VB client app when an insert is performed on a table using a server side trigger. Ideally i would like to send the inserted records to the clinet, but just notifying the app some how would be great.  How do i do this?  Thank you
emidiodAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
altenaConnect With a Mentor Commented:
Use COM:

In the trigger, create a com-object (one you wrote yourself)
The object can notify admins/everyone through all means
available. (E-mail for example, or it can raise an event in the
VB-app)
0
 
mcixCommented:
Can you clarify notify?

I am not implying what you want to do is impossible, I am trying to understand what you want the trigger/VB app to do...
0
 
emidiodAuthor Commented:
Thanks Altena:
I have already started to create a server side out of process server which uses the winsock control.  I am also placing the winsock control in the client app.  If i create an out of process server on the SQL box i am hoping to instantiate it with sp_OACreate. I have not done this before so i am a little unsure...but i'm gonna try it.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
altenaCommented:
tnx for the grade.

Do yourself a favor: Spend some time on COM and DCOM

The winsock solution is faster to build, but more likely to
break under maintenance. (Trust me, I know...)
0
 
emidiodAuthor Commented:
I thought an out of process server was a COM object.  How can I communicate between remote apps without using the winsock control? Can i directly fire an event from the server to the client app?  Do you have any samples?
0
 
altenaCommented:
Its not easy, but not tooo difficult to.

SQL-Server ---> EventFiringObject(In exe-server)

VB-App --> EventReceivingObject(Same exe-server)

Whenever An event is fired, The exe server passes them on
to VB.

Contact me by e-mail if you need more help.
0
 
altenaCommented:
Memo to self:

Next time you tell someone to e-mail you, put down your e-mail
adress......


AltenaR@Yahoo.com
0
All Courses

From novice to tech pro — start learning today.