"Cannot load such file -- tiny_tds/tiny_tds" (version 1.1.0, version 1.0.0 is OK)

[bradder555]

Using Windows 7, Enterprise, with MS-SQL 2014 64-bit developer running locally

Using ruby 2.2.4p230 (2015-12-16 revision 53155) [i386-mingw32] and
gem 2.4.5.1

SQL server authentication is enabled,
Named pipes and TCP is enabled,

tiny_tds installed (i get the exact same issue with the 32 bit version):

> gem list | grep tiny_tds
tiny_tds (1.1.0 x64-mingw32)

FreeTDS is installed:

>tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v1.00.9
             freetds.conf directory: c:
     MS db-lib source compatibility: no
        Sybase binary compatibility: no
                      Thread safety: yes
                      iconv library: no
                        TDS version: 7.0
                              iODBC: no
                           unixodbc: no
              SSPI "trusted" logins: yes
                           Kerberos: no
                            OpenSSL: yes
                             GnuTLS: no
                               MARS: no

from irb i require tiny_tds and get:

irb(main):001:0> require 'tiny_tds'
LoadError: cannot load such file -- tiny_tds/tiny_tds
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:121:in `require'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:121:in `require'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/gems/2.2.0/gems/tiny_tds-1.1.0-x64-mingw32/lib/tiny_tds.rb:22:in `rescue in <top (required)>'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/gems/2.2.0/gems/tiny_tds-1.1.0-x64-mingw32/lib/tiny_tds.rb:25:in `<top (required)>'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:128:in `require'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:128:in `rescue in require'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:39:in `require'
        from (irb):1
        from C:/RailsInstaller/Ruby2.2.0/bin/irb:11:in `<main>'

I modified the tiny_tds.rb file to get an idea of what is going on:

if RUBY_PLATFORM =~ /mingw|mswin/ && RUBY_VERSION =~ /(\d+.\d+)/
  ver = Regexp.last_match(1)
  # Set the PATH environment variable, so that the DLLs can be found.
  old_path = ENV['PATH']
  begin
    print "begin \n"
    # Do the same host consolidation as in extconf.rb
    ports_dir = RbConfig::CONFIG['host'].gsub('i686-pc-mingw32', 'i686-w64-mingw32')
    ENV['PATH'] = "#{File.expand_path("../../ports/#{ports_dir}/bin", __FILE__)};#{old_path}"
	print "ENV['PATH'] = ... \n"
	print "require \"tiny_tds/#{ver}/tiny_tds \n"
    require "tiny_tds/#{ver}/tiny_tds"
  rescue LoadError
	print "LoadError \n"
    require 'tiny_tds/tiny_tds'
  ensure
	print "ensure \n"
    ENV['PATH'] = old_path
  end
else

and get this:

irb(main):004:0> require 'tiny_tds'
begin
ENV['PATH'] = ...
require "tiny_tds/2.2/tiny_tds
LoadError
ensure
begin
ENV['PATH'] = ...
require "tiny_tds/2.2/tiny_tds
LoadError
ensure
LoadError: cannot load such file -- tiny_tds/tiny_tds
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:121:in `require'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:121:in `require'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/gems/2.2.0/gems/tiny_tds-1.1.0-x64-mingw32/lib/tiny_tds.rb:26:in `rescue in <top (required)>'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/gems/2.2.0/gems/tiny_tds-1.1.0-x64-mingw32/lib/tiny_tds.rb:30:in `<top (required)>'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:128:in `require'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:128:in `rescue in require'
        from C:/RailsInstaller/Ruby2.2.0/lib/ruby/2.2.0/rubygems/core_ext/kernel_require.rb:39:in `require'
        from (irb):4
        from C:/RailsInstaller/Ruby2.2.0/bin/irb:11:in `<main>'
irb(main):005:0>

The path "tiny_tds/2.2/tiny_tds" contains:
tiny_tds.so

The tiny_tds folder contains:

• 2.0 (folder, contains tiny_tds.so)
• 2.1 (folder, contains tiny_tds.so)
• 2.2 (folder, contains tiny_tds.so)
• 2.3 (folder, contains tiny_tds.so)
• 2.4 (folder, contains tiny_tds.so)
• bin.rb
• client.rb
• error.rb
• result.rb
• version.rb

So not sure what i'm missing? is there meant to be a compilation step when importing the gem? because that doesn't appear to be happening

If I uninstall and reinstall:

>gem uninstall tiny_tds
Remove executables:
        defncopy, tsql

in addition to the gem? [Yn]  y
Removing defncopy
Removing tsql
Successfully uninstalled tiny_tds-1.1.0-x64-mingw32

