Cannot execute the query against ole db provider msdasql for linked server
Hornady load data 45 acp
After I finally getting the server linked so I could perform simple queries against it, I needed to now figure out how I could perform inserts, updates and —- Invalid use of schema or catalog for OLE DB provider "MSDASQL" for linked server "wqx". A four-part name was supplied...
[SQLSTATE 42000] (Error 7303) OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error". This is the part of the query which fails: Select * from OPENROWSET('Microsoft.ACE.OLEDB.12.0'