Unable to connect to SQL server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the Info.
~PC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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