Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

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
    SQLSETPOSIROW Size.: 8
    
  3. or download this
    [tul1system]
    [ODBC Driver 11 for SQL Server]
    
  4. 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
    
  5. or download this
    [tul1system]
    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
    go
    [...]
    
  8. 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)
    
  9. 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";
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1033737]
Approved by bart
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (11)
As of 2014-08-29 23:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (289 votes), past polls