Re: Independant QUery

From: Rathna Raj (RathnaRajT_at_icode.com)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 14:41:39 +0530

Sorry Todd, it's quite long time since I visited this NG.

Proxies (simplified definition):
When you have COM component in a machine (server) and if you need invoke
that COM component from another machine (client), for client and server talk
to each other and pass data to and fro (marshalling), client must know
how/where to send request and receive response to/from server. To enable
this you install the proxy of the COM component in your client. Most of the
time it will simply registering your COM components TLB in your client
machine.

sp_oa**:
These are the system stored procedures (For example: sp_OACreate,
sp_OAMethod, sp_OADestroy, etc.) available on your MS SQL server, to work
with COM objects in your T-SQL script (like stored procedure). Have look at
SQL Server Books Online for more help on these.

> Also can you please explain what the below statement means:
>> In either case you need to use sp_oa*** system stored procedures in your
>> triggers (or in your SPs, which in turn get called by your triggers)

Having explained sp_oa**, I hope that above statement make sense to you.
Since it was COM based approach, you need to use those system stored
procedure to create your COM objects, to make a method call and to destroy
them.

HTA

Rathna Raj

Relevant Pages

  • Re: What doesnt lend itself to OO?
    ... >> proxy and instructs the server to constuct the real object. ... rather than client code. ... If 'clock' is instantiated in the server, ... > for the server interface at the OOA level. ...
    (comp.object)
  • This is going straight to the pool room
    ... or not the client has privilege to do what they're trying to do, ... The server environment is this: ... 3GL User action Routines that Tier3 will execute on your behalf during the ... Routine Name: USER_INIT ...
    (comp.os.vms)
  • [Full-Disclosure] R: Full-Disclosure Digest, Vol 3, Issue 42
    ... Full-Disclosure Digest, Vol 3, Issue 42 ... SD Server 4.0.70 Directory Traversal Bug ... Arkeia Network Backup Client Remote Access ...
    (Full-Disclosure)
  • Re: What doesnt lend itself to OO?
    ... > rather than client code. ... no way to do that without also touching the object with clock semantics ... will not encapsulate both clock semantics and network semantics. ... The server can do whatever it wants ...
    (comp.object)
  • RE: Fax monitor incoming + outgoing calls?
    ... problem between the client computer and the SBS server. ... Client is using the internal IP address of the SBS server as the ... To the folder redirection GPO issue: ...
    (microsoft.public.windows.server.sbs)