Link server in MS SQL Server with dotConnect f. Oracle

Link server in MS SQL Server with dotConnect f. Oracle

Postby 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
Harald.Glaeser
 
Posts: 2
Joined: Tue 13 May 2014 07:39

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

Postby 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.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle