| illusion@consultant.com 2006-10-24, 6:38 pm |
| I'm trying to setup and Linked Server from SQL Server 2005 Standard
Edition to Sybase Adaptive Server 8. There is already an ODBC
connection to the Sybase server that is working fine. But when trying
to execute a select statement from the Linked Server I get the error
shown below and I am hoping if some one can tell me where I am going
wrong.
OLE DB provider "MSDASQL" for linked server "<Server Name>" returned
message "Method is not supported by this provider.".
OLE DB provider "MSDASQL" for linked server "<Server Name>" returned
message "[Sybase][ODBC Driver]Driver not capable".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "<Server Name>"
reported an error. The provider does not support the necessary method.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider
"MSDASQL" for linked server "<Server Name>". The provider supports the
interface, but returns a failure code when it is used.
The connection credential is
exec sp_addlinkedserver @server = 'Sybase Server Name' ,
@srvproduct = 'Sybase',
@provider = 'MSDASQL',
@datasrc = 'Sybase Database Name'
-- Adding linked server login:
EXEC sp_addlinkedsrvlogin
@useself='false ', @rmtsrvname = '<ODBC Data
Source Name>',
@rmtuser = '<Remote User Name>',
@rmtpassword = '<Remote Password>'
|