>gem install tiny_tds
Fetching: tiny_tds-1.1.0-x86-mingw32.gem (100%)
Successfully installed tiny_tds-1.1.0-x86-mingw32
Parsing documentation for tiny_tds-1.1.0-x86-mingw32
Installing ri documentation for tiny_tds-1.1.0-x86-mingw32
Done installing documentation for tiny_tds after 1 seconds
1 gem installed

if i go irb and require, i get exactly the same issue.

[metaskills]

is there meant to be a compilation step when importing the gem?

No. We push pre-compiled native gems for the Windows platform that have statically linked FreeTDS and friends to Rubygems. This is what we use Miniportile/Docker to accomplish. I suspect there is a gem install command that can ignore the platform detection but I would have to Google for it.

Not sure why you are having the require issue?

[coderjoe]

I notice that your tsql -C command says it's using freetds 1.00.9, which is interesting since tiny_tds 1.1.0 is compiled against its own patched version of 1.00.21.

Is there a chance you've installed your own copy of FreeTDS libraries are taking precidence over tiny_tds's version?

If you'd like a better picture of what's being loaded (or failing to load), you can install the Microsoft Sysinternals Suite and use procmon filtered only for load events in your freetds and ruby directories.

This will show you where it's looking for DLLs, what it's loading, and what it can't find. If it's loading openssl, libiconv, or freetds libraries external to the tiny_tds gem there's a chance they might be causing the problem.

It may also be a good idea to check the actual LoadError exception being thrown and caught in your modified gem to see what its exception actually says.

[bradder555]

I had installed freetds and put it on the path, i deleted it and removed the path reference, that didn't help though

(just confirmed, uninstalled v 1.0.0, reinstalled v 1.1.0, get the same issue)

[coderjoe]

Darned, there goes the easy solution. The next step is to actually debug the load error and try and find the source. Unfortunately I do not have any Windows 7 environments (enterprise or otherwise) to help test. Please do investigate and let us know what you find!

[bradder555]

Yes will do! :)

[Insood]

+1 for the same issue. Upgraded from 1.0.5 to 1.1.0.

