http://www.perlmonks.org?node_id=596456


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});

[download]
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

[download]
Tom Melly, pm@tomandlu.co.uk

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
[reply]

      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 ... ?

[reply]
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

[reply]

In Section Seekers of Perl Wisdom