Microsoft has supported ODBC in all versions of SQL Server and has committed to continue to support ODBC in future versions of SQL Server. ODBC, which provides a standard way for applications to access databases, is one of the available client library APIs that can provide an interface to TDS. It is not therefore necessary for client applications and SQL Server to run on the same machine. Because TDS can be used over TCP/IP, remote client applications can communicate with SQL Server. SQL Server uses a protocol called Tabular Data Stream ( TDS) for communication between client applications and SQL Server. You can therefore either integrate your Linux and UNIX applications with SQL Server on Windows, retaining the benefits of the full featured version, or have an all Linux SQL Server solution. The driver supports both the Windows and Linux versions of SQL Server. The SQL Server ODBC driver enables you to access SQL Server from applications running on Linux and UNIX platforms. Yes, starting with SQL Server 2017, Microsoft provides a Linux port of SQL Server, which contains "core relational database capabilities".
0 Comments
Leave a Reply. |