Home > ADO.NET > Simple way to generate connection string from text file

Simple way to generate connection string from text file

Common issue generally every developer faces in his initial days of development is how to generate connection string that connects my application to the database. Especially when we don’t have sql management studio installed or if we are facing licensing issues.

Well, a text file can come to a rescue.

 

 

To overcome such issues and generate connection strings we need to follow these simple steps:

 

  • Create a text file with any name eg. connections.txt

1

 

 

  • Rename the extension of the file from .txt to .udl

2

 

 

  • Double click and open the connections.udl file in the default app

3

 

 

  • Set the relevant details in the data link properties manager and if you are using sql authentication then check the checkbox for ‘Allow saving password’ then click ‘OK’ after testing the connection
  • Open the connections.udl file in a text editor.

4

 

 

 

Post comments if this helps

This Article is TAGGED in , , , , , , . BOOKMARK THE permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">