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".
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