asked on

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

mcix

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...

ASKER CERTIFIED SOLUTION

altena

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

emidiod

ASKER

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.

altena

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...)

emidiod

ASKER

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?

altena

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.

altena

Memo to self:

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

AltenaR@Yahoo.com