Uniface User Forum

 View Only
  • 1.  Using SSPI with database connectors

    Posted 14 days ago

    Is it possible to use a database connector string in a Uniface assignment file that utilizes SSPI and thereby eliminate the need for credentials in the assignment file?

    I am aware that I can use question marks in the connector string which will then prompt for credentials or that I can use pathscrambler to obfuscate credentials, however I am specifically looking for the ability to use the credentials of the logged in user without having to prompt for them or to embed the credentials (albeit obfuscated) of a single user in the assignment file.

    An example connection string from someone who has done this successfully would be greatly appreciated.

    Thank you!



    ------------------------------
    Harjit Batra
    Developer
    Rocket Forum Shared Account
    Twinsburg OH US
    ------------------------------


  • 2.  RE: Using SSPI with database connectors

    Posted 14 days ago

    I believe that I found the answer to my own question in the Uniface Help at the topic "Database Access on Microsoft SQL Server", which specifies that

    • user and password as configured in the ODBC data source; optional - can be left empty if integrated security is used.

    Thank you for reading, and hope that this helps someone else thinking or wanting to try this out for their own implementation.



    ------------------------------
    Harjit Batra
    Developer
    Rocket Forum Shared Account
    Twinsburg OH US
    ------------------------------