Undefined method connect for TinyTds::Client In Windows

[sithara]

I 'm trying to install tiny_tds in my windows machine.

This is the result I get when I tsql -C

[TinyTds][v1.1.0][tsql]: C:/Ruby22/lib/ruby/gems/2.2.0/gems/tiny_tds-1.1.0-x86-
ingw32/exe/tsql.EXE

This is the error message I get when I try executing
TinyTds::Client.new(username: "xx", password: "xxx", host: "xxxx", database: "xxxxxx")

NoMethodError: undefined method `connect' for #<TinyTds::Client:0x2eda828>
       from C:/Ruby22/lib/ruby/gems/2.2.0/gems/tiny_tds-1.1.0-x86-mingw32/lib/t
iny_tds/client.rb:53:in `initialize'
       from (irb):12:in `new'
       from (irb):12
       from C:/Ruby22/bin/irb:11:in `<main>'

[metaskills]

Hmm... I have not seen that one before. I hints at no compiled binary. Could you please install the latest 1.2.0 prerelease. You can do that by bundling to 1.2.0.beta1 in your Gemfile or by doing gem install tiny_tds --pre. Which ever works for you. Interested in hearing if that helps.

[metaskills]

Pull Request #347 pulled in OpenSSL v1.1.0 and we got new versions of TinyTDS at v1.2.0 which should solve this issue. Please reply back and let us know.

[sithara]

NoMethodError: undefined method connect' for #<TinyTds::Client:0x2b77ba0> from C:/Ruby22/lib/ruby/gems/2.2.0/gems/tiny_tds-1.2.0.beta1-x86-mingw32 /lib/tiny_tds/client.rb:53:in initialize'
from (irb):7:in `new'
from (irb):7

Same error :(

[metaskills]

Ouch! Would you mind trying the official release of v1.2.0? I doubt it would be different but worth a shot. What platform are you on? Can you do a gem fetch and unpack (google it) to see if the lib/tiny_tds/tiny_tds is present? Maybe try a require 'tiny_tds/tiny_tds' in IRB before hand?

[sithara]

@metaskills Yes the require 'tiny_tds' does not work . It throws an error. But it says my gem has installed successfully. I'm on windows 7 !

[metaskills]

@sithara Sorry to hear about the problems. Could you try to find a version that works for you? Using this list (https://rubygems.org/gems/tiny_tds/versions) jumping to each last minor release. Ex:

$ gem install -v 0.9.5.rc.3
$ irb
> gem 'tiny_tds, '0.9.5.rc.3'
> require 'tiny_tds'
> # test connection 

And then like below to the next. And so on.

$ gem install -v 0.7.0
$ irb
> gem 'tiny_tds, '0.7.0'
> require 'tiny_tds'
> # test connection 

I'd be interested in if an older version worked for you on Windows 7.

[orgads]

libsybdb-5.dll depends on libgcc_s_sjlj-1.dll which is not installed by default.

Maybe we should use -static-libgcc for freetds?

[coderjoe]

That might work around it for the 1.2 branch. Another work around is to ensure devkit is loaded in your path before loading the project. Devkit comes with the appropriate libgcc_s_sjlj-1.dll for its build environment.

[orgads]

Right, but most users don't have devkit...

[coderjoe]

True but until the real issue is fixed it's very simple to install devkit and rails installer seems to come with it pre-installed correct?