Select Code to Download

Select or download this

  Perl            : 5.014002    (x86_64-linux-gnu-thread-multi)
  OS              : linux    (3.2.0-37-generic)
...
  DBD::ExampleP   : 12.014310
  DBD::DBM        : 0.08

Select or download this

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

Select or download this

[tul1system]
[ODBC Driver 11 for SQL Server]

Select or download this

[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

Select or download this

[tul1system]
Description         = Test
...
Trace               = Yes
TraceFile           = /home/madmole/sql.log
Database            = Mosaic

Select or download this

'+---------------------------------------+
| Connected!                            |
...
[...]
SQLRowCount returns 0
888 rows fetched

Select or download this
```
select * from Award
go
[...]
```

Select or download this

% cat simple.pl
#!/usr/bin/perl
...
***Error connecting to DSN
***Error was:
***[unixODBC][Driver Manager]Data source name not found, and no defaul
+t driver specified (SQL-IM002)

Select or download this

my $dsn="dbi:ODBC:driver={tul1system};server=tul1system;database=Mosai
+c";
my $dsn="dbi:ODBC:driver={tul1system};server=tul1system;database=Mosai
+c;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=tul1sy
+stem;database=Mosaic;user=iser334;pwd=2BEvPog";