Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^2: What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?

by blackadder (Hermit)
on Oct 12, 2009 at 13:00 UTC ( [id://800701]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    #! c:/perl/bin/perl.exe
    #
    ...
    #$dbh = DBI->connect("DBI:ODBC:driver={SQL Server};Server=$server;Data
    +base=$database;UID=$dbusername;PWD=$dbpassword") ||  die "$Error_Mess
    +age $DBI::errstr";
    
    $dbh = DBI->connect("DBI:ODBC:dsnname;Server=$server;Database=$databas
    +e;UID=$dbusername;PWD=$dbpassword")
    
  2. or download this
    U:\Doccuments\Scripts\Start>db2.pl
    DBI connect('dsnname;Server=ABCB00062\Dev;Database=ukdevxxxx;UID=uk_gg
    +g\\xyz12345;
    PWD=7seven7','',...) failed: [Microsoft][ODBC Driver Manager] Data sou
    +rce
    name not found and no default driver specified (SQL-IM002) at U:\Doccu
    +ments\Scri
    pts\Start\db2.pl line 32
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://800701]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2024-04-14 07:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found