Change driver under /etc/odbc.ini

Before:

[root@testbox ~]# grep -i ‘^Driver’ /etc/odbc.ini
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1
[root@testbox ~]#

Action Taken:

[root@testbox ~]# sed -i ‘s|/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1|/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.6.1|g’ /etc/odbc.ini
[root@testbox ~]#

After:

[root@testbox ~]# grep -i ‘^Driver’ /etc/odbc.ini
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.6.1
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.6.1
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.6.1
Driver = /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.6.1
[root@testbox ~]#