Posts Tagged 'odbc'

MS SQL Server with Linux

I was wondering if this is possible, and it seems that it is.  I am using Ubuntu 7.10.

First I installed unixodbc and tdsodbc packages.  Then I mainly followed the instructions here starting at the “Configuration” part.  These were the key, because in my ignorance I tried editing odbc.ini directly and was also looking at /etc/freetds/freetds.conf which I don’t think is actually used when running with ODBC.

I can now use:-

isql <dsnname> <username> <password>

…and get a console to type arbitrary SQL in.  I tried using OpenOffice.org’s oobase, and although it connects and shows me a list of tables, it can’t seem to query any of them due to malformed SQL.  I’m not sure where the problem lies, but I was just experimenting.

Ideally I’d like to find something a bit like SQL Server Management Studio Express as a front-end, because I use that a lot.  I run a work site hosted on ASP.NET with a MSSQL backend, and I often have to run raw SQL to get around the lack of proper admin pages because the lazy developer (i.e. me) hasn’t written them yet.

While browsing package lists, I spotted mention of GNOME Data Access (gda) which has a freetds backend, so I will check that out too.

More links:-