Skip to main content
D
darcudarcu1-Visitor
1-Visitor
August 27, 2019
Solved

Unable to Connect to MsSql External Database

  • August 27, 2019
  • 7 replies
  • 3062 views

Unable to connect ThingWorx 8.3.0-b349 to MS SQL external Database. I use the extension pointed by the various tutorials about, then I create a thing using the ThingTemplate MsSQL server. I've tried to change different parameters for the configuration tab. In the application log i receive the messages :

[message: Entity Not Found : [JdbcCreator]]
[message: Entity Not Found : [MySqlServer]] (note that I use the Template and parameters for Ms SQl not MySql)
[message: Unable To Convert From java.lang.String to NUMBER]

I verified that in the Tomcat folder lib there is the MsSql.jar file.
I used a similar procedure for Postgres Database and works, but I keep failing with MsSql.

Best answer by vangne

Hi @darcudarcu 

 

I found these 2 articles which might be helpful, please check.

1.CS297147

2. CS295944

 

Thanks,

Vibhuti

7 replies

V
vangne16-Pearl
16-Pearl
August 27, 2019

Hi @darcudarcu 

 

You may refer this community post External-database-connection-guide-for-ThingWorx-v8 for more information.

Also, please check these two articles.

  1. CS243088
  2. CS310222

Thanks,

Vibhuti

    D
    darcudarcu1-VisitorAuthor
    1-Visitor
    August 27, 2019

    Thanks, 

    I can connect now.

    However, in my DataBase I have two tables, I can query one table successfully but querying the other one gives me the error : Connection Closed.

    Commands not related to a specific table (such as getdate()) work. The query is corrected because is tested  and copied and pasted from the database. 

    The two tables have the same connection properties.

    V
    vangne16-Pearl
    16-Pearl
    August 27, 2019

    @darcudarcu 

     

    Thanks for letting know that the connection issue is resolved.

    Could you please provide the exact error/screenshot about the querying error?

    Terms & ConditionsAccessibility statement