Skip to main content
M
Mr_Henry_M1-Visitor
1-Visitor
May 23, 2019
Solved

Database Configuration Error

  • May 23, 2019
  • 1 reply
  • 1787 views

Hello! I had such error when filling in and then saving the configuration for the database:

 

7.png

 

As I understand, ThingWorx swears at the "sun" in the JDBC Driver Class Name field:

 

8.png

 

Does this mean that I can't use such driver? Or is the problem in the title, or in something else? Prompt if someone came across this, please.

Best answer by Mr_Henry_M

Hi.

 

It seems that it's impossible to access ODBC using this ODBC-JDBC driver (although in theory it should provide such an opportunity). In the end, I managed to achieve this with the help of ADO Service.

1 reply

S
slangleyCommunity Manager
Support
May 23, 2019

Hi @Mr_Henry_M.

 

Did you install a new extension before creating the database thing?  If so, try restarting Tomcat.  If that doesn't resolve the issue, please provide the logs located at \ThingworxStorage\logs and more information regarding the database thing you are creating.

 

Regards.

 

--Sharon

M
Mr_Henry_M1-VisitorAuthor
1-Visitor
May 28, 2019

Thanks for the answer.

 

I attach today's logs, which somehow changed. With help of the created Thing I want to connect to an Access or Excel databases. As I understand it, they have the same driver.

 

 

Regards,

Henry.

Terms & ConditionsAccessibility statement