The following information is required for adding External Database connection:
| Name | The name of the external data source to be linked. |
| Provider | Specifies the provider of an external data source. |
| Data source |
Name of the external data source as defined by the OLE DB provider.
NOTES: - When you are linking an external file like the Microsoft Excel workbook or Microsoft Access database as an external data source, type the Data source path exactly as it is from your database server's point of view. - A database server means in this case the workstation or the server machine where the SQL Server used by the CUSTOMTOOLS database is installed at. - The Access database have to be located in a path directly accessible from the computer where the SQL Server of CUSTOMTOOLS is running at. - Also make sure that the user account running the SQL Server's Windows service, also have proper permissions to the linked Microsoft Access file. |
| Connect with CUSTOMTOOLS server connection credentials | Enable/Disable the External database connection to use the same login information as your connection between CUSTOMTOOLS , and the CUSTOMTOOLS database server. |
| Remote user | Specifies your remote user name. The original remote user name should be received from the provider of an external data source. |
| Remote user password | Specifies your password needed to access the external data source. The original password should be received from the provider of an external data source. |