Link server in MS SQL Server with dotConnect f. Oracle

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Harald.Glaeser
Posts: 2
Joined: Tue 13 May 2014 07:39

Link server in MS SQL Server with dotConnect f. Oracle

Post by Harald.Glaeser » Tue 17 May 2016 15:28

Hallo,
is ist posible to create a link server in MSSQL Server (2008R2) with the dotConnect for Oracle Software?
The Oracle DB is an old Version 7.3 but my dotConnect works well with VS2010 Applications.

Regards
Harald

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Link server in MS SQL Server with dotConnect f. Oracle

Post by Shalex » Wed 18 May 2016 13:44

SQL Server Database Engine works with linked servers via OLE DB providers: https://msdn.microsoft.com/en-us/library/ms188279.aspx. dotConnect for Oracle is an ADO.NET provider, so looks like there is no way to employ it for connecting to the linked Oracle servers.

Post Reply