Unable to connect to SQL server

[pchowdhury]

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

[Rocko · Accepted solution]

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.

[slangley]

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