Solved

Remote connection to SQL Server database from Ubuntu

Posted on 2006-10-24
5
278 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
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Automating a script for user accounts LINUX 14 70
Trying to make SNMP connection work 7 66
parse convert xml feed to text (python) 2 71
Remove a folder in Linux 9 91
Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
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.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now