2.13.pre doesn't load on win10

[mfancy-mm]

I on Windows 10 running ruby 2.6.3p62 (2019-04-16 revision 67580) [i386-mingw32]
I have tiny_tds (2.1.3.pre x86-mingw32) installed
When I try to execute me code I get

C:/Ruby26/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require': 126: The specified module could not be found. - C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds/2.6/tiny_tds.so (LoadError)

     9: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:42:in `<top (required)>'
     8: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:33:in `block in <top (required)>'
     7: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:17:in `block in <top (required)>'
     6: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:24:in `rescue in block in <top (required)>'
     5: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:34:in `block (2 levels) in <top (required)>'
     4: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:37:in `block in <top (required)>'
     3: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:43:in `block in <top (required)>'
     2: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:46:in `rescue in block in <top (required)>'
     1: from C:/Ruby26/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require'

C:/Ruby26/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require': cannot load such file -- tiny_tds/tiny_tds (LoadError)

I would have expected this to work.

[aharpervc]

Hm, I can't reproduce.

$ ruby -v
ruby 2.6.3p62 (2019-04-16 revision 67580) [i386-mingw32]

$ ruby .\scratch.rb
2.1.3.pre
{"servername"=>"c83527d2d7ff", "db_name"=>"master"}

Can you try running this script (copy/paste to something like scratch.rb) and confirming it still gets an error? (fill in with your own connection info of course)

require 'tiny_tds'

puts TinyTds::VERSION

c = TinyTds::Client.new({
    host: 'localhost',
    username: 'replace_with_yours',
    password: 'replace_with_yours',

    timeout: 5,
    login_timeout: 5,
})

connected_servername = c.execute("select @@servername servername, db_name() db_name").to_a
puts connected_servername

[a30004475]

FWIW: win10, git-for-windows 2.26.0, ruby+devkit 2.7.1-1-x64

$ ruby -v
ruby 2.7.1p83 (2020-03-31 revision a0c7c23c9c) [x64-mingw32]
$ ruby ./scratch.rb
2.1.3.pre
{"servername"=>"snip", "db_name"=>"master"}

tested using SSPI and explicit username/password.

Interestingly I have had problems installing rake with bundler, had to use gem install rake instead. Not sure if this irrelevant, just noting some weirdness with ruby on windows possibly with git-bash installed because x64-mingw32 is also embedded in git-bash. I am unable to test without git-bash.

[mfancy-mm]

Using irb I have the following results:

