Unanswered: How to retrieve sybase data from ms sql?
I have built a linked server on MS 2005 to Sybase ASE 12.5 server. I tested the connection successfully. I can use OPENQUERY to retrieve data on Sybase from MS SQL 2005.
But I cannot use four-part name to retrieve data from Sybase, such as
SELECT * FROM sybaseServer.SybaseDB.dbo.myTable
The error is as below:
The OLE DB provider "ASEOLEDB" for linked server "sybaseServer" reported an error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 1
Invalid use of schema or catalog for OLE DB provider "ASEOLEDB" for linked server "sybaseServer". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.