The Open Database Connectivity, shortly called ODBC, is a standard API (Application Programming Interface) for accessing the DBMS (Database Management System). Let us see the step-by-step approach to Creating ODBC Connection for SQL Server in Windows 10.
In this article, we'll show how to install the appropriate ODBC drivers for SQL Server, how to configure ODBC to connect to a SQL Server instance and more.
ODBC is a universal database connection that works like a bridge between the GIS software and the back-end databases such as MySQL, SQL Server, PostgreSQL and many others.