An ad hoc connection, that is made for the sake of a single query, is known as a distributed query.Ī distributed query can be run without creating a linked server first, by using the Transact-SQL OPENROWSET and OPENDATASOURCE functions. The persistent connection is known as a linked server. Microsoft SQL Server supports connections to other OLE DB data sources on a persistent or an ad hoc basis. There are the Microsoft OLE DB Provider for Oracle, Microsoft OLE DB Provider for SQL Server, OLE DB Provider for Jet etc. There are variations of the OLE DB providers depending on data source that want to establish connection to. SQL Server connects to the remote data source via an OLE DB provider. A remote data source can be another SQL Server instance or other data sources such MySQL, Access databases, Oracle, Excel workbooks, text files etc. Linked servers allow SQL Server access to data from a remote data source.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |