?
Solved

Remote connection to SQL Server database from Ubuntu

Posted on 2006-10-24
5
Medium Priority
?
308 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 1400 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

rdate is a Linux command and the network time protocol for immediate date and time setup from another machine. The clocks are synchronized by entering rdate with the -s switch (command without switch just checks the time but does not set anything). …
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses
Course of the Month13 days, 14 hours left to enroll

801 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