$ sudo zypper in unixODBC unixODBC-devel
####
-- Repositories
https://packages.microsoft.com/sles/12/mssql-server-2017/
https://packages.microsoft.com/sles/15/prod/
https://packages.microsoft.com/opensuse/15/prod/
##
##
$ sudo zypper in mssql-cli mssql-server mssql-tools msodbcsql17
##
##
$ cat /etc/unixODBC/odbcinst.ini
[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.3.so.1.1
UsageCount=2
##
##
$ cat ~/.odbc.conf
[mssql]
Description = A MSSQL databe
Driver = ODBC Driver 17 for SQL Server
Server = fully.qualified.host.name
User = PerlMonk
Password = Password
Database = my_data
##
##
use DBI;
my $dbh = DBI->connect ("dbi:ODBC:mssql");
##
##
$ sudo zypper in freetds-{config,devel,doc,tools} lib{ct4,dbi-drivers-dbd-freetds,sybdb5,tdsodbc0}
##
##
$ cat /etc/unixODBC/odbcinst.ini
[FreeTDS]
Description=FreeTDS unixODBC Driver
Driver=/usr/lib64/libtdsodbc.so.0
Setup=/usr/lib64/libtdsodbc.so.0
UsageCount=1
##
##
$ cat ~/.odbc.conf
[freetds]
Description = A MSSQL databe
Driver = FreeTDS
TDS version = 7.2
Trace = No
Server = fully.qualified.host.name
Port = 1433
User = PerlMonk
Password = Password
Database = my_data
Client Charset = UTF-8
##
##
use DBI;
my $dbh = DBI->connect ("dbi:ODBC:freetds");
##
##
use Data::UUID;
my $uuid_conv = Data::UUID->new;
while (my $row = $sth->fetchrow_hashref) {
$row->{a_uuid} = $uuid_conv->to_string ($row->{a_uuid});
}