cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

Access Microsoft Access db from Thingworx

rsingh-8
4-Participant

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

15 REPLIES 15
supandey
19-Tanzanite
(To:rsingh-8)

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

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 !!

supandey
19-Tanzanite
(To:vipulmittal)

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

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

supandey
19-Tanzanite
(To:vipulmittal)

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.

JDBC- Access connection.png

Is connection string i am using is in proper format?

supandey
19-Tanzanite
(To:vipulmittal)

Are you using self signed certificates?

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

supandey
19-Tanzanite
(To:vipulmittal)

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.

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

supandey
19-Tanzanite
(To:vipulmittal)

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.

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 !! .

supandey
19-Tanzanite
(To:vipulmittal)

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.

jamesm1
5-Regular Member
(To:rsingh-8)

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.

Hi James ,

I have tried using JDBC driver with ucanaccess. Is this the right way to configure the connection?

JDBC- Access connection.png

Currently it is not showing database as connected.

Top Tags