-
Notifications
You must be signed in to change notification settings - Fork 0
Platform Installation Mac
The method for getting the SQL Server stack on Mac OS X is pretty much the same no matter which OS version you have. This article covers some of the finer points of Snow Leopard and x86_64 compatibility but can be applied to pretty much any version that MacPorts targets.
Recently, I have built on the article above and written another on how to use Ruby Enterprise Edition with the SQL Server stack. The title is Installing REE With The Snow Leopard SQL Server Stack
Being the maintainer of the SQL Server adapter, this is the setup I use with RVM to install additional ruby interpreters with the unixODBC ruby gem. The RVM Ruby API – Setting Up A CI System For The SQL Server Adapter
Using the built in iODBC with Mac OS 10.6.0 will cause a segmentation fault with FreeTDS. A patch is available at iODBC.org
This package contains a bug-fix for the version of iODBC provided by Apple, installing in /usr; this is recommend for compiling interfaces such as Perl DBD::ODBC, the Ruby ODBC bridge and PHP: Mac OS X (10.5 Leopard, 10.6 Snow Leopard) iodbc-usr-sdk.zip
penwellr: I installed FreeTDS on 10.6 with the above patch using MacPorts. After that I was able to establish a connection using a DSNless string such as the following settings:
production: adapter: sqlserver mode: :ODBC username: sa password: password_goes_here database: database_goes_here dsn: DRIVER=/opt/local/lib/libtdsodbc.so;SERVER=server_goes_here;DATABASE=database_goes_here;UID=sa;PWD=password_goes_here
Put together by Brennan Dunn.
Homebrew Project-Specific RVM, Passenger, ENV Vars
Hugh Evans wrote a simple article that details how far HomeBrew has come and possibly how simple it is to use now for the adapter.
Homebrew, FreeTDS and RubyODBC
Jon Kinney wrote this article on making sure your local settings are correct for the FreeTDS connection to SQL Server.
Change locale on os x snow leopard for FreeTDS functionality