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?