Quick Tip: Using the Connection Manager

GAGEtrak GAGEtrak Pro/Lite
1

The Connection Manager is a powerful tool used in GAGEtrak for pointing out your application to a database. This tool can save multiple connections for you to browse through quickly rather than have to point the application out to a database every time. Below will be some steps for how to point out a database to the application.

  1. Open the GAGEtrak Connection Manager

    • Open the Windows Start Menu.

    • Navigate to the GAGEtrak folder.

    • Launch the Connection Manager application.

  2. Create a New Connection

    • In the Connection Name field, enter a descriptive name for the connection.

    • This name is for reference only and helps distinguish between multiple database connections.

  3. Select the Data Source Type

    • From the Select Your Data Source Type dropdown, choose the database type you want to connect to.

    • SQLite is the standard and most commonly used database type.

    • If selecting Microsoft SQL Server, you will need the following information:

      • Server Name

      • Authentication Type (Windows Authentication or SQL Server Authentication)

      • Credentials (if using SQL Server Authentication)

  4. Specify the Database Location

    • For SQLite:

      • Enter the full Database File Name, which is the file path to the database.

      • The database file can be located on a local machine, network drive, or file share.

      • You may also use the Browse button to locate and select the database file.

    • For Microsoft SQL Server:

      • For the database name, after entering in the both logins required (the admin level and the user connection), clicking on the “refresh” button in the lower right hand corner will populate the “Name the database” drop down with a list of currently available databases on the SQL server.

      • A file path is not required for SQL Server databases.

  5. Test the Connection

    • Click Test Connection to verify that GAGEtrak can successfully access the selected database.

    • If the test fails, confirm that the database path, server name, and authentication details are correct.

  6. Save the Connection

    • Click Save to store the connection information.

    • The saved connection will be available for selection the next time you open GAGEtrak.

  7. Save and Connect

    • Click Save and Connect to save the connection and immediately set it as the active database.

    • When GAGEtrak is launched again, it will automatically open using the most recently saved database connection

2 Likes