Implementing RTD Server Issue

Dears Support Team,
I am working in development of real time data system that uses lightstreamer server to transmit real time data from stock market RDA Adapters and in client data is displayed using real time data grid view.
Customers need to select some data rows from displayed data, copy them and paste to Excel sheet, then the data is updated in excel sheet as in client application.

- I tried to install the RTDLibraryExcelDemoSetup_local.msi and it works fine while connecting to lightstreamer server
- I downloaded the StockList-client-rtd-master source code and followed the steps described in the demo to build my own dll that connects to our light streamer server and subscribes to some items that has been pushed using our adapter to update Excel clients with these Items' data but it not working and N/A is displayed in Excel Sheets

the implementation is performed as following
Client- Side:
- the user selects some rows and paste them into excel sheet then the formula of each cell as the following print screens
formula of first cell
Attachment 181
formula of each cell looks like
Attachment 182
RTD Server Side:
modifications performed are :

Code:

---


        internal const string RTD_PROG_ID = "tabee3.com"

---

- guid attributes has been added to RtdServer class

Code:

---


        internal const string RTD_PROG_ID = "tabee3.com"

---

- build properties adjusted to register the dll after every successful build and make Assembly COM Visible

-@ LightstreamerClient class
added methods to call a service to get some stock data from Database and use that data to subscribe to our lightstreamer server and method

Code:

---

 
  public void AddSubcribe(string[] items, string[] fields)

---

to subscribe and get data from our lightstreamer server.


Please advice me if there any mistakes i performed or missed steps to do.

Thanks in advance,
programmer

Hi programmer,

could you please confirm that if you build the source code as is, without no modification, the demo still works fine?
Did you run the RegAsm.exe tool in order to register the ddl?
Do you have any other client that receives real-time updates pushed by your adapter? Just to be sure that there are no serve-side issues.

Please let me know.
Regards
Gianluca

Hi Gianluca,

I Built the demo source code but by just registering the output dll and replacing original one the data streaming stopped in excel sheet.
Dll registration:
- I tried differnt methods like -regasm and regsvr32 tools for both x64 and x86 versions more over I performed configs. to register the
Dll after every successfull build and the same result

the client application subscribes to the same Items and data is pulled successfully from light streamer which works really with many real custmoers.

best wishes,
Programmer

Hi programmer,

my suggestion is to follow these steps:

1) Uninstall the RTDLibraryExcelDemo and make sure to remove everything related
2) Compile the demo source code and then register the dll using the Regasm.exe tool
3) Open the regedit tool and look for the following keys (just search through the whole registry for RTDLibraryExcelDemo.dll)
HKEY_CLASSES_ROOT\CLSID\{2368E0E6-1ED6-3C39-8FAE-45B4A9FB53F3}\InprocServer32\CodeBase
HKEY_CLASSES_ROOT\CLSID\{2368E0E6-1ED6-3C39-8FAE-45B4A9FB53F3}\InprocServer32\1.0.0.0\CodeBase

It's supposed that something has gone wrong with registry settings.
Please get back to us once done for further investigation

Thanks and Regards,
Gianluca