Connecting to a remote MS SQL Server database from Mac OS X

As part of an e-commerce site I'm working on, I had a need to update my product data with data for available inventory from a supplier.  In this case, the supplier didn't provide a feed, but simply provided access to its MS SQL Server database, which meant that I had to connect to the database, query the table for new and changed records, and determine which records had been deleted.  The trick in all this is connecting from a *nix system to a Microsoft database.  On a Windows PC, I would just define an ODBC connection, but since that capability does not exist natively in *nix, it needs to be added.

continue reading >>

Sep 4