cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Unable to connect to SQL server

pchowdhury
5-Regular Member

Unable to connect to SQL server

Hi TW Gurus,

Need to know, How to connect to SQL server from a thing, I have created using base thing as database.

I was using trial version of TW.

 

Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection String: jdbc:sqlserver://XXXXXXXX:1433;databaseName=XXXX

Privided user and password

 

in the log - I am getting this below error:

Unable to start thing ConnectSQlServer, JDBC Driver Class Not Found: com.microsoft.sqlserver.jdbc.SQLServerDriver

 

am I missing anything?

~PC

 

1 ACCEPTED SOLUTION

Accepted Solutions
Rocko
17-Peridot
(To:pchowdhury)

I see, you're using the PTC-hosted trial. In that case you're out of luck.

But there is also a 90 days trial with local installation available which you could use.

 

View solution in original post

5 REPLIES 5
Rocko
17-Peridot
(To:pchowdhury)

Have you dropped the JDBC jar file into <TOMCAT_HOME>/lib and restarted Tomcat?

Check section "Configuring ThingWorx for MSSQL" in TWX Help of your version.

pchowdhury
5-Regular Member
(To:Rocko)

Thanks for the Reply @Rocko !

However, I am using PTC's 30 days trial version of TWX to connect to SQL server. Is there any default settings for that or it is not possible unless I install TWX locally.

 

Thanks!

~PC

Rocko
17-Peridot
(To:pchowdhury)

I see, you're using the PTC-hosted trial. In that case you're out of luck.

But there is also a 90 days trial with local installation available which you could use.

 

pchowdhury
5-Regular Member
(To:Rocko)

Thanks for the Info.

~PC

slangley
23-Emerald II
(To:pchowdhury)

Hi @pchowdhury.

 

If you feel your question has been answered, please mark the appropriate response as the Accepted Solution for the benefit of others in the community.

 

Thank you for participating in our community!

 

Regards.

 

--Sharon

Top Tags