Remote connection to SQL Server database from Ubuntu

Posted on 2006-10-24
Last Modified: 2013-12-16

I have Ubuntu 6.06 installed and am trying to work out how to connect to a remote SQL Server database. I need to administer the database via some sort of GUI ideally. I've had a look around and can't see anything. I have also tried with Database. This seems to allow ODBC connections to remote databases but when I try and select this option I get a message saying that is missing.

Is it possible to do what I want with an ODBC connection or am I barking up the wrong tree? Is it just a question of installing the library file and setting up a local connection?  

Question by:Nicola-H
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 17928567
Hi Nicola-H

What kind of "remote SQL database" are you trying to administer?


Author Comment

ID: 17928614
Hi. It's a SQL Server 2000 database on a remote server. I won't be able to test any solutions for a while because my lappy has blown up, but I am still looking for suggestions. I'm using the Open Office database app to administer the Access databases, but can not find anything to help me access the main SQL Server one.

Accepted Solution

Paracelsius earned 350 total points
ID: 17937862

In this case you need FreeTDS ( in order to connect a remote MS Sql Server.

Ubuntu has packages for this ;)


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How many times have you wanted to quickly do the same thing to a list but found yourself typing it again and again? I first figured out a small time saver with the up arrow to recall the last command but that can only get you so far if you have a bi…
SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question