Search the Knowledgebase Browse by Category

[Advanced Search]
How to Create a UDL File
Would you like to...
Print this pagePrint this page
Email this pageEmail this page
Post a commentPost a comment
Subscribe me
Add to favoritesAdd to favorites
User Opinions
90% thumbs up 10% thumbs down (10 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