I'm trying to deal with the ThingWorx Edge ADO Service. I performed the configuration for the AdoThing.config file, specifying the address, port and Appkey - as well as the type of my database driver (Excel) and the ConnectionString. I also created an AdoThing Thing like a remote database. But there is no connection at the moment. I'm sure that I made some mistake and didn't take into account something, but I don't know what and where. Please, help.
Thank you reaching out on the ThingWorx Developer Community.
Looking at the details provided in your initial post can you confirm first that you have proceeded through all of the steps within the ThingWorx ADO Service Configuration Guide. Perhaps a step was missed from this guide.
Additionally can you confirm what happens when you attempt to run ThingWorxADOService.exe per step 4 on Page 13 of the above guide? Are you shown any errors in the console? Furthermore, is any logged in the ThingWorx Application Log or Error Log when the AdoThing fails to connect?
ThingWorx Technical Support Engineer
Hello. Thank you for your answer. I installed ADO Service using a different instruction, and step 4, which you mention, goes there at the very beginning. Only after its successful execution AdoThing.config file is created. And here is the opposite. Anyway, I don't see any records in the logs associated with this connection. Most likely, there are no errors, because there was not even an attempt to establish a connection.
As it seems to me, this is due to the incorrect filling of the AdoThing.config file. For example, I don't quite understand what needs to be specified for the "port" in the screenshot above. Making a request for ports, I saw the following:
And it's not clear which port is the port of the ThingWorx Server. If we are simply talking about TCP, then it should be "443", as I understand it, that is, the default value