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

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

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