Create Linked Server in SQL Server 2022 on Linux

Question

Create Linked Server in SQL Server 2022 on Linux

Velázquez Paulín Tania Noemi 60

Our team are analyzing the possibility to use SQL Server on Linux but we need to use Linked Server, so the question is if Can we created Linked Server to Oracle and Sybase?

Vahid Ghafarpour 23,385 Reputation points Volunteer Moderator

2023-05-31T01:40:12.35+00:00
To create a Linked Server to Oracle, you would typically use the Oracle OLE DB Provider or the Oracle ODBC Driver. Here's an example of creating a Linked Server to Oracle using the Oracle OLE DB Provider:

EXEC sp_addlinkedserver @server = 'LinkedServerName', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = 'OracleServerName';

Similarly, to create a Linked Server to Sybase, you can use the Sybase OLE DB Provider or the Sybase ASE ODBC Driver. Here's an example using the Sybase OLE DB Provider:

EXEC sp_addlinkedserver @server = 'LinkedServerName', @srvproduct = 'Sybase', @provider = 'ASEOLEDB', @datasrc = 'SybaseServerName';
Anonymous

2023-06-02T08:23:08.93+00:00

Hi @Velázquez Paulín Tania Noemi

Has your issue been resolved? Please checking in to see if the below suggestions helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Best regards,

Aniya

Accepted answer

2 additional answers

Your answer

Vahid Ghafarpour 23,385 Reputation points Volunteer Moderator

2023-05-31T01:40:12.35+00:00

To create a Linked Server to Oracle, you would typically use the Oracle OLE DB Provider or the Oracle ODBC Driver. Here's an example of creating a Linked Server to Oracle using the Oracle OLE DB Provider:

EXEC sp_addlinkedserver @server = 'LinkedServerName', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = 'OracleServerName';

Similarly, to create a Linked Server to Sybase, you can use the Sybase OLE DB Provider or the Sybase ASE ODBC Driver. Here's an example using the Sybase OLE DB Provider:

EXEC sp_addlinkedserver @server = 'LinkedServerName', @srvproduct = 'Sybase', @provider = 'ASEOLEDB', @datasrc = 'SybaseServerName';
Anonymous

2023-06-02T08:23:08.93+00:00

Hi @Velázquez Paulín Tania Noemi

Has your issue been resolved? Please checking in to see if the below suggestions helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Best regards,

Aniya

Answer 1

Anonymous

Hi @Velázquez Paulín Tania Noemi

Yes, as Olaf said, according to the official documentation, SQL Server 2022 (16.x) on Linux does not support linked servers for data sources other than SQL Server.

For more details, you can refer to this link: https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2022?view=sql-server-linux-2017#unsupported-features-and-services.

Did these answers help you? If the answer is useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Anonymous

2023-06-05T07:52:36.5833333+00:00

Hi @Velázquez Paulín Tania Noemi

Has your issue been resolved?
If you have any questions, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best regards,
Aniya

Answer 2

If you're looking for drivers or providers for Linux to connect to Oracle and Sybase databases from SQL Server, here are some options:

Oracle:

Oracle Data Provider for .NET (ODP.NET) Core: Oracle provides ODP.NET Core, a cross-platform driver that supports Linux. You can find the driver and installation instructions on the Oracle website. Visit the Oracle Data Provider for .NET Core page (https://www.oracle.com/database/technologies/dotnet-core-downloads.html) for downloads and documentation.

Sybase:

Sybase ASE ODBC Driver for Linux: Sybase offers an ODBC driver for Linux that allows you to connect to Sybase ASE databases from SQL Server. You can obtain the driver from the SAP Downloads page (https://launchpad.support.sap.com/#/softwarecenter/template/products/_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=Y&FUNCTIONBAR=N&EVENT=TREE&NE=NAVIGATE&ENR=01200314690100000648&V=MAINT) by selecting the appropriate version for Linux.

Ensure that you choose the drivers or providers that are compatible with your specific Linux distribution and version.

Before installing the drivers, make sure you review the documentation and follow the installation instructions provided by Oracle and Sybase to ensure a successful setup on your Linux system.

Answer 3

Olaf Helper 47,436

See

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2019?view=sql-server-ver16

=> Unsupported features & services => Database engine => Linked Servers to data sources other than SQL Server

So linked server to Oracle/Sybase in a SQL Server running on Linux is currently not supported.

Share via

Create Linked Server in SQL Server 2022 on Linux

2 additional answers

Your answer