Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
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
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 (Canon) 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 musing on the Monastery: (2)
As of 2014-09-17 02:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (56 votes), past polls