April 2, 2004 at 2:35 pm
I wrote an app in VB that connects to a company's website (we are a reseller) and automatically places an order. The problem is our front end to the database is a 3rd party billing system. If I could add this app into the billing software I wouldn't have a problem, but I can't.
Somehow I need to trigger this small application once the order has been entered into the DB. I've considered using xp_cmdshell from a trigger to call the app, but that leads to my problem...the application is interative.
I'm fairly new to SQL and wondered if anyone had any tips or tricks to do something like this.
April 2, 2004 at 3:11 pm
You need to be able to run the app without interactivity. Can you modify to take parameters?
BTW, using a trigger is a bad idea:http://www.sqlservercentral.com/columnists/sjones/worstpracticetriggeringexternalevents.asp
April 6, 2004 at 6:38 am
Yeah, adding parameters wouldn't be a problem. I do need the program to be interactive, or at the very least I need a confirmation of success for the order to get back to the user somehow.
thanks for you reply!
Nate
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply