Solved

Send trigger to VB Client app from SQL Server

Posted on 1998-08-25
7
259 Views
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
0
Comment
Question by:emidiod
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 4

Expert Comment

by:mcix
ID: 1089747
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
 
LVL 3

Accepted Solution

by:
altena earned 100 total points
ID: 1089748
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
 

Author Comment

by:emidiod
ID: 1089749
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
The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

 
LVL 3

Expert Comment

by:altena
ID: 1089750
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
 

Author Comment

by:emidiod
ID: 1089751
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
 
LVL 3

Expert Comment

by:altena
ID: 1089752
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
 
LVL 3

Expert Comment

by:altena
ID: 1089753
Memo to self:

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


AltenaR@Yahoo.com
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question