Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: Sql server + DBI package + freetds module = problem :)

by Melly (Hermit)
on Jan 25, 2007 at 12:03 UTC ( #596456=note: print w/replies, xml ) Need Help??

in reply to Sql server + DBI package + freetds module = problem :)

That connect string looks... odd. ("Sybase"?)

My sql-server connect strings tend to look like:

use DBI; my $data_source = "dbi:ODBC:driver={SQL Server};Server=$host;database= +$database;uid=$login;pwd=$password;"; my $dbcon = DBI->connect_cached($data_source,$login,$password,{PrintEr +ror=>0,RaiseError=>0,AutoCommit=>1});
map{$a=1-$_/10;map{$d=$a;$e=$b=$_/20-2;map{($d,$e)=(2*$d*$e+$a,$e**2 -$d**2+$b);$c=$d**2+$e**2>4?$d=8:_}1..50;print$c}0..59;print$/}0..20
Tom Melly,

Replies are listed 'Best First'.
Re^2: Sql server + DBI package + freetds module = problem :)
by imp (Priest) on Jan 25, 2007 at 14:12 UTC

      Apart from the excellent resources mentioned above, the only really tricky part of all this was that I never did get DBD::Sybase to work for any version later than 0.91. You might be encountering a similar problem ... ?

Re^2: Sql server + DBI package + freetds module = problem :)
by roboticus (Chancellor) on Jan 25, 2007 at 14:31 UTC

    For your amusement:

    The "Sybase" token makes a bit more sense when you look at the history of MS SQL Server. MS acquired the code from Sybase (around version 4.2, if I recall correctly), and grew it from there. I originally learned databases on Sybase, and when I moved to MS SQL Server, I was quite surprised at how nearly *all* of my experience and favorite scripts worked without modification.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://596456]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (3)
As of 2018-03-23 10:04 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (289 votes). Check out past polls.