MSSQL Access under Linux

[Shawn Tayler]

On Sat, 17 Mar 2007 17:11:15 +1100 (EST) "James McDonald"
<james at jamesmcdonald.id.au> exclaimed:

> 
> > 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.
> >
> > Suggestions as to where to look?
> >
> >
> Install UnixODBC on your Linux box.
> 
> Create a standard SQL User and password on windows with full access to
> the db.
> 
> Using that user and UnixODBC connect to the database.
> 
> 
> You can use OpenOffice and suck the data out of it.
> 
> http://www.unixodbc.org/doc/FreeTDS.html
> 
> -- 
> James McDonald

Thank you James.

I'm giving this a whirl.  I have it built built it wants to use X to make
a DSN.  I am having some difficulty with this as the machine it'll be
running on isn't really in a position to run X.

But I'll muddle through.

Thanks again guys.

Shawn