MS_SQL Connectivity

[Vu Pham]

On Thu, 2007-05-17 at 04:57 -0700, Shawn Tayler wrote:
> 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.
> 

Have you tried JDBC drivers ( which require you to use Java ) ? There
are many jdbc drivers for mssql and postgresql. 

Vu