MSSQL Access under Linux

Shawn Tayler stayler
Mon Mar 26 06:13:07 PDT 2007

On Sat, 17 Mar 2007 17:11:15 +1100 (EST) "James McDonald"
<james at> 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.
> -- 
> 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.


More information about the Linux-users mailing list