Skip to main content
1-Visitor
July 14, 2020
Solved

Unable to connect to SQL server

  • July 14, 2020
  • 2 replies
  • 1225 views

Hi @Rocko/All

I got this block-

https://community.ptc.com/t5/Vuforia-Studio/Easiest-way-to-connect-an-SQL-database-to-Thingworx-Studio-For/td-p/529820

where there is one link to get the extension for JDBC(SQL SERVER) -  https://marketplace.thingworx.com/tools/jdbc-connector-extension is not working can anybody point me to right link?

Also, I put the JDBC driver(main one not the extension) in tomcat/lib and trying to  connect to MSSQL server by using a Database thing but not able to connect. any idea, am i doing right?

Here is the log: 

[context: com.thingworx.webservices.context.HttpExecutionContext@7504795c][message: Thing [MSSQLConnection] is not running]

Thanks!

~PC

 

Reference:  post

Best answer by Rocko

Using the Database thing is the correct way, the jdbc extension isn't needed anymore AFAIK.

In your case I would try to restart the server and check if you have the right connection string.

2 replies

Rocko
Rocko19-TanzaniteAnswer
19-Tanzanite
July 15, 2020

Using the Database thing is the correct way, the jdbc extension isn't needed anymore AFAIK.

In your case I would try to restart the server and check if you have the right connection string.

Community Manager
July 22, 2020

Hi @pchowdhury.

 

If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.

 

Thank you for your participation in our community!

 

Regards.

 

--Sharon