Running an OPC server demo

[Warichet]

Hi,

I'm trying to run an OPC server demo "OPC-Zugriff mit VBA" with files "GetOPCconnection.xls, OPC-VBA.esf" and I get an error
"Beim Ansprechen des EIB OPC-Servers ist folgender Fehler aufgetreten:

ActiveX component can't create object"

I found article 319844 about regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"
Re-boot, No luck. I'm local admin, there is pleny disk space, system is up-to-date, what else ?

Any clue ? besides that OPC is not for me :D

Thank you

[Meudenbach]

may you have to "switch off" the Windows firewall...

r.

[Warichet]

may you have to "switch off" the Windows firewall...

r.
Hi Mike,
Thank you for the tip.
In this case, I'm running on a W2K Pro SP4 system, hence no build-in firewall. All PCs are on a LAN, behind NAT and FW. Anyway, I'm running on a single machine.

I think it has to do with the combinaison of new version of ETS and OPC, where a library is not referenced corretly or entry points have changed, but I'm not a progammer and I can't go any further.

[Warichet]

Anyone having the GetOPCconnection.xls running under ETS3 0d ?

If yes, I'd like to know which references are used in the project. See:
tools - macro vbeditor
tools references

Thank you in advance

[Warichet]

Anyone having ANY kind of OPC demo running under ETS3 0d ? (and willing to share it)

I don't find the samples on the Konnex site anymore http://www.knx-professionals.de/forum/images/icons/icon8.gif. Maybe they have been silently removed, maybe OPC is a dead-end, a thing of the past.

Maybe idiots like me, are kindly requested to buy commercial harware/software solutions.

I thought OPC was an open end to EIB programming, for amateurs/hobbyists to develop some easy things of their own.

Thank you for your to-the-point comments.

[Klaus Gütter]

The error message you get seems to indicate that the OPC server is not (correctly) installed. Did you already try to reinstall the EIB OPC server?

Also note that the demo supports only 5 group addresses.

Regards, Klaus Gütter

[Warichet]

The error message you get seems to indicate that the OPC server is not (correctly) installed.Could be. Please understand, this is my first install, so I've no references. It could be something wrong with W2K Pro SP4, Office XP SP3, OPC server or the application, each element being unique, it's hard to troubleshoot. A friend with a different install has the same prob, sooo..
Did you already try to reinstall the EIB OPC server?So far, I've re-installed W2K Pro SP4, Office XP SP3, and the OPC server. I would appreciate a known working demo. If it runs at your site and not at mine, chances are it is my problem.
Also note that the demo supports only 5 group addresses.
Yes, I noticed http://www.knx-professionals.de/forum/images/icons/icon8.gif it keeps telling me, until I limit to 5 group addresses

Thank you for taking the time to reply

[S. De Bruyne]

Anyone having ANY kind of OPC demo running under ETS3 0d ? (and willing to share it)
Both programs are basically independent. I have both running on my laptop and it works fine.

I don't find the samples on the Konnex site anymore http://www.knx-professionals.de/forum/images/icons/icon8.gif. Maybe they have been silently removed, maybe OPC is a dead-end, a thing of the past.
http://www.konnex.org/fileadmin/downloads/01%20-%20KNX%20Tools/OPC%20Server/Ms%20Office%20Examples.zip

http://www.konnex.org/fileadmin/downloads/01%20-%20KNX%20Tools/OPC%20Server/OPC-Zugriff%20mit%20VBA.zip

http://www.konnex.org/fileadmin/downloads/01%20-%20KNX%20Tools/OPC%20Server/OPCTester%20EIBA.zip

http://www.konnex.org/fileadmin/downloads/01%20-%20KNX%20Tools/OPC%20Server/VB%20Simple_src.ZIP


Maybe idiots like me, are kindly requested to buy commercial harware/software solutions.
No. I have informed before that even to people who do not have a license, (limited) support is given. After all, that's what a demo is for: to check what the thing is and whether you can use it. If you have problems using it, we cannot expect you to buy it, so there is some support indeed.


I thought OPC was an open end to EIB programming, for amateurs/hobbyists to develop some easy things of their own.

This is not wrong.
In your development environment, e.g. in Microsoft Visual Basic, did you enter the references (menu "Tools" item "References") "OPC Automation 2.0" and "OpcEnum 1.0 Type Library" and move them up as high as possible?
"OLE Automation" and "Visual Basic for Applications" (or the alike) have to be marked as well.

[Warichet]

Both programs are basically independent. I have both running on my laptop and it works fine..Fine !!!
Does someone having it running under W2K Pro SP4, Office XP SP3, ETS3 od patch A ? I've seriously checked my config (although it is almost new) especially the DCom settings, DLL registration, no clue, I'm reaching the end ...


http://www.konnex.org/fileadmin/downloads/01%20-%20KNX%20Tools/OPC%20Server/OPC-Zugriff%20mit%20VBA.zip This exactly what I'm talking about. This application cannot connect to the OPC server (in the config given above), error message
Method 'Connect' of object 'IOPCAutoserver' failed
I'd love to read "works for me" (in the config given above).
..even to people who do not have a license, (limited) support is given. After all, that's what a demo is for: to check what the thing is and whether you can use it. If you have problems using it, we cannot expect you to buy it, so there is some support indeed...Quite logical and professionnal approach.
..did you enter the references (menu "Tools" item "References")
"OPC Automation 2.0"
"OpcEnum 1.0 Type Library"
"OLE Automation"
"Visual Basic for Applications"Well I trusted the application, so, as these settings are part of the application, I expected it to be OK. That's why I insist so heavily, asking if someone has it running (in the config given above).

The "Visual Basic for Applications" boxes are not selected, when I select them, I get an error pop-up "Name conflicts with existing module, project, or library". I'm pretty sure that this demo was running before, it doesn't run anymore, I guess a change has been introduced along the chain (I suspect entry points in libraries or something the like).
Thank you for your help (I'm almost desperate)

[S. De Bruyne]

Please send me your source code.

Do not forget to attach the two files for the OPC server.