Skip to main content
R
rsingh-85-Regular Member
5-Regular Member
February 15, 2017
Question

Access Microsoft Access db from Thingworx

  • February 15, 2017
  • 2 replies
  • 6194 views

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

2 replies

S
supandey5-Regular Member
5-Regular Member
February 15, 2017

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

V
vipulmittal1-Visitor
1-Visitor
March 2, 2017

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

S
supandey5-Regular Member
5-Regular Member
March 2, 2017

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

J
jamesm15-Regular Member
5-Regular Member
February 19, 2017

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.

V
vipulmittal1-Visitor
1-Visitor
March 2, 2017

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.

Terms & ConditionsAccessibility statement