SQL-Articles

Tag: linked server

  • Creating Oracle Linked Server in SQL Server

    I wrote multiple articles on heterogeneous linked server which helped user to connect to Sybase , SQL Server & MySQL RDBMS platforms. However I missed creating Oracle linked server , many users responded to write an article on this so I decided to complete it. As you know when you create a heterogeneous linked server…

  • Creating Linked server to SYBASE from SQL Server

    In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to SYBASE database server from SQL Server environment and then going to query datas from Sybase. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For…

  • Creating Linked server to MYSQL from SQL Server

    In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to MYSQL database server from SQL Server environment and then going to query datas from MYSQL. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For…

  • Linked Server – Part 2

    Introduction Some days back I’ve written “Linked server part 1” where we have discussed about configuring linked server. In this article I’m going to cover authentication protocols between linked server and the possible errors. Before we start let’s have a brief description about connection protocols & authentication mechanism

  • Linked Server – Part 1

    What is Linked Server? Linked server is a concept in SQL Server to access external data sources. This external data sources can be Access, Oracle, Excel, SQL Server or almost any other data system that can be accessed by OLE or ODBC. Where it is used?? A linked server configuration enables SQL Server to execute…