[Omaha.pm] MS-SQL access from Perl

[Jay Hannah]

[ Dave: Oops, you weren't subscribed to this list yet, so your message didn't post. Looks like you did subscribe now, so you should be fine. ]

I've heard rumors you can use JDBC nowadays, so you might try that first.

   http://search.cpan.org/~vizdom/DBD-JDBC-0.71/JDBC.pod

But what I've always used everywhere is FreeTDS + DBD::Sybase:

   http://freetds.org/
   http://search.cpan.org/~mewp/DBD-Sybase-1.10/Sybase.pm

Did you get it working?

Jay Hannah
Software Architect
jhannah at mutationgrid.com
1-402-598-7782



On Aug 20, 2010, at 12:00 AM, omaha-pm-owner at pm.org wrote:
> From: Dave Thacker <dthacker at bluestrain.net>
> Date: August 20, 2010 12:00:08 AM CDT
> To: omaha-pm at pm.org
> Subject: MS-SQL access from Perl
> 
> In a previous life, I used to build out perl configurations that allowed perl 
> to query and update  MS-SQL databases.   This probably would have been the MS-
> SQL 2000 or 2003 flavors. 
> 
> I now find myself in need of that mojo again, this time hitting MS-SQL 2008 
> databases.   
> 
> I remember needing
> -Perl (of course)
> -DBD:Sybase
> -A TDP linux package?
> -Lots of forced module installs?
> 
> I have not GTFI yet, but I'll happily read any links sent my way. 
> 
> DT
> dthacker at bluestrain.net