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 meeti...

I have a MYSQL database I would like to link my MSSQL database to. Previously I had this system working, utilising the MSDASQL Linked Server Provider, and creating an ODBC datasource using the lat...