Problem installing tiny_tds with x64-mingw32 and ruby 2.0.0p0

[vinodadhikary]

I'm trying to install tiny_tds under Windows 7 x64. Has anybody had any success? Following is the output:

C:\ruby\DevKit\bin>gem install tiny_tds
ruby 2.0.0p0 (2013-02-24) [x64-mingw32]

Temporarily enhancing PATH to include DevKit...
Building native extensions.  This could take a while...
ERROR:  Error installing tiny_tds:
        ERROR: Failed to build gem native extension.

    C:/ruby/Ruby200-x64/bin/ruby.exe extconf.rb
checking for iconv_open() in iconv.h... no
checking for iconv_open() in -liconv... no
-----
libiconv is missing.
-----
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers.  Check the mkmf.log file for more details.  You may
need configuration options.

Provided configuration options:
        --with-opt-dir
        --without-opt-dir
        --with-opt-include
        --without-opt-include=${opt-dir}/include
        --with-opt-lib
        --without-opt-lib=${opt-dir}/lib
        --with-make-prog
        --without-make-prog
        --srcdir=.
        --curdir
        --ruby=C:/ruby/Ruby200-x64/bin/ruby
        --enable-lookup
        --disable-lookup
        --with-iconv-dir
        --without-iconv-dir
        --with-iconv-include
        --without-iconv-include=${iconv-dir}/include
        --with-iconv-lib
        --without-iconv-lib=${iconv-dir}/
        --with-freetds-dir
        --without-freetds-dir
        --with-freetds-include
        --without-freetds-include=${freetds-dir}/include
        --with-freetds-lib
        --without-freetds-lib=${freetds-dir}/
        --with-iconvlib
        --without-iconvlib


Gem files will remain installed in C:/ruby/Ruby200-x64/lib/ruby/gems/2.0.0/gems/tiny_tds-0.5.1 for inspection.
Results logged to C:/ruby/Ruby200-x64/lib/ruby/gems/2.0.0/gems/tiny_tds-0.5.1/ext/tiny_tds/gem_make.out

[metaskills]

The gems for the Windows platform are all pre-build and do not require building from source. So you are not getting the wrong one. Why I am not sure. Also, I have not updated the native gems to account for Ruby 2.0 too, I'll have to talk to @luislavena about that or read up on his warnings to the general public about that and rake-compiler

[luislavena]

@metaskills thing is that the user is using x64-mingw32, what is something new, 64bits Ruby 2.0

Since Ruby 2.0 breaks ABI, extensions compiled for 1.9.3 will not work against 2.0.0 because they link to a different libruby shared library (DLL)

Now, to be able to provide pre-compiled binaries for x64-mingw32, will also require a cross-compiler for it, which I still don't have for OSX (only linux)

I haven't worked out lot of details but rake-compiler might not be able to solve the fatter gem issue, bundling 1.8.x, 1.9.x and 2.0.x into the same gem 😢

[sevk]

2.0.x how to fix it :

e:/Ruby200/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:in `r
equire': cannot load such file -- tiny_tds/tiny_tds (LoadError)
        from e:/Ruby200/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_requir
e.rb:45:in `require'
        from e:/Ruby200/lib/ruby/gems/2.0.0/gems/tiny_tds-0.5.1-x86-mingw32/lib/
tiny_tds.rb:16:in `rescue in <top (required)>'
        from e:/Ruby200/lib/ruby/gems/2.0.0/gems/tiny_tds-0.5.1-x86-mingw32/lib/
tiny_tds.rb:12:in `<top (required)>'

[luislavena]

@sevk you need to force compilation of the gems, as explained in RubyInstaller 2.0.0 announcement:

https://groups.google.com/d/topic/rubyinstaller/mg5ailNICvM/discussion

* Existing pre-compiled gems are not Ruby 2.0 compatible 

Ruby 2.0 introduces ABI breakage which means compiled C extensions with previous 
1.9.3 will work with Ruby 2.0. 

DO NOT install Ruby 2.0 on top of existing Ruby 1.9.3, or try to use compiled 
extensions with it. 

You will be required to force compilation of those gems: 

    gem install <name> --platform=ruby 

This will require you have the extra dependencies required for that gem to 
compile. Look at the gem documentation for the requirements. 

That means you will need to look at TinyTDS documentation and build FreeTDS to be able to use the extension with Ruby 2.0.0

[sevk]

when I run :

gem install tiny_tds --platform=ruby

it say:

