- or download this
$ sudo zypper in unixODBC unixODBC-devel
- or download this
-- Repositories
https://packages.microsoft.com/sles/12/mssql-server-2017/
https://packages.microsoft.com/sles/15/prod/
https://packages.microsoft.com/opensuse/15/prod/
- or download this
$ sudo zypper in mssql-cli mssql-server mssql-tools msodbcsql17
- or download this
$ 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
- or download this
$ cat ~/.odbc.conf
[mssql]
...
User = PerlMonk
Password = Password
Database = my_data
- or download this
use DBI;
my $dbh = DBI->connect ("dbi:ODBC:mssql");
- or download this
$ sudo zypper in freetds-{config,devel,doc,tools} lib{ct4,dbi-drivers-
+dbd-freetds,sybdb5,tdsodbc0}
- or download this
$ cat /etc/unixODBC/odbcinst.ini
[FreeTDS]
...
Driver=/usr/lib64/libtdsodbc.so.0
Setup=/usr/lib64/libtdsodbc.so.0
UsageCount=1
- or download this
$ cat ~/.odbc.conf
[freetds]
...
Password = Password
Database = my_data
Client Charset = UTF-8
- or download this
use DBI;
my $dbh = DBI->connect ("dbi:ODBC:freetds");
- or download this
use Data::UUID;
...
while (my $row = $sth->fetchrow_hashref) {
$row->{a_uuid} = $uuid_conv->to_string ($row->{a_uuid});
}