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:-

Advertisements

0 Responses to “MS SQL Server with Linux”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s





%d bloggers like this: