title: Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)"
body: <p>Having an interesting issue. I'm reading from an excel file on a server via an OpenRowset in Sql2005. I've run the query a number of times without any problems. I've just gone out for a quick meeting and suddenly I get the error "Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)""</p>
  
  <p>I've made sure the files are not in use on the server and even deleted them and recopied them over onto the server and still I'm getting the same error.</p>
  
  <p>UPDATE: This only seems to happen if I join two selects from different openrowsets. If I run the queries individually they still work fine. I have done the join before without any issues. Ideas?</p>