title: The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any information about the error
body: <p>I need to import multiple files with a varying number of columns into SQL Server through a script. I am trying to use OPENROWSET for this. I have done the following. </p>
  
  <ol>
  <li><p>Installed driver on the client X64 PC.</p></li>
  <li><p>Execute below commands.</p></li>
  </ol>
  
  <pre><code>EXEC sp_configure 'show advanced options', 1;
  EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
  </code></pre>
  
  <p>When trying to read the file through</p>
  
  <pre><code>SELECT * from OpenRowset('MSDASQL','Driver={Microsoft Text Driver (*.txt;*.csv)};DefaultDir=c:\Delme\;','select * from input.csv' )
  </code></pre>
  
  <p>I am getting the following errors. </p>
  
  <blockquote>
    <p>Msg 7399, Level 16, State 1, Line 17 The OLE DB provider "MSDASQL" for
    linked server "(null)" reported an error. The provider did not give
    any information about the error. Msg 7303, Level 16, State 1, Line 17
    Cannot initialize the data source object of OLE DB provider "MSDASQL"
    for linked server "(null)".</p>
  </blockquote>