Stack Overflow
Stack Overflow

Questions tagged [tiny-tds]

TinyTDS is a Ruby library to access Microsoft SQL Server databases using FreeTDS.

149 questions
13
votes
7 answers

Failing to bundle install tiny_tds on Mac OS X 10.8 with Homebrew FreeTds

MY QUESTION What are some surefire steps I can take to 100% get this working? I would need real instructions, not one liner answers or vague conceptual descriptions of the process. Let's get to the bottom of this. It would appear that there are…
Joshua F. Rountree
  • 1,462
  • 2
  • 14
  • 30
13
votes
1 answer

Parameterizing SQL queries in Ruby + TinyTDS

I am trying to figure out how to parameterize an SQL string before handing it off to be executed, but sadly I find a lot of this on the internet: sql = "SELECT * FROM table_name WHERE thing LIKE '%#{input}%'" Which is a bad thing...however,…
yurisich
  • 6,991
  • 7
  • 42
  • 63
9
votes
4 answers

"Closed connection error" while trying to connect Ruby to SQL server

This is the code I'm using to connect to SQL server 2012 express. My file's name is Connect.rb. require "rubygems" require "tiny_tds" client = TinyTds::Client.new( :username => 'sa', :password =>…
Richard77
  • 20,343
  • 46
  • 150
  • 252
7
votes
4 answers

Homebrew / TinyTDS / FreeTDS bundle error

I used homebrew (linux port) to install freeTDS and am trying to deploy /bundle install my app with gem tinytds. I get this error output when doing bundle install Installing tiny_tds (0.5.1) with native extensions…
wantrapreneur
  • 410
  • 4
  • 13
7
votes
4 answers

Error installing TinyTDS on OSX 10.6 via gem install tiny_tds

I have been trying to install the TinyTDS gem on a Macbook with OSX 10.6. I was successful in installing Free TDS -- confirmed that it works via: tsql -H SERVER -p 1433 -U username. The error I'm getting from gem install tiny_tds is: Building…
Jaypoc
  • 73
  • 1
  • 6
6
votes
3 answers

TinyTDS: Server name not found in configuration files

I keep seeing this error, and I am unable to connect to the database on the remote server. I am given a connection string to the database, that looks like the following: data source=qsss.gar.de\SQL2012,3000;initial catalog=City;persist security…
zwiebl
  • 685
  • 2
  • 11
  • 24
6
votes
2 answers

Execute ruby script from cron

My script uses mysql, tiny_tds, fileutils, and net/ftp. Running on ruby 1.9.3. It works perfectly fine when I run it from inside the folder. However, when I add it to cron tab, tiny_tds constantly fails. I dont know if any of the other gems fail…
Mike
  • 463
  • 3
  • 8
  • 22
6
votes
1 answer

Install freetds on Heroku

I'm looking for a step by step guide, how to install freetds on Heroku. I need to access Sql Server from ruby script, and unfortunately Cedar doesn't support tinytds gem out of box. I've read whatever information there is available on internet,…
Jack Juiceson
  • 830
  • 4
  • 12
  • 24
5
votes
1 answer

Homebrew, FreeTDS, tiny_tds. Why can't I install tiny_tds after successfully installing FreeTDS?

This issue led me to this question. I expected that to solve my issue, a couple of the answers there detail some config params that can help with the installation. The paths weren't quite right for me so I modified them and ended up with this: gem…
gdgr
  • 1,435
  • 2
  • 15
  • 31
5
votes
2 answers

installing tiny_tds gives error on on mac os 10.10.5

I am using mac os and I want to connect to sql server by using ruby driver. I want to use tiny_tds but it gives error for missing free_tds but it was already installed. How can pass this? ~ brew install freetds Warning: freetds-0.91.112 already…
Mesut GUNES
  • 7,089
  • 2
  • 32
  • 49
5
votes
1 answer

Heroku FreeTDS, how to use Rasil SQL Server with TinyTDS with Multi Buildpacks

I have to use the "Tiny TDS" gem with my Rails 4.2.3 and of course on cedar-14 of Heroku I can't because FreeTDS is not anymore on it. How to use FreeTDS on Heroku cedar-14? I'm looking on the web and I found…
user4412054
5
votes
1 answer

TinyTds Error: Adaptive Server connection timed out

We are running a ruby on rails application on rails 3.2.12 (ruby 1.9.3) with current tinyTDS gem 0.6.2. We use MS SQL 2012 or 2014 and facing more then usual the following error message: TinyTds::Error: Adaptive Server connection timed out: EXEC…
YvesR
  • 5,922
  • 6
  • 43
  • 70
5
votes
3 answers

Rails with two different Databases

I have used two different databases for my Rails application: MongoDB and MsSQL using Mongoid and activerecord-sqlserver-adapter adapter respectively. Everything is well but there is a problem while generate Model. The problem is "how can I…
Ganesh Kunwar
  • 2,643
  • 2
  • 20
  • 36
4
votes
0 answers

Rake causing LoadError: libruby.so.2.1: cannot open shared object file - file exists

I am trying to use the chef community cookbook opsworks_ruby to deploy a rails app. I am currently running into an issue with one of my gems, tiny_tds version 0.9.5.beta.10. When trying to migrate the database with the following…
Aristata
  • 610
  • 2
  • 9
  • 18
4
votes
1 answer

How to extend activerecord and tinytds timeout?

The symptom is: TinyTds::Error: Adaptive Server connection timed out: EXEC some_stored_procedure It's execute_procedure a slow stored procedure on a slow MSSQL Server via ActiveRecord over tinytds. If I EXEC the stored procedure in SQL Query…
ohho
  • 50,879
  • 75
  • 256
  • 383
1
2 3
…
9 10