ERROR:  Error installing tiny_tds:
        ERROR: Failed to build gem native extension.

    E:/Ruby200/bin/ruby.exe extconf.rb
checking for iconv_open() in iconv.h... no
checking for iconv_open() in -liconv... no
-----
libiconv is missing.
-----

I think tiny_tds need use Encoding::Converter in ruby2.0 and ruby1.9 instead of iconv :

Encoding::Converter 

[metaskills]

No, this is FreeTDS that wants it and what the c compiler wants, it should get. FWIW, I have tested TinyTDS with Ruby 2.0 and it works fine. Then again, I am using a POSIX system with installed dependencies. For Windows users, we are going to have to wait for rake-compiler to be solved.

[bollard]

Having the same issue as OP, having upgraded to Ruby 2.0.0. Do i need to explicitly include FreeTDS, if so - how?

[jpierson]

metaskills, is there a link you could share to this issue for the rake-compiler on Windows?

[luislavena]

@jpierson is the same issue as nokogiri and others:

sparklemotion/nokogiri#864

[jpierson]

@luislavena, Thanks for pointing out the link. It appears that this means that the issue posted on the Redmine website regarding support for Ruby 2.0 on Windows only applies to those running 64bit. Not sure how possible or easy it is to attempt running Ruby/Redmine as 32bit on Windows as we commonly do with .NET applications. I mention this here because they linked directly to this issue as the reason why "SQL Server support is reported broken with ruby 2.0.0 under Windows" and I'm just trying to get to the facts with limited knowledge of Ruby. Can somebody confirm my assumptions?

[sevk]

ok , an other err:

C:\>ruby -v
ruby 2.0.0p195 (2013-05-14) [i386-mingw32]

C:\>gem -v
2.0.6

C:\Documents and Settings\Administrator>gem install tiny_tds
Fetching: tiny_tds-0.6.1-x86-mingw32.gem (100%)
Successfully installed tiny_tds-0.6.1-x86-mingw32
Parsing documentation for tiny_tds-0.6.1-x86-mingw32
unable to convert "\x90" from ASCII-8BIT to UTF-8 for lib/tiny_tds/tiny_tds.so,
skipping
Installing ri documentation for tiny_tds-0.6.1-x86-mingw32
1 gem installed

[bollard]

Now rake-compiler has been updated, is it likely we will see an update to tiny_tds some point soon?

[dicom]

Im struggling with tiny_tds on Ruby 2.0 on Windows too, and would love to see an update on this issue.

For my part, installation seems to complete successfully, but I get an error when trying to load the gem:

H:\Downloads\Ruby>gem install tiny_tds --platform=ruby -- --with-freetds-dir=c:\programfiler\freetds
Successfully installed tiny_tds-0.6.1-x86-mingw32
Parsing documentation for tiny_tds-0.6.1-x86-mingw32
Installing ri documentation for tiny_tds-0.6.1-x86-mingw32
Done installing documentation for tiny_tds after 0 seconds
Done installing documentation for tiny_tds (0 sec).
1 gem installed

H:\Downloads\Ruby>irb
DL is deprecated, please use Fiddle
irb(main):001:0> require 'tiny_tds'
LoadError: 126: Den angitte modulen ble ikke funnet.   - C:/Ruby/lib/ruby/gems/2.0.0/gems/tiny_tds-0.6.1-x86-mingw32/lib
/tiny_tds/tiny_tds.so
    from C:/Ruby/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:in `require'
    from C:/Ruby/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:in `require'
    from C:/Ruby/lib/ruby/gems/2.0.0/gems/tiny_tds-0.6.1-x86-mingw32/lib/tiny_tds.rb:16:in `rescue in <top (required)>'
    from C:/Ruby/lib/ruby/gems/2.0.0/gems/tiny_tds-0.6.1-x86-mingw32/lib/tiny_tds.rb:12:in `<top (required)>'
    from C:/Ruby/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:110:in `require'
    from C:/Ruby/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:110:in `rescue in require'
    from C:/Ruby/lib/ruby/2.0.0/rubygems/core_ext/kernel_require.rb:35:in `require'
    from (irb):1
    from C:/Ruby/bin/irb:12:in `<main>'

[luislavena]

@dicom are you sure you're specifying --platform=ruby ?

Just by doing it it should have not installed x86-mingw32 gem and instead should have used tiny_tds-0.6.1.gem

Can you please uninstall the gem and perform the installation steps again? Also, can you describe what is inside c:\programfiler\freetds?

It needs to contain a 32bits set of headers and libraries for Ruby and RubyGems properly compile and link against.

Thank you.