title: OLE DB provider 'MSDASQL' reported an error
body: <p>I'm trying to run this code: </p>
  
  <pre><code>&lt;%
  Dim rsSelectOrder
  Dim rsSelectOrder_numRows
  
  Set rsSelectOrder = Server.CreateObject("ADODB.Recordset")
  rsSelectOrder.ActiveConnection = MM_conn_to_mhwebdb_STRING
  rsSelectOrder.Source = "SELECT * from " &amp; ActinicPersons &amp;" p, " &amp;ActinicOrders&amp;" o WHERE p.    [Contact ID] = o.[Invoice Contact ID] AND o.[Order Number] NOT IN ( SELECT OrderNumber from    dbo.tbl_OrdersEntered )"
  rsSelectOrder.CursorType = 0
  rsSelectOrder.CursorLocation = 2
  rsSelectOrder.LockType = 1
  rsSelectOrder.Open()
  
  rsSelectOrder_numRows = 0
  %&gt;
  </code></pre>
  
  <p>Using the following connection:</p>
  
  <pre><code>&lt;%
  ' FileName="Connection_odbc_conn_dsn.htm"
  ' Type="ADO" 
  ' DesigntimeType="ADO"
  ' HTTP="true"
  ' Catalog=""
  ' Schema=""
  
  Dim ActinicPersons, ActinicOrders, ActinicOrderLines, ActinicPayments
  ActinicPersons = "OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};          DefaultDir=C:\inetpub\ActinicOrderFiles\;','select *  FROM persons.csv')"
  ActinicOrders = "OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};      DefaultDir=C:\inetpub\ActinicOrderFiles\;','select *  FROM orders.csv')"
  ActinicOrderLines = "OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};      DefaultDir=C:\inetpub\ActinicOrderFiles\;','select *  FROM orderlines.csv')"
  ActinicPayments = "OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};      DefaultDir=C:\inetpub\ActinicOrderFiles\;','select *  FROM payments.csv')"
  %&gt;
  </code></pre>
  
  <p>Unfortunately even running this code in server management I see the following error message: </p>
  
  <p>OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
  Msg 7303, Level 16, State 1, Line 1
  Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".</p>
  
  <p>Any ideas on how to fix it? I have setup DSN for the connection </p>