Comments (12)

An invalid schema or catalog was specified for the provider “MSDASQL” for linked server

Filed in technogeek, 12/10/2008, December 10 2008 | 4:51 pm by Sunshine Lewis ,

Make sure “level zero only” is checked on the MSDASQL provider.
Now to the question!
SQL Server’s linked server feature lets you link to a remote server through an ODBC connection. Once the server is linked, you are supposed to be able to reference it using four-part notation like so:
SELECT * FROM linkedserver…tablename
If you’re like me that [...]