How to create a UDL file – ESHA Research

On the client machine, create a new text document called "esha.udl". (Make sure that file extensions aren't hidden or else this will look and behave like a text file.) You can right-click an empty area on the desktop or in another folder and choose New and then Text Document to create the file.
Open the "esha.udl" file. This should open as a Properties tab dialog.
Go to the "Provider" tab
Select "Microsoft OLE DB Provider for SQL Server"
Press "Next" (Connection tab)
Choose your server from the list (Generally this is "SERVERNAME\ESHA"). At this point is a good time to Test Connection to verify access to the server (but not yet to the database on that server).
Select which type of authentication you will use:
- Use Windows NT Integrated security ("Windows Authentication") [preferred].
- Use a specific user name and password ("SQL Authentication")
Press "Test Connection" to test the database connectivity so far.
From the database list, select the database you wish to connect to (typically 'eshadata' for Food Processor or 'Gendata' for Genesis)
Press "Test Connection" to test the database connectivity yet again with the connection now to the database.
The test should report as successful. If not, retrace your steps as well as validate the credentials on the server.

Comments