Perl            : 5.014002	(x86_64-linux-gnu-thread-multi)
  OS              : linux	(3.2.0-37-generic)
  DBI             : 1.625
  DBD::Sponge     : 12.010002
  DBD::Proxy      : install_driver(Proxy) failed: Can't locate RPC/PlClient.pm in @INC
  DBD::ODBC       : 1.43
  DBD::Gofer      : 0.015326
  DBD::File       : 0.41
  DBD::ExampleP   : 12.014310
  DBD::DBM        : 0.08


##</code><code>##

unixODBC 2.3.0
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /home/madmole/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

##</code><code>##

[tul1system]
[ODBC Driver 11 for SQL Server]

##</code><code>##

[ODBC Driver 11 for SQL Server]
Description=Microsoft ODBC Driver 11 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Threading=1
UsageCount=1

[tul1system]
Description=Microsoft ODBC Driver 11 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Threading=1
UsageCount=1

##</code><code>##

[tul1system]
Description         = Test
Driver              = /opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Trace               = Yes
TraceFile           = /home/madmole/sql.log
Database            = Mosaic
[ODBC Driver 11 for SQL Server]
Description         = Test
Driver              = /opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Trace               = Yes
TraceFile           = /home/madmole/sql.log
Database            = Mosaic

##</code><code>##

'+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> help
[...]
SQLRowCount returns 0
888 rows fetched

##</code><code>##

select * from Award
go
[...]

##</code><code>##

% cat simple.pl
#!/usr/bin/perl
use DBI;
my $dsn="dbi:ODBC:driver={ODBC Driver 11 for SQL Server};server=tul1system;database=Mosaic"; # SOLVED: keyword "DRIVER=" needs to be all caps
my $dbh = DBI->connect($dsn, "user334", "2BEvPog");

if (! defined($dbh) ) {
	print "***Error connecting to DSN\n";
	print "***Error was:\n";
	print "***$DBI::errstr\n";         # $DBI::errstr is the error
}

% simple.pl
DBI connect('driver={ODBC Driver 11 for SQL Server};server=tul1cspeldb02;database=Mosaic','user334',...) failed: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002) at ./simple.pl line 6
***Error connecting to DSN
***Error was:
***[unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002)

##</code><code>##

my $dsn="dbi:ODBC:driver={tul1system};server=tul1system;database=Mosaic";
my $dsn="dbi:ODBC:driver={tul1system};server=tul1system;database=Mosaic;user=user334;pwd=2BEvPog";
my $dsn="dbi:ODBC:driver={tul1system};server=tul1system;database=Mosaic";
my $dsn="dbi:ODBC:driver={tul1system};server=tul1system;database=Mosaic;user=user334;pwd=2BEvPog";
my $dsn="dbi:ODBC:driver=tul1system;server=tul1system;database=Mosaic";
my $dsn="dbi:ODBC:driver=tul1system;server=tul1system;database=Mosaic;user=user334;pwd=2BEvPog";
my $dsn="dbi:ODBC:driver={ODBC Driver 11 for SQL Server};server=tul1system;database=Mosaic;user=iser334;pwd=2BEvPog";