AlternateCredentialsUsername

Top  Previous  Next

               ×V4.4Ø

S

A

W

WS

ü

ü

Valid for: SetStartup & SetRuntime

 

Syntax -

       SetStartup AlternateCredentialsUsername <AlternateUsername>

 

Description:

This option configures an alternate username that can be used with any of the database commands.  When any of the database commands has the "UseAltCredentials" parameter, 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.

 

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:

AlternateCredentialsPassword

AlternateCredentialsDomain

GetODBCData

GetODBCValue

ExecuteODBC

GetOLEDBData

GetOLEDBValue

ExecuteOLEDB