M
Mike K
I have been trying to get my RTD server working across the network.
I've read the Microsoft article "How to use an Excel RTD server
with DCOM" (http://support.microsoft.com/kb/q285888/) as well as
countless postings here and elsewhere. The RTD functions work fine
running on my local pc, if I use something like this:
=RTD("MyRTD.Server","MyComputerName","DoSomething","ABC")
But once I move this to a remote computer, I get the dreaded "#N/A"
error in Excel.
I've followed all of the instructions in the article above, plus I
tried using a strong name for my assembly, adding it to the GAC, etc.
I should note that when checking the "dcomcnfg" log on the RTD
client I see the error "Class not registered from computer
MyComputerName when attempting to activate the server..."
When I do a "regedit" and search for the GUID of my rtd server (on
the server itself), it's there, so I have to think it is in fact
registered.
My Excel macro security settings, on both client and server, are set to
low. And each pc can ping the other.
If there are any thoughts as to what I may be missing, please let me
know.
Thanks,
Mike
I've read the Microsoft article "How to use an Excel RTD server
with DCOM" (http://support.microsoft.com/kb/q285888/) as well as
countless postings here and elsewhere. The RTD functions work fine
running on my local pc, if I use something like this:
=RTD("MyRTD.Server","MyComputerName","DoSomething","ABC")
But once I move this to a remote computer, I get the dreaded "#N/A"
error in Excel.
I've followed all of the instructions in the article above, plus I
tried using a strong name for my assembly, adding it to the GAC, etc.
I should note that when checking the "dcomcnfg" log on the RTD
client I see the error "Class not registered from computer
MyComputerName when attempting to activate the server..."
When I do a "regedit" and search for the GUID of my rtd server (on
the server itself), it's there, so I have to think it is in fact
registered.
My Excel macro security settings, on both client and server, are set to
low. And each pc can ping the other.
If there are any thoughts as to what I may be missing, please let me
know.
Thanks,
Mike