Skip to main content
F
fgrondin1-Visitor
1-Visitor
March 16, 2017
Solved

Ms Sql Connection

  • March 16, 2017
  • 1 reply
  • 1149 views

Hey all,

I was wondering if there was a way to set the database User Name / password on run time?

What I have in mind is something like, when a mashup loads, it pops a mashup that ask for the username and the password.

Then I would verify if the credential are good and re-ask if not good. or leave the popup if it's good.

So, what would I need to write down in a service to access the username and password information ?

Frederik Grondin

    Best answer by ankigupta

    Hi Frederik Grondin​,

    Yes, this is possible. You just need to create a custom Service which takes the Credentials as input from the user and then add the code to update the configuration of the Database Thing and Restart Thing to run it with the new Configuration.

    This Blog might be helpful for you: Steps to create a External Relational Database Thing and update configuration at Runtime in ThingWorx

    Thanks,

    Ankit Gupta

    1 reply

    A
    ankigupta5-Regular MemberAnswer
    5-Regular Member
    March 17, 2017

    Hi Frederik Grondin​,

    Yes, this is possible. You just need to create a custom Service which takes the Credentials as input from the user and then add the code to update the configuration of the Database Thing and Restart Thing to run it with the new Configuration.

    This Blog might be helpful for you: Steps to create a External Relational Database Thing and update configuration at Runtime in ThingWorx

    Thanks,

    Ankit Gupta

    Terms & ConditionsAccessibility statement