Devart Forums

Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/

Link server in MS SQL Server with dotConnect f. Oracle

https://forums.devart.com/viewtopic.php?f=1&t=33687

Page 1 of 1

Link server in MS SQL Server with dotConnect f. Oracle

Posted: Tue 17 May 2016 15:28
by Harald.Glaeser
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

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

Posted: Wed 18 May 2016 13:44
by Shalex
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.
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/