Hi -

I am setting up linked server 2005 to connect to Unidata using ODBC connection. I used Management Studio to create the link. When I test, it connects successfully. However when I try to open the catalog, I get below error:

The OLE DB provider "SQL Server" for linked server "(null)" reported an error. One or more arguments were reported invalid by the provider.
Cannot obtain the schema rowset "DBSCHEMA_CATALOGS" for OLE DB provider "SQL Server" for linked server "(null)". The provider supports the interface, but returns a failure code when it is used. (Microsoft SQL Server, Error: 7399)


Below is my linked server connection:

EXEC master.dbo.sp_addlinkedserver @server = N'CAD', @srvproduct=N'IBM Unidata ODBC data', @provider=N'MSDASQL', @datasrc=N'CAD'

Any idea please? Do I need to add the provider string? If so, what parms to provide?

Thanks.