Linking SQL Server 2000 to Sybase 11.5

[goddin]

I am trying to use a link between a Sybase 11.5 database and my SQLserver 2000 database.

I have created a linked server and can query the Sybase tables using the ‘openquery’ method.

However, there are times when I need to use the 'four part address' and every time I try, it fails.

This is one of the common error I receive:

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

Has anyone had any success in using a four part address to talk to Sybase 11.5 from SQLserver2000?

I am using the Sybase System 11 ODBC driver if that is relevant

Thanks

Jim

 

[goddin]

Further to this, I still haven't been able to get the four part address thing working, but I have been able to create views from the Sybase tables using the open query method, and then used these views in my stored procedures.

This is pretty slow, but at least it works.

I'd still like to know how to use the four part address though

Jim