MSSQL Access under Linux
Mon Mar 26 06:13:07 PDT 2007
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.
> 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