Skip to main content
S
svisveswaraiya_2859881-Visitor
1-Visitor
September 26, 2018
Question

inserting image in sql database.

  • September 26, 2018
  • 2 replies
  • 1572 views

Hi,

I wanted to insert image from thingworx to sql table (data type - img) in a column. I am using file upload widget to browse and upload image but after uploading i tried to use a insert statement to insert image but it is showing me exception :

Error executing service

Unable to Invoke Service testimg on TrainingThingWorx : null

InsertImg.pngHow can I solve this issue and insert image with full path? Please provide some help.

 

Thanks,

V Shalini.

2 replies

P
posipova20-Turquoise
20-Turquoise
October 1, 2018

Is there any more details in the error in ThingWorx Application Log? Is your database connected? Do you see any information when you click on "table/columns" within your service?

P
posipova20-Turquoise
20-Turquoise
October 1, 2018

Is there any more details in the error in ThingWorx Application Log? Is your database connected? Do you see any information when you click on "table/columns" within your service?

S
slangleyCommunity Manager
Support
October 15, 2018

Hi @svisveswaraiya_285988

 

If you have found a solution to your problem, please post it here and mark it as the Accepted Solution.  This will benefit others on the Community who may have the same question.

 

Regards.

 

--Sharon

Terms & ConditionsAccessibility statement