MS_SQL Connectivity

[Shawn Tayler]

Hi Guys,

I am still struggling with getting a commandline connection to a MS_SQL
box from my linux PostgreSQL server.  I got unixODBC built and have been
trying to use FREETDS with it to no avail so far.  I was hoping someone
could tell me if this is a good approach or if there may be another
simpler way.

My basic need is to pull data from a number of local and remote (Private
WAN) MS-SQL boxes.  The sed and awk the stuff to pull it into tables in
my PostgreSQL box for report generation.  I mostly worried that I am
spinning my wheels.

I have heard about a Perl module called DBI.  I'm not a Perl guy but would
be willing to learn it if you think it would help.

Thanks!

Shawn