C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/tiny_tds-1.1.0-x86-mingw32/lib/tiny_tds.rb:22:in `require': cannot
load such file -- tiny_tds/tiny_tds (LoadError)
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/tiny_tds-1.1.0-x86-mingw32/lib/tiny_tds.rb:22:in `resc
ue in <top (required)>'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/tiny_tds-1.1.0-x86-mingw32/lib/tiny_tds.rb:25:in `<top
 (required)>'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/bundler-1.12.5/lib/bundler/runtime.rb:86:in `require'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/bundler-1.12.5/lib/bundler/runtime.rb:86:in `block (2
levels) in require'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/bundler-1.12.5/lib/bundler/runtime.rb:81:in `each'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/bundler-1.12.5/lib/bundler/runtime.rb:81:in `block in
require'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/bundler-1.12.5/lib/bundler/runtime.rb:70:in `each'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/bundler-1.12.5/lib/bundler/runtime.rb:70:in `require'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/bundler-1.12.5/lib/bundler.rb:102:in `require'
        from V:/gpopov/Documents/Projects/BMS/config/application.rb:8:in `<top (required)>'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/railties-4.1.14/lib/rails/commands/commands_tasks.rb:7
9:in `require'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/railties-4.1.14/lib/rails/commands/commands_tasks.rb:7
9:in `block in server'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/railties-4.1.14/lib/rails/commands/commands_tasks.rb:7
6:in `tap'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/railties-4.1.14/lib/rails/commands/commands_tasks.rb:7
6:in `server'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/railties-4.1.14/lib/rails/commands/commands_tasks.rb:4
0:in `run_command!'
        from C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/railties-4.1.14/lib/rails/commands.rb:17:in `<top (req
uired)>'
        from bin/rails:4:in `require'
        from bin/rails:4:in `<main>'

[metaskills]

@Insood What is your platform/os?

[Insood]

Hi! Sorry - got distracted.

It's Microsoft Windows 7 Professional (6.1.7601 Service Pack 1 Build 7601). Ruby is ruby 2.1.5p273 (2014-11-13 revision 48405) [i386-mingw32]. Everything was initially installed with rails installer some time ago.

Downgrading to 1.0.5 "fixes" things.

I have freeTDS installed in C:/FreeTDS

Compile-time settings (established with the "configure" script)
                            Version: freetds v0.91RC2
             freetds.conf directory: /mingw/etc
     MS db-lib source compatibility: no
        Sybase binary compatibility: no
                      Thread safety: yes
                      iconv library: yes
                        TDS version: 7.0
                              iODBC: no
                           unixodbc: yes
              SSPI "trusted" logins: no
                           Kerberos: no

However, it's not in the global PATH. Doing tsql -C gets me this:

W:\insood\Documents\Projects\BMS>tsql -C
[TinyTds][v1.1.0][tsql]: C:/RailsInstaller/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/tiny_tds-1.1.0-x86-mingw32/exe/tsql.EXE

[metaskills]

@Insood Two things:

• TinyTDS now requires at least 0.95 but you really should use latest 0.99 or better 1.x
• Why worry about having FreeTDS installed at all? The Windows gems have TinyTDS statically linked.

[Insood]

It looks like it may be an issue with LIBSYBDB-5.DLL.

I've opened up

A: C:\RailsInstaller\Ruby2.3.0\lib\ruby\gems\2.3.0\gems\tiny_tds-1.1.0-x86-mingw32\ports\i686-w64-mingw32\bin\libsybdb-5.dll
B: C:\RailsInstaller\Ruby2.3.0\lib\ruby\gems\2.3.0\gems\tiny_tds-1.0.5-x86-mingw32\ports\i686-w64-mingw32\bin\libsybdb-5.dll

And there's an error opening up (A) because it can't find "LIBGCC_S_SJLJ-1.DLL"

It does not look like LIBGCC_S_SJLJ-1.DLL is used by (B)

[coderjoe]

Thank you very much for the report. I'll take a peek shortly!

[coderjoe]

@Insood Do you happen to have the DevKit installed for your version of the RubyInstaller? I'm working off a theory that it works on all my test machines because the library is provided by the devkit but not the base installer...

Can you please confirm the following:

1. Are you running RubyInstaller-x32 on a 64bit architecture?
2. You do not have devkit installed

If so I think I have a reproduction case and can begin debugging. :)

[coderjoe]

@Insood if you get a moment could you please confirm or deny the above assumptions? It could save me hours and hours of testing if you could. :)

[Insood]

Hi @coderjoe ,

Sorry for late response. I'm running the following:

ruby:
bin: C:/RailsInstaller/Ruby2.0.0/bin/ruby.exe
version: ruby 2.3.3p222 (2016-11-21 revision 56859) [i386-mingw32]

rails:
bin: C:/RailsInstaller/Ruby2.0.0/bin/rails.bat
version: Rails 5.0.1

Windows:
version: Microsoft Windows 7 Professional (6.1.7601 Service Pack 1 Build 7601).
bits: 64

RailsInstaller comes with devkit (C:\RailsInstaller\DevKit). There's a C:\RailsInstaller\DevKit\mingw\bin\libgcc_s_sjlj-1.dll

My PATH has the following:

PATH=C:\RailsInstaller\Git\cmd;C:\RailsInstaller\Ruby2.3.0\bin;C:\RailsInstaller
\Ruby2.3.0\lib\ruby\gems\1.9.1\bin;C:\RailsInstaller\DevKit\bin;C:\ImageMagick-7
.0.2-Q16;C:\Program Files\ImageMagick-7.0.2-Q16;C:\Users\insood\AppData\Local\En
thought\Canopy\User\Lib\site-packages\PyQt4;C:\Program Files (x86)\NVIDIA Corpor
ation\PhysX\Common;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C
:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Windows\syst
em32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v
1.0;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7
IDE;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn;c:\Program File
s\Microsoft SQL Server\100\Tools\Binn;c:\Program Files (x86)\Microsoft SQL Serv
er\100\DTS\Binn;C:\Program Files\nodejs;c:\Program Files\Microsoft SQL Server
100\DTS\Binn;c:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\Pri
vateAssemblies;C:\Program Files (x86)\Skype\Phone;C:\Program Files\Microsoft S
QL Server\120\Tools\Binn;C:\Program Files (x86)\Windows Kits\10\Windows Perform
ance Toolkit;C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\bin;C:\Prog
ram Files\Microsoft SQL Server\110\Tools\Binn;C:\Program Files (x86)\Microsoft
SQL Server\Client SDK\ODBC\130\Tools\Binn;C:\Program Files (x86)\Microsoft SQL
Server\130\Tools\Binn;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn
;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio;C:
\RailsInstaller\Git\cmd;C:\RailsInstaller\Ruby2.3.0\bin;C:\Users\insood\AppData
Local\Enthought\Canopy\User;C:\Users\insood\AppData\Local\Enthought\Canopy\User
Scripts;C:\Users\insood\AppData\Roaming\npm