Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
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?
[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
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you watch meteor showers?




    Results (161 votes). Check out past polls.