DataGate Studio Reference Manual

DataGate Database Names

Database names

You make a database name public by selecting the “*Public database name” checkbox in the database name dialog. A public database name can be referred to explicitly by prepending the string "*Public/", as in “*public/my database name”. Note however that a public database name is known implicitly to your applications as "my database name" without regard to the current user.

The database names that have been defined as public will display in DataGate Explorer as nodes with a special symbol (an uppercase "P") on their icon.

Private and public database names

ASNA DataGate database names are identified as either "private" or "public" database names. Private databases are available only to a specific user (which is determined by the user account active when the private database name was created). Public database names are available to all Windows users accounts. Public database names are available read-only to any user assigned as the identity of an IIS application pool.

Database Name Storage Locations

AVR Classic database names

DataGate Classic registry-based names are maintained in the HKEY_CURRENT_USER and HKEY_LOCAL_MACHINE hives of the Windows registry. These hives are stored as files in well-known locations, depending upon the version of Windows. DataGate for .NET can use registry-based database names for read-only access, for compatibility purposes.

.NET private database names

.NET private database names are located in a file with partial path "ASNA\DataGate\DataGate.config", and rooted in the local "app data" folder. For example, on a typical Windows 10 machine, the file containing private database names are in "C:\users\\AppData\Local\ASNA\DataGate\DataGate.config".

.NET public database names

Public database names are stored in "C:\ProgramData\ASNA\DataGate\Datagate.config". Public database names are often used for web applications, or in other middle-tier applications where the user may be anonymous, have restricted capabilities, or is simply unknown to the application.

Section summary: