Jerry Nixon on Windows: Provider supports the interface, but returns a failure code when it is used

Jerry Nixon on Windows

Tuesday, May 13, 2008

Provider supports the interface, but returns a failure code when it is used

If you are trying to link sql2000 from the new 64bit 2005 servers and get a message similar to this - “provider supports the interface, but returns a failure code when it is used” you may need to apply the fix below.

c:\Program Files\Microsoft SQL Server\MSSQL\Install>osql -pUSER -pPASSWORD -s[SERVER] -iinstcat.sql

http://support.microsoft.com/kb/906954