Tag Archive

The following is a list of all entries tagged with code snippet:

Comments (22)

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 ,

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 [...]