Tiny_TDS doesn't include pre-compiled native gems for x64 Ruby on Windows.

[edward-ellis]

I am using Tiny TDS on Windows 10 with Ruby 2.1.7 x64. All my gems work except tiny_tds. If I switch to the x86 version of Ruby all is well. Do you intend to support x64 Ruby versions on Windows?

[edward-ellis]

If you don't intend to support x64, at least indicate that in the README.

[metaskills]

It was my understanding that we always supported 64-bit windows for all Ruby versions we support including 2.1. Till recently we had builds on Appveyor for multiple x64 versions. Even tho only one remains (for 2.3) the others should still work fine.

• https://github.com/rails-sqlserver/tiny_tds/blob/master/Rakefile#L97
• https://github.com/rails-sqlserver/tiny_tds/blob/master/appveyor.yml#L40-L41

Could you investigate a bit more and let me know what you find.

[coderjoe]

When working on PR #322 I could have sworn I saw it building x64 binaries.

[metaskills]

You did!

[edward-ellis]

Ok, I don't really understand the internal workings of installing gems. All I know is that only the .so version gets installed. Can you give me some guidance on how to gather information that would be useful to you?

[metaskills]

Sure, maybe start with a few things and we can go from there.

• What version of TinyTDS are you using? Do have the same problem with other versions?
• For the version you are having issues with, if you bundle open the gem, what do you see in the lib/tiny_tds dir?

[edward-ellis]

I am using tiny_tds_1.0.5-x64-mingw32. I haven't other versions yet today. In the lib/tiny_tds dir I see:

• bin.rb
• client.rb
• error.rb
• result.rb
• version.rb
• 2.0
  -- tiny_tds.so
• 2.1
  -- tiny_tds.so
• 2.2
  -- tiny_tds.so
• 2.3
  -- tiny_tds.so

[edward-ellis]

I have installed 1.0.3 and 1.0.0 and get the same results. For bundle open I still only get the tiny_tds.so.

[coderjoe]

Each of those are libraries cross compiled for the windows architecture and runtime in their gem package name. As an example here's a file inspection from my recent testing build:

coderjoe@pulsar:public/tiny_tds/pkg[openssl-1.0.2j]% ls
tiny_tds-1.0.6/     tiny_tds-1.0.6-x64-mingw32/     tiny_tds-1.0.6-x86-mingw32/
tiny_tds-1.0.6.gem  tiny_tds-1.0.6-x64-mingw32.gem  tiny_tds-1.0.6-x86-mingw32.gem
coderjoe@pulsar:public/tiny_tds/pkg[openssl-1.0.2j]% file tiny_tds-1.0.6-x64-mingw32/lib/tiny_tds/2.3/tiny_tds.so 
tiny_tds-1.0.6-x64-mingw32/lib/tiny_tds/2.3/tiny_tds.so: PE32+ executable (DLL) (console) x86-64, for MS Windows
coderjoe@pulsar:public/tiny_tds/pkg[openssl-1.0.2j]% file tiny_tds-1.0.6-x86-mingw32/lib/tiny_tds/2.3/tiny_tds.so 
tiny_tds-1.0.6-x86-mingw32/lib/tiny_tds/2.3/tiny_tds.so: PE32 executable (DLL) (console) Intel 80386, for MS Windows
coderjoe@pulsar:public/tiny_tds/pkg[openssl-1.0.2j]%

What problem are you experiencing that led you to investigate these binaries?

[coderjoe]

@edward-ellis can you provide any extra information?

[edward-ellis]

Yes, I found it confusing that the DLLs were given a Linux suffix, but I suppose that is just a convenience for the developers. I also started asking questions on gitter.im and @coderjoe suggested that this is the same problem as issue #310. It certainly sounds like the "tiny_tds.so not a valid win32 application" part of that issue. They were suggesting that version 1.0.6 might fix that issue, but that has yet to be released.

[metaskills]

Once #324 is resolved, I plan to release v1.1 using the new versions of all the good things. I really do help this helps.

[metaskills]

Just wanted to report, I am seeing the same issue on the adapter tests in Appveyor which use the Windows pre-compiled gems. The -x64 Ruby versions shows this error for v1.0.5 of TinyTDS

`require': cannot load such file -- tiny_tds/tiny_tds (LoadError)

I did find that v1.0.4 did seems to work so I think this is an issue with v1.0.5.

[coderjoe]

@metaskills that sounds a lot like the invalid win32 executable problem my PR tries to address. You can verify this on appveyor by running the build and enabling RDP via: https://www.appveyor.com/docs/how-to/rdp-to-build-worker/

If you log into the instance you can verify the problem is the same by testing to make sure tiny_tds can be required if it is the only required gem, but it will likely fail if yaml (or psych.so) are loaded first.

If it matches, there's a good chance that my already merged PR will solve your problem. You can also try testing with the tiny_tds_coderjoe gem which I used for testing and plan to yank once 1.0.6 or 1.1.0 are out.

[metaskills]

I just released v1.1.0 (thanks @coderjoe) and it appears to fix the x64 issues on Appveyor. Please confirm it helps here too.