Managing Database Profiles

<< Click to Display Table of Contents >>

Navigation:  Database Toolkit > Remote Databases >

Managing Database Profiles

Previous pageReturn to chapter overviewNext page

Database profiles tell MemberTies where to find a particular database, what to call it (the name that appears in the Database dropdown on the Login window), and how to connect to it.  

Profiles are normally created automatically when you create or restore a database on your computer. This tool is primarily used for managing remote database profiles, i.e., profiles that tell MemberTies how to connect to a database on another computer.  That being said, it is possible to use this tool to make minor changes to local database profiles, i.e., to change the profile name.

To create a new remote profile, you will need to know the details about the way your database is hosted, the IP address of the host machine, etc.  If you are hosting the database yourself, you may want to read Setting up a Multi-User System before you begin. If you are connecting to a database hosted by Myrro International, you will have received special instructions containing everything you need.

Managing Database Profiles

1.Open the Database Toolkit

2.Choose Manage Profiles.
 

 

3.This page enables you to add, edit, and delete profiles.

Adding a Profile

1.Click Add (next to the Database Name list)
 

2.The following fields are available:

Profile Name - a short meaningful name for your database. For example, "Ski Club" or "My Database" are good names. "Branch of the Widgets Data 2022" is not a good name, because it will always be cut off in the list.

Folder Name - The name of the folder specific to your database on the server. This is not a full path and it is not necessarily the same as the display name shown in the Database list  on the Login window.  If you start the Database Toolkit on the Server Host computer and use this same tool, you will see the actual folder name displayed.

IP Address - The address on which the remote server is listening for connections

Port Number - The port through which database server communicates

Server is Secured - This will almost always be set to YES, but if your server is not secured or if this is a local database profile, turn this off.
 
Note: While this tool is not intended for creating a database profile for a local database, if you specify "localhost" as the IP Address, the system will know it is on this computer. A local profile (for a database on your own computer) does not use server user name/password settings the connection is handled internally. Do not use these fields if you are running a local database server or you will not be able to connect.  A common mistake is to enter your MemberTies user name and password in these fields, but those will not work because they are for logging in to your database, not your server.
 
Additionally, while you have to enter something for the server port, the actual value will be overwritten with the port on which the local server is actually running.

Server User Name - The user name with which MemberTies will connect to the server itself. This is not a MemberTies login user name, it is specific to the server.

Server Password - The password for the Server User Name. This is not a MemberTies login password, it is specific to the server..

3.Click Save to save the new profile.  The next time you start MemberTies, the profile should appear in the Database list on the Login window.

Modifying an Existing Profile

1.Choose the desired profile from the Database Profile field, then click Edit.
 

2.Modify fields as needed.
 
Note: If you are editing a local profile, only the profile name can be changed. Everything else is handled internally by the server.

3.Click Save.

Deleting an Existing Profile

1.Choose the desired profile from the Profile Name field, then click Delete.

2.Confirm the deletion when prompted.