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” in the Provider Options for SAOLEDB.16 

Some specs for reference:

  • SQL Server 64 bit running on Windows Server 2012 Datacenter R2
  • SQL Anywhere 16 64-bit driver installed

http://knowledgebase.progress.com/articles/Article/000026672 This article helped put me on the right track

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.