Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

fail: Linux Perl-DBI to SQL Server

by madmole (Novice)
on May 15, 2013 at 20:23 UTC ( #1033737=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. 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
  2. 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
  3. or download this
    [ODBC Driver 11 for SQL Server]
  4. or download this
    [ODBC Driver 11 for SQL Server]
    Description=Microsoft ODBC Driver 11 for SQL Server
  5. or download this
    Description         = Test
    Trace               = Yes
    TraceFile           = /home/madmole/sql.log
    Database            = Mosaic
  6. or download this
    | Connected!                            |
    SQLRowCount returns 0
    888 rows fetched
  7. or download this
    select * from Award
  8. or download this
    % cat
    ***Error connecting to DSN
    ***Error was:
    ***[unixODBC][Driver Manager]Data source name not found, and no defaul
    +t driver specified (SQL-IM002)
  9. or download this
    my $dsn="dbi:ODBC:driver={tul1system};server=tul1system;database=Mosai
    my $dsn="dbi:ODBC:driver={tul1system};server=tul1system;database=Mosai
    my $dsn="dbi:ODBC:driver=tul1system;server=tul1system;database=Mosaic"
    my $dsn="dbi:ODBC:driver=tul1system;server=tul1system;database=Mosaic;
    my $dsn="dbi:ODBC:driver={ODBC Driver 11 for SQL Server};server=tul1sy

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1033737]
Approved by bart
Front-paged by Corion
[marto]: good morning all
[Corion]: On another topic, in the process of Rubber Duck SoPWing, I wrote a post about the best API for generating HTTP requests (not sending them) and while writing it and fleshing out my sample implementation, I came up with some improvements to my ...
[Corion]: ... existing prototype. Cartesian Products will be proud of that module once it gets out ;)
[Corion]: Hi marto ;)
LanX has the same problem with English accents ...
[LanX]: Will Cartesian Products still be tarif free after Brexit?

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2017-01-18 10:21 GMT
Find Nodes?
    Voting Booth?
    Do you watch meteor showers?

    Results (161 votes). Check out past polls.