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
Link server in MS SQL Server with dotConnect f. Oracle
-
- Posts: 2
- Joined: Tue 13 May 2014 07:39
Re: Link server in MS SQL Server with dotConnect f. Oracle
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.