MSSQL Access under Linux

[Kevin O'Gorman]

On 3/16/07, Bill Campbell <linux-sxs at celestial.com> wrote:
> On Fri, Mar 16, 2007, Shawn Tayler wrote:
> >Hi Guys,
> >
> >I've been trying to find a way to access a database running on a WindBlows
> >server and MS-SQL.  I plan to port the data into my PostgreSQL database
> >for reports and archiving.  I am looking for a simple commandline
> >interactive client, rather like the psql app for Postgres.  I'll be taking
> >the results of some queries and dumping them to flat files that can be
> >precessed and loaded into my "Real" database.
>
> There are some connectors available for python to allow access to M$SQL,
> and I think the latest versions of sqlobject (an object based python system
> for accessing SQL databases) has M$SQL support.
>
> Bill

There was also the Perl Sybase module.  I worked with SQL Server 2000,
as I used in my thesis work in grad school.  There was a Linux Journal
article about it in the April 2002 issue which gave me everything I needed
to send queries from Linux to the database server.  It seems SQL Server
was derived from Sybase.  I have no idea if it still works.

Good luck.

++ kevin
-- 
Kevin O'Gorman, PhD