Summary

The Company Setup procedure creates the PG.udl file in the Perm directory within the new Company folder. Use this utility to troubleshoot connection problems.

Provider

This tab page lists OLE DB Providers.

Ensure any version containing text 'Microsoft OLE DB Driver for SQL Server' is highlighted.

Note that the version 'Microsoft OLE DB Provider for SQL Server' is the deprecated SQLOLEDB driver. It is strongly recommended that more modern drivers are used. See ADO and OLE DB Installation for more details.

Connection

The settings on this tab page are dependent on which Provider was selected on the Provider tab page, so if it doesn't appear correct, check the correct Provider is highlighted.

Select or enter a server name: This field will be automatically populated with the name of the Server you specified in the Company Setup form.

Enter information to log on to the server: If you specified a PGUser name, this will be specified here with a password the same as the name of the database, which is typically 'PayGlobal'. The password is not required to be secure. If you open the .udl with notepad, all the information is displayed as a Unicode text file.

If you left this field blank then NT Authentication will be applied.

Select the database on the server: Select the new database from the list of databases installed on the selected Server.

Click Test Connection to test if your connection is successful, or an error message will be generated.

All

The following settings, if present, should not be altered on this tab. They are automatically overridden in PayGlobal by the application when the database connection is made.

Data Type Compatibility: This is automatically set to 80, which ensures correct functioning of OLE DB providers with ADO. See ADO and OLE DB Installation for more details.

MultiSubnetFailover: This is overridden in the HR.ini file, based on whether the PayGlobal environment supports SQL Server clustering.