We're about to migrate an old MS SQL 2000 server (32-bit) to a MS SQL 2008 R2 server (64-bit). As part of the install, we use the MS Linked Server feature with some SQL Anywhere 12.0.1 (32-bit) databases.
While I remember that setting up Linked Servers in the old server was nasty enough (particulary compared to the according Remote Data Access), we don't get the new system to access our SA tables.
What we have achieved:
When using a simple four-part-query like the following:
the following error with error code 7312 is returned (translated from German):
So how can I make the provider expose the desired interfaces?
One should never forget to set the "AllowInProcess" option. Now it works.
I should've read the docs better - though this is definetely different between MS SQL 2000 and newer versions:
Oh, yes, and how nicely they fail:)