Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am looking to upgrade my company computers at work to Ubuntu from Windows XP, however we have a bespoke MS Access program that connects to our MS SQL server in the USA. Is there away to connect using FreeTDS and writing the bespoke program in Libreoffice Base. If so how would I connect this. Detailed instructions would be nice.

Many thanks.

share|improve this question
up vote 1 down vote accepted

I am not clear if you are using windows or linux clients, so ...

There is a whole wiki page on how to configure just this here:

It describes configuration for windows and linux clients, including Ubuntu.

Edit for a MS SQL database see

It appears to be working from the comments, but I do not have a MS SQL server to confirm.

share|improve this answer
he ask for MS(microsoft) SQL not MY – Matteo Pagliazzi Dec 18 '11 at 19:33
@Matteo Pagliazzi - missed that, thanks. – bodhi.zazen Dec 18 '11 at 19:37
Thanks I will give it a go. Btw I have Ubuntu with liber office and want to connect to an mssql server. – Shaneo1 Dec 19 '11 at 1:12
Thanks for the advice this helped. Although JTDS is very slow to collect data from MSSQL – Shaneo1 Jan 13 '13 at 17:10

Hre you can find out

share|improve this answer
it is for openoffice but should work also for libreoffice – Matteo Pagliazzi Dec 18 '11 at 19:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.