Browse by Tags

Related Posts

Blog Post: Error while creating Linked server "Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server ‘LinkedServerName’"

SQL Server Support Content

When we create linked server for SQL server 2000 on SQL server 2005/SQL server 2008 /SQL server 2008 R2 sometimes we see errors w.r.t schema. In this blog, I will discuss on why we get this type of error and also the solution to fix the error message ...read more

on 9 Aug 2012
Blog Post: Troubleshooting “Cannot create an instance of OLE DB provider”

SQL Server Support Content

Today I am going to blog about a frequent issue that we come across while creating linked server-: Cannot create an instance of OLE DB provider "MSDADASQL" for linked server "MyDB2" In this scenario I was creating a linked server to a DB2 server ...read more

on 28 Sep 2011
Blog Post: How to verify if the issue is due to linked server or provider

SQL Server Support Content

When we create a linked server to a database Other than SQL server, like Sybase , Oracle , DB2 etc ,we see some errors and we are not sure whom to contact for support. Should we contact Microsoft support or the third party support. In such an ambiguous ...read more

on 19 Aug 2011