I'm having the same problem as Tom. I can connect to the SQL Server
and run a "select *" from iSQL, so I believe that ruby-odbc bindings
are using iODBC instead of unixODBC
% tsql -C
Compile-time settings (established with the "configure" script)
Version: freetds v0.82
freetds.conf directory: /usr/local/Cellar/freetds/0.82/
etc
MS db-lib source compatibility: yes
Sybase binary compatibility: no
Thread safety: yes
iconv library: yes
TDS version: 8.0
iODBC: no
unixodbc: yes
% ruby extconf.rb --with-odbc-dir=/usr/local/lib
checking for version.h... yes
checking for sql.h... yes
checking for sqlext.h... yes
checking for SQLTCHAR in sqltypes.h... yes
checking for SQLLEN in sqltypes.h... yes
checking for SQLULEN in sqltypes.h... yes
checking for odbcinst.h... yes
checking for SQLAllocConnect() in -lodbc... no
checking for SQLAllocConnect() in -liodbc... yes
checking for SQLConfigDataSource() in -lodbcinst... no
checking for SQLConfigDataSource() in -liodbcinst... yes
checking for SQLInstallerError() in odbcinst.h... yes
creating Makefile
On Sep 24, 5:09 am, Iljun Kim <[email protected]>
wrote:
> If switching to the unixODBC is an option for you, you may try the
> following.
>
> - Install unixODBC.
> Download it from "http://www.unixodbc.org/"; and configure it something
> like,
> "./configure --prefix=/usr/local/unixODBC-2.2.14 --enable-gui=no".
>
> - Install freeTDS with
> "./configure --prefix=/usr/local/freetds-0.82
> --with-unixodbc=/usr/local/unixODBC-2.2.14".
>
> - Configure /usr/local/unixOBCD-2.2.14/etc/odbc.init and odbcinst.ini
>
> - Download ruby-odbc-0.9997 from "http://www.ch-werner.de/rubyodbc/";,
> create the Makefile with
> "ruby extconf.rb --with-odbc-lib=/usr/local/unixODBC-2.2.14/lib", and
> install
>
> Hope it helps.
> --IJ
>
> TomRossi7 wrote:
> > Has anyone been able to get Rails talking to Microsoft SQL Server from
> > OSX Snow Leopard? In the past with Leopard, I used the instructions
> > found here:http://wiki.rubyonrails.org/database-support/ms-sql. But
> > with Snow Leopard I get the following error when I try to access an
> > ActiveRecord object:
>
> > /usr/local/lib/ruby/gems/1.8/gems/dbd-odbc-0.2.4/lib/dbd/odbc/
> > statement.rb:41: [BUG] Segmentation fault
> > ruby 1.8.7 (2009-06-12 patchlevel 174) [i686-darwin10.0.0]
>
> > Any help is appreciated!
>
> > Thanks,
> > Tom
>
> --
> Posted viahttp://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
