-
Linked Server 2005 error connecting to Unidata
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|