Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
As I had connect Oracle with the TWX earlier.
Now I need to connect the MS SQL with TWX.
So can anyone please help how to proceed with that?
I tried but not got any luck.
Thanks.
Prashant, are you stuck at a specific spot? Do you have the correct extension/ jar file imported?
Hi Anjan,
Thanks for reply.
I am connecting my TWX with MS SQL Database.
So for that I import SQL_Connector_Extension which I created manually by putting metadata.xml and sqljdbc4.jar file.
Then I create a thing and implement that template then add a service and fire a query after putting configuration details which are:
JDBC Driver Class Name : com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC Connection String : jdbc:sqlserver://TCIDATA1.whirlpool.com;DatabaseName=TCI_History
Now should I have to put port in the URL also???
Because I am getting this error while executing the service:
So this is the whole scenario.
I hope you are getting me.
Hi Prashant,
Try following:
Hope it helps.
Thanks,
Ankit Gupta