Free ODBC Driver for SQL Server: A Step-by-Step Guide

The free ODBC driver for SQL Server is a valuable tool for developers and administrators who need to connect their Linux-based applications to Microsoft SQL Server databases. In this article, we will walk you through the installation process of the Progress DataDirect SQL Server ODBC driver for Linux.

Installation Process

To begin the installation process, download the DataDirect Connect64_for_ODBC_71.zip file from the official website and extract it to a directory on your system. Once extracted, navigate to the directory and run the installer using the following command:

`/home/progress/Progress/DataDirect/Connect64_for_ODBC_71/install.sh`

The installer will prompt you to agree to the license agreement and enter your details like name and company. Make sure to read the terms carefully before agreeing.

Choosing the Driver

After agreeing to the terms, you will be shown a list of drivers to choose from. For this tutorial, we will choose option 2, which is the SQL Server Wire Protocol driver.

Installing the Driver

Once you have chosen the driver, you will be prompted to confirm the default path or enter a different path where you have access. Make sure to choose a path that has sufficient disk space and meets your system's requirements.

Activating the Product (Optional)

If you have a license for the Progress DataDirect SQL Server ODBC driver, you can enter the appropriate Serial Number and Key to activate the product. If you are trying out the free version, simply enter `EVAL` as the Serial Number and Key.

The free ODBC driver for SQL Server is a powerful tool that allows developers and administrators to connect their Linux-based applications to Microsoft SQL Server databases. By following the steps outlined in this article, you should be able to successfully install and activate the Progress DataDirect SQL Server ODBC driver for Linux. With this driver, you can unlock the full potential of your SQL Server database and take advantage of its advanced features and functionality.

Free odbc driver for sql server