SQL Server – An invalid schema or catalog was specified for the provider SAOLEDB for linked server..

So you've installed the correct drivers, and set up the ODBC System DSN properly. Things are going smoothly! Then BAM! Silly errors everywhere! This is the error I received: Msg 7313, Level 16, State 1, Line 13 An invalid schema or catalog was specified for the provider "SAOLEDB.16" for linked server "REDACTED". Solution: Check "Allow Inprocess" … Continue reading SQL Server – An invalid schema or catalog was specified for the provider SAOLEDB for linked server..