Solved

Remote connection to SQL Server database from Ubuntu

Posted on 2006-10-24
5
289 Views
Last Modified: 2013-12-16
Hi

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 OpenOffice.org Database. This seems to allow ODBC connections to remote databases but when I try and select this option I get a message saying that libodbc.so.1 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?  

Thanks.
0
Comment
Question by:Nicola-H
[X]
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
5 Comments
 
LVL 1

Expert Comment

by:Paracelsius
ID: 17928567
Hi Nicola-H

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

Regards
pC.
0
 
LVL 1

Author Comment

by:Nicola-H
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.
0
 
LVL 1

Accepted Solution

by:
Paracelsius earned 350 total points
ID: 17937862
Hi

In this case you need FreeTDS (http://www.freetds.org/) in order to connect a remote MS Sql Server.

Ubuntu has packages for this ;)

HTH,
pC.
0

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