We help IT Professionals succeed at work.

Send trigger to VB Client app from SQL Server

emidiod asked
Last Modified: 2008-02-01
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
Watch Question

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...
Unlock this solution and get a sample of our free trial.
(No credit card required)


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.

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


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?

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.

Memo to self:

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

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.