X:>irb
irb(main):001:0> require 'tiny_tds'
Traceback (most recent call last):
16: from C:/Ruby26/bin/irb.cmd:31:in load' 15: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/irb-1.0.0/exe/irb:11:in <top (required)>'
14: from (irb):1
13: from C:/Ruby26/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:34:in require' 12: from C:/Ruby26/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:130:in rescue in require'
11: from C:/Ruby26/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:130:in require' 10: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:42:in <top (required)>'
9: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:33:in block in <top (required)>' 8: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:17:in block in <top (required)>'
7: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:24:in rescue in block in <top (required)>' 6: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:34:in block (2 levels) in <top (required)>'
5: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:37:in block in <top (required)>' 4: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:43:in block in <top (required)>'
3: from C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/lib/tiny_tds.rb:46:in rescue in block in <top (required)>' 2: from C:/Ruby26/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require'
1: from C:/Ruby26/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in `require'
LoadError (cannot load such file -- tiny_tds/tiny_tds)
irb(main):002:0>

I realize that it is trying to load some dlls. Should those dlls be in
C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/ports/i686-w64-mingw32/freetds/1.1.24/bin
C:/Ruby26/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3.pre-x86-mingw32/ports/i686-w64-mingw32/openssl/1.1.1d/bin

I tried loading both dlls with regsvr32 and got the error "The specified module could not be found". Are these dlls trying to load something else?

[ecentell-CPF]

I am also unable to repro as my project successfully runs and connects to the database, here are my specifics:

Win 10 Pro Build 1903
ruby 2.6.6p146 (2020-03-31 revision 67876) [x64-mingw32]
tiny_tds (2.1.3.pre-x64-mingw32)

Also FWIW @a30004475 I had that same issue until I ran the following command at an elevated prompt
c:> gem update --system

[mtk72]

I'm also unable to repro as my test with scratch.rb work fine.
Win 10 Enterprise Build 1909
ruby 2.6.6p146 (2020-03-31 revision 67876) [x64-mingw32]

ruby scratch.rb
2.1.3.pre
{"servername"=>"localhost", "db_name"=>"master"}

And I did not need to run gem update

[mfancy-mm]

I just spent some time revisiting this issues. I uninstalled ruby and installed 2.6.3 32bit. Install tiny_tds 2.1.3.pre. This resulted in me getting the same error as before with unable to load ting_tds.so.

I have ruby 2.6.3 64bit install and have no problems running.

[ecentell-CPF]

Since you are mentioning bit versions FWIW I am using:
rubyinstaller-2.6.6-1-x64.exe
msys2-x86_64-20200216 (ran all three options in "RIDK Install")
tiny_tds (2.1.3.pre-x64-mingw32)

Had to download a weekly build version of the toolkit because I ran into an issue keeping MSYS up to date error here msys2/MSYS2-packages#1298 downloaded at https://www.msys2.org/ at the top of the page.

[aharpervc]

Hm, maybe it's only an issue with 32bit? @mfancy-mm can you run gem environment and gem info tiny_tds in your 32bit ruby 2.6.3 installation?

Also, what is the contents of your this folder:
(wherever "gem info tiny_tds" says it's installed at)\gems\tiny_tds-2.1.3.pre-x86-mingw32\lib\tiny_tds\2.6

[ecentell-CPF]

@mfancy-mm If you have a moment can you provide any updated information requested?

[mfancy-mm]

Sorry for the delay getting back to you. Here is the info requested.

gem environment
RubyGems Environment:

• RUBYGEMS VERSION: 3.0.3
• RUBY VERSION: 2.6.3 (2019-04-16 patchlevel 62) [i386-mingw32]
• INSTALLATION DIRECTORY: C:/Ruby26/lib/ruby/gems/2.6.0
• USER INSTALLATION DIRECTORY: C:/Users/ct43244/.gem/ruby/2.6.0
• RUBY EXECUTABLE: C:/Ruby26/bin/ruby.exe
• GIT EXECUTABLE: C:\Program Files\Git\cmd/git.EXE
• EXECUTABLE DIRECTORY: C:/Ruby26/bin
• SPEC CACHE DIRECTORY: C:/Users/ct43244/.gem/specs
• SYSTEM CONFIGURATION DIRECTORY: C:/ProgramData
• RUBYGEMS PLATFORMS:
  • ruby
  • x86-mingw32
• GEM PATHS:
  • C:/Ruby26/lib/ruby/gems/2.6.0
  • C:/Users/ct43244/.gem/ruby/2.6.0
• GEM CONFIGURATION:
  • :update_sources => true
  • :verbose => true
  • :backtrace => false
  • :bulk_threshold => 1000
  • :sources => ["http://rubygems.org"]
• REMOTE SOURCES:
  • http://rubygems.org
• SHELL PATH:
  • C:\Ruby26\bin
  • C:\Ruby26\msys32\mingw32\bin
  • C:\Progra~2\Sybase\DataAccess64\ADONET\dll
  • C:\Progra~2\Sybase\DataAccess\ADONET\dll
  • C:\Progra~2\Sybase\DataAccess64\ODBC\dll
  • C:\Progra~2\Sybase\DataAccess\ODBC\dll
  • C:\Progra~2\Sybase\DataAccess64\OLEDB\dll
  • C:\Progra~2\Sybase\DataAccess\OLEDB\dll
  • C:\Progra~2\Sybase\OCS-15_0\lib3p64
  • C:\Progra~2\Sybase\OCS-15_0\lib3p
  • C:\Progra~2\Sybase\OCS-15_0\dll
  • C:\Progra~2\Sybase\OCS-15_0\bin
  • C:\progra~2\Sybase\DBISQL\bin
  • C:\Program Files (x86)\Teradata\Client\13.10\CLIv2\
  • C:\Program Files (x86)\Teradata\Client\13.10\bin\
  • C:\Program Files (x86)\Teradata\Client\13.10\ODBC Driver for Teradata\Lib\
  • C:\Program Files (x86)\Teradata\Client\13.10\Shared ICU Libraries for Teradata\lib\
  • C:\Program Files\Teradata\Client\13.10\CLIv2\
  • C:\Program Files\Teradata\Client\13.10\bin\
  • C:\Program Files\Teradata\Client\13.10\ODBC Driver for Teradata nt-x8664\Lib\
  • C:\Program Files\Teradata\Client\13.10\Shared ICU Libraries for Teradata\lib\
  • C:\progra~2\Sybase15\DC_TDS
  • C:\progra~2\Sybase15\DataAccess\ADONET\dll
  • C:\progra~2\Sybase15\DataAccess\OLEDB\dll
  • C:\progra~2\Sybase15\DataAccess\ODBC\dll
  • C:\progra~2\Sybase15\OCS-15_0\lib3p
  • C:\progra~2\Sybase15\OCS-15_0\dll
  • C:\progra~2\Sybase15\OCS-15_0\bin
  • C:\ProgramData\Oracle\Java\javapath
  • C:\WINDOWS\system32
  • C:\WINDOWS
  • C:\WINDOWS\System32\Wbem
  • C:\WINDOWS\System32\WindowsPowerShell\v1.0\
  • C:\WINDOWS\System32\OpenSSH\
  • C:\Program Files (x86)\Box\Box Edit\
  • C:\Program Files\Git\cmd
  • C:\Users\CP75750\AppData\Local\Microsoft\WindowsApps
  • C:\Program Files\Microsoft VS Code\bin
  • C:\PROGRA~2\ASF\maven-2.0.9\bin
  • C:\Program Files (x86)\Notepad++
  • C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\
  • C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\
  • C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\
  • C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\
  • C:\Program Files (x86)\Appeon\Shared\PowerBuilder\
  • C:\Users\ct43244\AppData\Local\Microsoft\WindowsApps

gem info tiny_tds

*** LOCAL GEMS ***

tiny_tds (2.1.3.pre)
Platform: x86-mingw32
Authors: Ken Collins, Erik Bryn, Will Bond
Homepage: http://github.com/rails-sqlserver/tiny_tds
License: MIT
Installed at: C:/Ruby26/lib/ruby/gems/2.6.0

TinyTDS - A modern, simple and fast FreeTDS library for Ruby using
DB-Library.

dir c:\Ruby26\lib\ruby\gems\2.6.0\gems\tiny_tds-2.1.3.pre-x86-mingw32\lib\tiny_tds\2.6
Volume in drive C is OSDisk
Volume Serial Number is 4E7D-A2DA

Directory of c:\Ruby26\lib\ruby\gems\2.6.0\gems\tiny_tds-2.1.3.pre-x86-mingw32\lib\tiny_tds\2.6

06/08/2020 11:05 AM

.
06/08/2020 11:05 AM ..
06/08/2020 11:05 AM 31,232 tiny_tds.so
1 File(s) 31,232 bytes

[ecentell-CPF]

Can you provide an update for next steps @aharpervc ?

[aharpervc]

The next steps are for someone to figure out why 2.1.3.pre doesn't seem to load with 32bit ruby 2.6. I myself don't know why this is happening. I think this is a blocker for publishing the final release, because if we publish a broken release that will create a lot of pain for people, which I think we'd all prefer to avoid.

We're all open to ideas! One thing I thought of is if someone with this environment can build their own copy of the gem and it works, then maybe we can compare it to the current gem and see what's up.