SignonInfoDBConnectionString

Top Previous Next

×V3.1Ø

S	A	W	WS
	ü

Valid for: SetStartup

Syntax -

SetStartup SignonInfoDBConnectionString {<Connection String>}

Where:

<Connection String> is a literal string containing the connection string for a Microsoft Access or SQL Server database.

Description:

When using pooled signons, this option configures the connection string used to connect to the database where sign-on information is stored. EMUE supports Microsoft Access and SQL Server databases for tracking signon information. The Access databases and a SQL Server database script are available for download at www.databoundhealthcare.com under Support Downloads in the Downloads menu.

Sample Connection Strings:

SQL Server: Provider=SQLNCLI;Server=ServerName;Database=SignOnInfo;Trusted_Connection=yes;"

Access 2007: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\EMUE\SignOnInfo.accdb;Persist Security Info=False;Mode=Share Exclusive;

Access 2003: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\EMUE\SignOnInfo.mdb;User Id=admin;Password=;Mode=Share Exclusive;

Sample:

The following statements instruct EMUE to use signon information for an Access database.

SetStartup SignOn ""

SetStartup Password ""

SetStartup SignonInfoDBConnectionString "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\emue\Test\SignonDB\SignOnInfo.accdb;Persist Security Info=True;"

SetStartup SignonInfoDBTableName "SignOnInfo"

SetStartup SignOnInfoDBLogTableName "LogInfo"