Issue – How to create ODBC connection from text file.

Resolution –

Step 1 – Create the text file and ensure extension is enabled.

Step 2 – If you don’t know how to enable extension.

select your file ( in my case odbc ) and click on view on Top Navigation bar and select File name extensions options.

Step 3 – Change .txt extension to .udl

Step 4 – Double click on your odbc connection file.

Now you have your odbc connection ready