Linked Server

[PTina]

We've setup a linked server to connect to a Sybase System. When I run the following query:

SELECT * FROM oetest.orderentry.dbo.salefile

I get the error:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Sybase.ASEOLEDBProvider' reported an error. The provider did not give any information about the error.

OLE DB error trace [OLE/DB Provider 'Sybase.ASEOLEDBProvider' IUnknown::QueryInterface returned 0x80004005: The provider did not give any information about the error.].

Can anyone help me with this error?
We're using SQL 2000 and Sybase 12.5 along with the ASE OLEDB Provider.

 

[PTina]

I can finally see data with the statement below:

select * from openquery(oetest,'select * from dbo.salefile')


I have no idea why the simple statement: SELECT * FROM oetest.orderentry.dbo.salefile gives an error I'm just happy that there is a work around.