Search the Knowledgebase Browse by Category
How to Create a UDL File
User Opinions
93% thumbs up 6% thumbs down (16 votes)

How would you rate this answer?
Helpful
Not helpful
  1. On the client machine, create a new file called "esha.udl" in the "c:\program files\esha research\{program}sql" folder (Make sure that file extensions aren't hidden or else this will look like a text file)
  2. Open the "esha.udl" file and go to the "Provider" tab
  3. Select "Microsoft OLE Provider for SQL Server"
  4. Press "Next" (Connection tab)
  5. Choose your server from the list (Generally this is "servername\esha")
  6. 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")
  7. From the database list, select the database you wish to connect to ('eshadata' or 'gendata')
  8. Press "Test Connection" to test the database connectivity
  9. The test should report as successful.  If not, retrace your steps as well as validate the credentials on the server.
Attachments
No attachments were found.
Related Questions

Powered by ActiveKB Knowledgebase Software