15 Replies Latest reply on Mar 14, 2017 4:27 AM by supandey RSS
    rsingh-3 Explorer

    Access Microsoft Access db from Thingworx

    Hi All,

     

    I want to fetch some information from Microsoft Access db and display in mashup. I don't see any extension available in Marketplace for this. Is it possible to connect to MS Access through Thingworx. This is very urgent for us. If anyone has already done please help.

     

    Thanks

    Ravi

      • Re: Access Microsoft Access db from Thingworx
        supandey Collaborator

        Hi Ravindra, have you already explored the ADO Service connectivity from ThingWorx? If not you can download the service from PTC Software Download > ThingWorx Edge SDK

         

        Here's quick link to the documentation on ThingWorx Edge ADO Service

          • Re: Access Microsoft Access db from Thingworx
            vmittal Newbie

            Hi Sushant ,

             

            I have tried to thingworx edge service but i am facing following issue :-

            Service on start is giving me following error.

            Error intializing socket connection.  Err = -1

            twWs_Connect: Error restarting socket.  Error 0

             

            I feel this is due to connection string pattern (I have a .mdb file that i need to access)

                  {

                    "ConnectionType": "OleDb",

                    "ConnectionString": "Provider=Provider=SQLNCLI11;Server=localhost;Database=C:\New_folder\NaSCoM\NaSCoM_test.mdb;

            Trusted_Connection=yes;",

                    "AlwaysConnected": false,

                    "QueryEnabled": true,

                    "CommandEnabled": false,

                    "CommandTimeout": 60

                  }

             

            If you can provide with any example it would be great !!

              • Re: Access Microsoft Access db from Thingworx
                supandey Collaborator

                Vipul, have you verified that the connection is not blocked by firewall? could you share the full log from ADO here

                • Re: Access Microsoft Access db from Thingworx
                  vmittal Newbie

                  2017-03-02 17:13:11.532Z [L: Error] [T: 1] [U: SYSTEM] [O: com.thingworx.Configuration] Could not read configuration file. : Newtonsoft.Json.JsonReaderException: Bad JSON escape sequence: \N. Path 'Settings.rows[0].ConnectionString', line 656, position 88.    at Newtonsoft.Json.JsonTextReader.ReadStringIntoBuffer(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseString(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseValue()    at Newtonsoft.Json.JsonTextReader.ReadInternal()    at Newtonsoft.Json.JsonTextReader.Read()    at Newtonsoft.Json.Linq.JContainer.ReadContentFrom(JsonReader r)    at Newtonsoft.Json.Linq.JContainer.ReadTokenFrom(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Parse(String json)    at com.thingworx.Configuration.Read() 2017-03-02 17:13:11.537Z [L: Warning] [T: 1] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get Windows service name value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_WindowsServiceName() 2017-03-02 17:13:11.537Z [L: Information] [T: 1] [U: SYSTEM] [O: com.thingworx.services.HostService] Initialization complete. 2017-03-02 17:13:11.542Z [L: Information] [T: 4] [U: SYSTEM] [O: com.thingworx.services.HostService] Starting Service... 2017-03-02 17:13:11.546Z [L: Error] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not read configuration file. : Newtonsoft.Json.JsonReaderException: Bad JSON escape sequence: \N. Path 'Settings.rows[0].ConnectionString', line 656, position 88.    at Newtonsoft.Json.JsonTextReader.ReadStringIntoBuffer(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseString(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseValue()    at Newtonsoft.Json.JsonTextReader.ReadInternal()    at Newtonsoft.Json.JsonTextReader.Read()    at Newtonsoft.Json.Linq.JContainer.ReadContentFrom(JsonReader r)    at Newtonsoft.Json.Linq.JContainer.ReadTokenFrom(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Parse(String json)    at com.thingworx.Configuration.Read() 2017-03-02 17:13:11.549Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get server is secure value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_IsSecure() 2017-03-02 17:13:11.551Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get server address value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ServerAddress() 2017-03-02 17:13:11.552Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get server port value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ServerPort() 2017-03-02 17:13:11.552Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get server resource value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ServerResource() 2017-03-02 17:13:11.553Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ClientName value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ClientName() 2017-03-02 17:13:11.554Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get AllowSelfSignedCertificates value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_AllowSelfSignedCertificates() 2017-03-02 17:13:11.556Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get DisableCertValidation value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_DisableCertValidation() 2017-03-02 17:13:11.557Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ConnectTimeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ConnectTimeout() 2017-03-02 17:13:11.558Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ConnectRetries value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ConnectRetries() 2017-03-02 17:13:11.559Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ReconnectInterval value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ReconnectInterval() 2017-03-02 17:13:11.561Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MaxMessageSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MaxMessageSize() 2017-03-02 17:13:11.562Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MessageTimeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MessageTimeout() 2017-03-02 17:13:11.562Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get OfflineMsgQueueSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_OfflineMsgQueueSize() 2017-03-02 17:13:11.563Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get OfflineMsgStoreDir value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_OfflineMsgStoreDir() 2017-03-02 17:13:11.564Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MaxMessages value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MaxMessages() 2017-03-02 17:13:11.566Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get IdlePingRate value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_IdlePingRate() 2017-03-02 17:13:11.567Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MessageChunkSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MessageChunkSize() 2017-03-02 17:13:11.568Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MessageFrameSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MessageFrameSize() 2017-03-02 17:13:11.569Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get AutoReconnect value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_AutoReconnect() 2017-03-02 17:13:11.571Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ForceConnectOnReadProperty value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ForceConnectOnReadProperty() 2017-03-02 17:13:11.572Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ForceConnectOnWriteProperty value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ForceConnectOnWriteProperty() 2017-03-02 17:13:11.573Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ForceConnectOnInvokeService value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ForceConnectOnInvokeService() 2017-03-02 17:13:11.574Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get PongTimeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_PongTimeout() 2017-03-02 17:13:11.576Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get StaleMsgCleanupRate value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_StaleMsgCleanupRate() 2017-03-02 17:13:11.577Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get StreamBlockSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_StreamBlockSize() 2017-03-02 17:13:11.578Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MaxConnectDelay value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MaxConnectDelay() 2017-03-02 17:13:11.579Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get SocketReadTimeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_SocketReadTimeout() 2017-03-02 17:13:11.581Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ThrowOnOfflineMesssageSave value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ThrowOnOfflineMesssageSave() 2017-03-02 17:13:11.583Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ServerCertFileSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ServerCertFileInfo() 2017-03-02 17:13:11.584Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ClientCertFileSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ClientCertFileInfo() 2017-03-02 17:13:11.586Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ClientKeyFileSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ClientKeyFileInfo() 2017-03-02 17:13:11.587Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get X509FieldSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_X509FieldsInfo() 2017-03-02 17:13:11.589Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ProxySettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ProxyInfo() 2017-03-02 17:13:11.589Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get DutyCycleSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_DutyCycleInfo() 2017-03-02 17:13:11.591Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get application key value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_AppKey() 2017-03-02 17:13:11.592Z [L: Information] [T: 4] [U: SYSTEM] [O: com.thingworx.services.HostService] Service started. 2017-03-02 17:13:11.593Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get thing name value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ThingName() 2017-03-02 17:13:12.148Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get DisableEncryption value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_DisableEncryption() 2017-03-02 17:13:12.204Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not read configuration file. : Newtonsoft.Json.JsonReaderException: Bad JSON escape sequence: \N. Path 'Settings.rows[0].ConnectionString', line 656, position 88.    at Newtonsoft.Json.JsonTextReader.ReadStringIntoBuffer(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseString(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseValue()    at Newtonsoft.Json.JsonTextReader.ReadInternal()    at Newtonsoft.Json.JsonTextReader.Read()    at Newtonsoft.Json.Linq.JContainer.ReadContentFrom(JsonReader r)    at Newtonsoft.Json.Linq.JContainer.ReadTokenFrom(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Parse(String json)    at com.thingworx.Configuration.Read() 2017-03-02 17:13:12.267Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get connection type value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_ConnectionType() 2017-03-02 17:13:12.268Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get connection string value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_ConnectionString() 2017-03-02 17:13:12.269Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get always connected value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_AlwaysConnected() 2017-03-02 17:13:12.271Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get query enabled value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_QueryEnabled() 2017-03-02 17:13:12.272Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get command enabled value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_CommandEnabled() 2017-03-02 17:13:12.272Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get command timeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_CommandTimeout() 2017-03-02 17:13:12.287Z [L: Information] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] Registering 0 Properties for ThingName: AdoThing 2017-03-02 17:13:12.316Z [L: Information] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] Registering 4 Services for ThingName: AdoThing 2017-03-02 17:13:13.335Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:13:13.336Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:14:14.337Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:14:14.338Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:15:15.339Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:15:15.339Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:16:16.342Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:16:16.342Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:17:17.344Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:17:17.345Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:18:18.351Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:18:18.352Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:19:19.366Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:19:19.367Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:20:20.367Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:20:20.368Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:21:21.369Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:21:21.370Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:22:22.374Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:22:22.375Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:23:23.376Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:23:23.377Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:24:24.374Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:24:24.375Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:25:25.373Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:25:25.374Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:25:37.955Z [L: Information] [T: 7] [U: SYSTEM] [O: com.thingworx.services.HostService] Stopping Service... 2017-03-02 17:25:53.963Z [L: Information] [T: 7] [U: SYSTEM] [O: com.thingworx.services.HostService] Service stopped. 2017-03-02 17:26:39.344Z [L: Information] [T: 4] [U: SYSTEM] [O: com.thingworx.services.HostService] Stopping Service... 2017-03-02 17:26:55.348Z [L: Information] [T: 4] [U: SYSTEM] [O: com.thingworx.services.HostService] Service stopped. 2017-03-02 17:26:56.173Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.ado.AdoClient] Error while initializing new AdoThing, or opening connection to Platform. : System.Threading.ThreadAbortException: Thread was being aborted.    at com.thingworx.communications.client.TwApiWrapper.twApi_Connect(UInt32 timeout, Int32 retries)    at com.thingworx.communications.client.TwApiWrapper.Connect(UInt32 timeout, Int16 retries)    at com.thingworx.communications.client.BaseClient.start()    at com.thingworx.ado.AdoClient.run() 2017-03-02 17:27:38.856Z [L: Information] [T: 1] [U: SYSTEM] [O: com.thingworx.services.HostService] Initializing Service... 2017-03-02 17:27:38.954Z [L: Error] [T: 1] [U: SYSTEM] [O: com.thingworx.Configuration] Could not read configuration file. : Newtonsoft.Json.JsonReaderException: Bad JSON escape sequence: \N. Path 'Settings.rows[0].ConnectionString', line 656, position 88.    at Newtonsoft.Json.JsonTextReader.ReadStringIntoBuffer(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseString(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseValue()    at Newtonsoft.Json.JsonTextReader.ReadInternal()    at Newtonsoft.Json.JsonTextReader.Read()    at Newtonsoft.Json.Linq.JContainer.ReadContentFrom(JsonReader r)    at Newtonsoft.Json.Linq.JContainer.ReadTokenFrom(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Parse(String json)    at com.thingworx.Configuration.Read() 2017-03-02 17:27:38.956Z [L: Warning] [T: 1] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get Windows service name value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_WindowsServiceName() 2017-03-02 17:27:38.956Z [L: Information] [T: 1] [U: SYSTEM] [O: com.thingworx.services.HostService] Initialization complete. 2017-03-02 17:27:38.961Z [L: Information] [T: 4] [U: SYSTEM] [O: com.thingworx.services.HostService] Starting Service... 2017-03-02 17:27:38.965Z [L: Error] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not read configuration file. : Newtonsoft.Json.JsonReaderException: Bad JSON escape sequence: \N. Path 'Settings.rows[0].ConnectionString', line 656, position 88.    at Newtonsoft.Json.JsonTextReader.ReadStringIntoBuffer(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseString(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseValue()    at Newtonsoft.Json.JsonTextReader.ReadInternal()    at Newtonsoft.Json.JsonTextReader.Read()    at Newtonsoft.Json.Linq.JContainer.ReadContentFrom(JsonReader r)    at Newtonsoft.Json.Linq.JContainer.ReadTokenFrom(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Parse(String json)    at com.thingworx.Configuration.Read() 2017-03-02 17:27:38.969Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get server is secure value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_IsSecure() 2017-03-02 17:27:38.970Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get server address value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ServerAddress() 2017-03-02 17:27:38.970Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get server port value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ServerPort() 2017-03-02 17:27:38.971Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get server resource value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ServerResource() 2017-03-02 17:27:38.973Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ClientName value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ClientName() 2017-03-02 17:27:38.974Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get AllowSelfSignedCertificates value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_AllowSelfSignedCertificates() 2017-03-02 17:27:38.975Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get DisableCertValidation value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_DisableCertValidation() 2017-03-02 17:27:38.976Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ConnectTimeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ConnectTimeout() 2017-03-02 17:27:38.978Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ConnectRetries value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ConnectRetries() 2017-03-02 17:27:38.979Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ReconnectInterval value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ReconnectInterval() 2017-03-02 17:27:38.981Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MaxMessageSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MaxMessageSize() 2017-03-02 17:27:38.983Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MessageTimeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MessageTimeout() 2017-03-02 17:27:38.984Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get OfflineMsgQueueSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_OfflineMsgQueueSize() 2017-03-02 17:27:38.985Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get OfflineMsgStoreDir value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_OfflineMsgStoreDir() 2017-03-02 17:27:38.986Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MaxMessages value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MaxMessages() 2017-03-02 17:27:38.988Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get IdlePingRate value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_IdlePingRate() 2017-03-02 17:27:38.989Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MessageChunkSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MessageChunkSize() 2017-03-02 17:27:38.990Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MessageFrameSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MessageFrameSize() 2017-03-02 17:27:38.991Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get AutoReconnect value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_AutoReconnect() 2017-03-02 17:27:38.993Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ForceConnectOnReadProperty value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ForceConnectOnReadProperty() 2017-03-02 17:27:38.994Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ForceConnectOnWriteProperty value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ForceConnectOnWriteProperty() 2017-03-02 17:27:38.994Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ForceConnectOnInvokeService value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ForceConnectOnInvokeService() 2017-03-02 17:27:38.996Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get PongTimeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_PongTimeout() 2017-03-02 17:27:38.996Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get StaleMsgCleanupRate value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_StaleMsgCleanupRate() 2017-03-02 17:27:38.998Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get StreamBlockSize value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_StreamBlockSize() 2017-03-02 17:27:38.999Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get MaxConnectDelay value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_MaxConnectDelay() 2017-03-02 17:27:39.000Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get SocketReadTimeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_SocketReadTimeout() 2017-03-02 17:27:39.001Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ThrowOnOfflineMesssageSave value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ThrowOnOfflineMesssageSave() 2017-03-02 17:27:39.003Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ServerCertFileSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ServerCertFileInfo() 2017-03-02 17:27:39.004Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ClientCertFileSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ClientCertFileInfo() 2017-03-02 17:27:39.005Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ClientKeyFileSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ClientKeyFileInfo() 2017-03-02 17:27:39.008Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get X509FieldSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_X509FieldsInfo() 2017-03-02 17:27:39.009Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get ProxySettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ProxyInfo() 2017-03-02 17:27:39.010Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get DutyCycleSettings value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_DutyCycleInfo() 2017-03-02 17:27:39.011Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get application key value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_AppKey() 2017-03-02 17:27:39.013Z [L: Information] [T: 4] [U: SYSTEM] [O: com.thingworx.services.HostService] Service started. 2017-03-02 17:27:39.013Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get thing name value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_ThingName() 2017-03-02 17:27:39.411Z [L: Warning] [T: 5] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get DisableEncryption value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.Configuration.get_DisableEncryption() 2017-03-02 17:27:39.420Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not read configuration file. : Newtonsoft.Json.JsonReaderException: Bad JSON escape sequence: \N. Path 'Settings.rows[0].ConnectionString', line 656, position 88.    at Newtonsoft.Json.JsonTextReader.ReadStringIntoBuffer(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseString(Char quote)    at Newtonsoft.Json.JsonTextReader.ParseValue()    at Newtonsoft.Json.JsonTextReader.ReadInternal()    at Newtonsoft.Json.JsonTextReader.Read()    at Newtonsoft.Json.Linq.JContainer.ReadContentFrom(JsonReader r)    at Newtonsoft.Json.Linq.JContainer.ReadTokenFrom(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader)    at Newtonsoft.Json.Linq.JObject.Parse(String json)    at com.thingworx.Configuration.Read() 2017-03-02 17:27:39.478Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get connection type value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_ConnectionType() 2017-03-02 17:27:39.479Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get connection string value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_ConnectionString() 2017-03-02 17:27:39.480Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get always connected value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_AlwaysConnected() 2017-03-02 17:27:39.482Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get query enabled value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_QueryEnabled() 2017-03-02 17:27:39.482Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get command enabled value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_CommandEnabled() 2017-03-02 17:27:39.483Z [L: Warning] [T: 6] [U: SYSTEM] [O: com.thingworx.Configuration] Could not get command timeout value from configuration, using default. : System.NullReferenceException: Object reference not set to an instance of an object.    at com.thingworx.ado.AdoConfiguration.get_CommandTimeout() 2017-03-02 17:27:39.494Z [L: Information] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] Registering 0 Properties for ThingName: AdoThing 2017-03-02 17:27:39.514Z [L: Information] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] Registering 4 Services for ThingName: AdoThing 2017-03-02 17:27:40.532Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:27:40.533Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:28:41.535Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:28:41.536Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:29:42.539Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:29:42.540Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:30:43.542Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:30:43.543Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:31:44.544Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:31:44.545Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:32:45.549Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:32:45.549Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:33:46.552Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:33:46.553Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:34:47.556Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:34:47.557Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:35:48.562Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:35:48.563Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:36:49.565Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:36:49.565Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0 2017-03-02 17:37:50.567Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] Error intializing socket connection.  Err = -1 2017-03-02 17:37:50.568Z [L: Error] [T: 6] [U: SYSTEM] [O: com.thingworx.communications.client.TwApiWrapper] [Error] twWs_Connect: Error restarting socket.  Error 0

                    • Re: Access Microsoft Access db from Thingworx
                      supandey Collaborator

                      Are you configuring ADO to work with or without the Self signed certificate? You need to recheck the configuration within the configuration file which you are using for this. If you are disabling the DisableCertValidation make sure to also disable the DisableEncryption.

                       

                      Do note that it's strongly recommended to enable these in production environment.

                        • Re: Access Microsoft Access db from Thingworx
                          vmittal Newbie

                          JDBC- Access connection.png

                           

                          Is connection string i am using is in proper format?

                            • Re: Access Microsoft Access db from Thingworx
                              supandey Collaborator

                              Are you using self signed certificates?

                                • Re: Access Microsoft Access db from Thingworx
                                  vmittal Newbie

                                  Please let me know how to check it, so far i am just trying to access the MS access DB.

                                    • Re: Access Microsoft Access db from Thingworx
                                      supandey Collaborator

                                      Vipul, have you followed the How to Configure a secure connection to the ThingWorx Platform (page 15) from the ThingWorx ADO service Configuration guide? if not you likely not be using it and in that case your ADO configuration is incorrect and needs to be reconfigured.

                                       

                                      If you are not using the self signed certificate, you should disable the use of it in the ADO config file by setting the  DisableCertValidation=true, AllowSelfSignedCertificates = false, DisableEncryption=true

                                       

                                      Though i must reiterate its strongly recommended to configure the secure connection for production environment, it may be okay to run with unsecured connection with above properties disabled in learning phase.

                                       

                                      For more detail I'd strongly recommend you to go through the How to Perform a Basic Configuration for ADO service from the guide (page 13)

                                       

                                      Hope this'll help.

                                        • Re: Access Microsoft Access db from Thingworx
                                          vmittal Newbie

                                          Hi Sushant ,

                                           

                                          I am getting following error :-

                                          Error setting proxy configuration. The parameter is invalid. (Code 101) twApi_SetProxyInfo return 101.

                                          Error initializing the .NET SDK. : com.thingworx.common.exceptions.TwApiException: Error setting proxy configuration. The parameter is invalid.

                                           

                                          I am trying to access Thingworx that has been installed locally with URL : http://localhost:8080/Thingworx/Composer/index.html

                                          For ADOThing.config I have configured like this:-

                                          "rows": [

                                                {

                                                  "Address": "localhost",

                                                  "Port": 8080,

                                                  "Resource": "/Thingworx/WS",

                                                  "IsSecure": true,

                                           

                                          Please help , let me know if i am going in right direction.

                                           

                                          Regards,

                                          Vipul

                                            • Re: Access Microsoft Access db from Thingworx
                                              supandey Collaborator

                                              Vipul, is that the only configuration you have in the config file? because the error is concerning the proxy configuration wondering if you are using one, if not could you check that you have not configured that in the config file?

                                               

                                              But if you have proxy server, do make sure to configure that in the ADOThing.config file. Here's my working ADO config for your reference, note that i am not using proxy so its not configured.

                                               

                                              Hope this would help.

                                                • Re: Access Microsoft Access db from Thingworx
                                                  vmittal Newbie

                                                  Hi Sushant,

                                                   

                                                  Thanks a lot for sharing the configurations, it helped a lot. I have changed ADOThing.config and looks like little progress.I am attaching my ADOThing.config and logs. Please check if you can help me on that also. Thanks !! .

                                                    • Re: Access Microsoft Access db from Thingworx
                                                      supandey Collaborator

                                                      Vipul Mittal you have enabled proxy in your ADO configuration file, with "IsEnabled : true" but it contains no information on the proxy server, if you'd check the logs I think the error is quite clear.

                                                       

                                                      So you either have to completely disable the Proxy server setup in your ADO Config file by setting IsEnabled = false  or if you are indeed having a proxy server provide the details concerning the proxy server in the ADO config . For more detail check ADO config file > section How to Configure a proxy Server on page 18

                                                       

                                                      "rows": [
                                                      {
                                                      "IsEnabled": false,
                                                      "Host": "",
                                                      "Port": 80,
                                                      "UserName": "",
                                                      "Password": ""
                                                      

                                                       

                                                      This is just for your reference if you'd to disable it.

                                • Re: Access Microsoft Access db from Thingworx
                                  jamesm Creator

                                  Sushant's answer is probably the best way to do this, but I just want to throw out there that there are third party JDBC drivers for MS Access that you could use, if you don't want to run a seperate ADO .Net service (see: UCanAccess-A Pure Java JDBC Driver for Access) These aren't officially supported by Microsoft, but may be a bit simpler to use with TWX; you can leverage the JDBC connector extension to use drivers such as these: https://marketplace.thingworx.com/Items/jdbc-connector-extension.