Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

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, pm@tomandlu.co.uk


Comment on Re: Sql server + DBI package + freetds module = problem :)
Select or Download Code
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
    Melly:

    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.

    --roboticus

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (7)
As of 2015-07-28 04:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (252 votes), past polls