Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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

2 Answers 2

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:

http://wiki.services.openoffice.org/wiki/Connect_MySQL_and_Base

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

Edit for a MS SQL database see

http://www.finefrog.com/2008/04/14/connecting-to-an-mssql-server-and-others-with-openofficeorg/

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 http://www.finefrog.com/2008/04/14/connecting-to-an-mssql-server-and-others-with-openofficeorg/

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

Your Answer

 
discard

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.