• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

Remote connection to SQL Server database from Ubuntu

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
Nicola-H
Asked:
Nicola-H
  • 2
1 Solution
 
ParacelsiusCommented:
Hi Nicola-H

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

Regards
pC.
0
 
Nicola-HAuthor Commented:
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
 
ParacelsiusCommented:
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

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now