DSData - cannot perform any WRITE (poke) command

[Lance Leonaitis]

HELP. I have been using DSData 4.0 build 16 for 5 years reading data to EXCEL, never writing; I love it , it is easy to use. Never any problem. I use DirectSoft to remotely modify programs, perform edits, no problem. I can perform no WRITE using DSData. I have used the example programs provided, I have written the macros - reading = no problem, WRITE = nothing. I watch with WN32 logger and watch on the DSData Status screen, never any writes, I have varied refresh data times, nothing. It is like any WRITE function is locked. No password protection. Please, HELP.

Modem to Modem

[b_carlton]

Just another thought to add to my answers on the AD forum. You may want to think about upgrading to the newest build. I noticed in earlier threads you had communication problems. They seem to have addressed a number of these in their more recent builds.

[Lance Leonaitis]

I just loaded service pack 25 no difference. Although it said it was a Demo and would end in 30 minutes and wiped out all my Topics and Links!!!!!!!!! I am using Windows xp on my laptop and w2000 on my desktop.

[MikeS]

Lance, after we spoke yesterday, i remembered that dsdata v4 has a built-in logger that will display all of the dde/opc traffic that is destined for the dsdata server. it was working for me all along and here's what i did to prove it to myself:

1. setup a topic in the dsdataserver named DemoTopic and have it use a functional Link.

2. Select View->Logger from the menu to enable the DBWin32 logger

3. open the sample excel application named direcsoft4\projects\examples\dsdata\mls_excel5.xls

Excel should warn you about enabling Macros, make sure you select whatever option(s) it takes to Enable Macros. if you don't enable the macros, the VBA code - which does the writing - won't run.

4. in the dsdata window you should now see several items listed, the bottom 6 in the list should all be V2000, and they should be currently reading the value from the PLC. (the time stamp is changing)

5. in the far left column of each V2000 item there is an empty box, if you click that box, an L will apear telling you that the item will be logged. Click to the left of each V2000 item to log all 6 of them.

6. back to the Excel spreadsheet: Cell 9F should contain a value to send to the PLC (mine has 45.67). If you click the 'Write It! button in cell 9C, you should see three entries shouw up in the dbwin32 logger the look something like this:
3600: 11/06/09 14:25:02.80 DemoTopic V2000 Queued Write 45.67
3600: 11/06/09 14:25:02.84 DemoTopic V2000 Written
3600: 11/06/09 14:25:02.85 DemoTopic V2000 Changed 45.67

entries in the Logger window confirm that dsdata is getting dde.opc requests from excel. no entries in the Logger means dsdata isn't getting an requests.

[Lance Leonaitis]

Mike
I wrote a long answer but was not logged in and it was all lost!

I had the logger on and could see the reads but no writes. I will try what you got to work.

Have a great weekend.
Tnx
Lance

[b_carlton]

Can you post the spreadsheet or at least a portion which has an attempted write. Or maybe create a spreadsheet which writes to (or at least attempts to) and reads from a single register. Zip, if needed, and post it here. Maybe it's a 'forest for the trees' situation.