title: Connection String to use Microsoft Text Driver with a preconfigured data source name
body: <p>We are currently using the following connection string in a script to read a CSV via the Microsoft Text Driver:</p>
  
  <pre><code>myConn.ConnectionString= "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=O:\;Extensions=asc,csv,tab,txt;"
  </code></pre>
  
  <p>Instead of specifying the details to connect to the CSV in the code like we have done above, we want to use a <strong>data source name</strong> in the code.</p>
  
  <p>I.e. a data source that would be configured on the 'System DSN' section of the ODBC snap on the workstation that the script is run in. This ODBC would have the required details linking it to the CSV.</p>
  
  <p><em>For example: All users will have a Microsoft Text Driver ODBC with the name <code>ODBC1</code> setup on their system, and we need to be able to refer to this data source name without putting in the actual details to connect to the CSV in the code.</em></p>