I am trying to create a linked server using a Teradata ODBC DSN in SQL 2005. When I create the linked server, I recieve the following error trying to connect:
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)
I have a similar linked server in SQL 2000, set up exactly the same with no connection issue.
I've read an article posted by someone having the same issue using a DB2 DSN and they mentioned it is a bug in SQL 2005.
Anyone know anything about or seen this issue?