Skip to main content
rsingh-85-Regular Member
5-Regular Member
Feb 15, 2017 12:09 PM UTC
Question

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

supandey5-Regular Member
5-Regular Member
Feb 15, 2017 12:36 PM UTC

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

Translate
vipulmittal1-Visitor
1-Visitor
Mar 2, 2017 11:54 AM UTC

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

Translate
supandey5-Regular Member
5-Regular Member
Mar 2, 2017 12:06 PM UTC

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

Translate
jamesm15-Regular Member
5-Regular Member
Feb 19, 2017 8:19 AM UTC

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.

Translate
vipulmittal1-Visitor
1-Visitor
Mar 2, 2017 12:20 PM UTC

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.

Translate
Terms & ConditionsAccessibility statement