TRIGGER to activate Com component on remote server

Results 1 to 2 of 2

Thread: TRIGGER to activate Com component on remote server

  1. #1
    Join Date
    Dec 1969
    Posts
    294

    Default TRIGGER to activate Com component on remote server

    Greetings Everyone.<BR><BR>I want to know if i can put a Trigger on a remote database server and active a com object on a remote web server ( i mean like miles away).<BR>If so, how:) likea little code :) <BR>Stephen

  2. #2
    Join Date
    Dec 1969
    Posts
    915

    Default RE: TRIGGER to activate Com component on remote se

    If you are using SQL server 7, you should be able to write a package that will call the COM object, and then schedule it. The 2 computers will need to be connected via a WAN. Then in the package code...<BR><BR>Set xlApp = CreateObject("Excel.Application", "MyServer")<BR><BR><BR><BR>HTH<BR><BR>Jerry<BR><BR ><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •