Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re^2: connecting Perl with MS SQL Server on NT using ODBC

by Secalles (Initiate)
on Dec 29, 2011 at 16:30 UTC ( #945527=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    use DBI;
    
    ...
    
    my $DSN = "driver={SQL Server};server=$server;database=$database_name;
    +uid=$user;pwd=$pass"; 
    my $DBH = DBI->connect("DBI:ODBC:$DSN") or die "Couldn't open database
    +: $DBI::errstr\n";
    
  2. or download this
    DBI connect('driver={SQL Server};server=localhost\WHATSUP:3477;databas
    +e=equip;uid=rodrigo;pwd=123456','',...) failed: [Microsoft][ODBC SQL 
    +Server Driver][DBNETLIB]Invalid connection. (SQL-08001) [st
    ate was 08001 now 01000]
    ...
    Couldn't open database: [Microsoft][ODBC SQL Server Driver][DBNETLIB]I
    +nvalid connection. (SQL-08001)
     [state was 08001 now 01000]
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (ParseConn
    +ectParams()). (SQL-01000)
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://945527]
help
Chatterbox?
[ambrus]: Corion: ah, so you want a library that parses HTTP, and you want to do the IO yourself, and don't want a full AnyEvent wrapper.
[ambrus]: Corion: I think I parsed a HTTP header from a string with LWP once. You can definitely use that to create a HTTP message too. The problme is
[ambrus]: that if you do that, you'd have to find where each HTTP response ends, which is nontrivial if you want persistent connections (essential for performance if you have small requests).

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (11)
As of 2016-12-07 15:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (130 votes). Check out past polls.