AlternateCredentialsPassword

Top  Previous  Next

               ×V4.4Ø

S

A

W

WS

ü

ü

Valid for: SetStartup & SetRuntime

 

Syntax -

       SetStartup AlternateCredentialsPassword <AlternatePassword>

 

Description:

This option configures an alternate password that can be used with any of the database commands.  When any of the database commands has the "UseAltCredentials" parameter set, the command will reference the AlternateCredentialsUsername, AlternateCredentialsPassword and AlternateCredentialsDomain configurations to connect to a database rather than using the account that EMUE is logged in under.

 

Password Encryption:

The password can be encrypted by choosing Encrypt Password In File from the tools menu.  The encrypted password will be placed between <encrypted> tags to distinguish between the plaintext password and the encrypted password.

You can also highlight the text you want to encrypt and choose Encrypt Selected Text from either the Edit menu or from right clicking inside the editor.

 

Sample:

       The following example configures alternate database credentials and then retrieves data using these alternate credentials.

SetStartup AlternateCredentialsDomain "KHMC"

SetStartup AlternateCredentialsUsername "emueuser"

SetStartup AlternateCredentialsPassword " password123$"

 

Copy ConnectionString "Driver={SQL Server};Server=hospserver04\\sql2012;Database=TestEMUE;Trusted_Connection=True;"

GetODBCData Patients ConnectionString "SELECT * FROM InPatient;" "UseAltCredentials"

 

See Also:

AlternateCredentialsUsername

AlternateCredentialsDomain

GetODBCData

GetODBCValue

ExecuteODBC

GetOLEDBData

GetOLEDBValue

ExecuteOLEDB