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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.