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 the Community Ranking System, a fun gamification element of the PTC Community. X

Unable to connect to SQL server

pchowdhury
6-Contributor

Unable to connect to SQL server

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

ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

2 REPLIES 2

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
23-Emerald II
(To:pchowdhury)

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

Announcements


Top Tags