Tiny_tds: Connect: Server name not found in the configuration files

ruby tiny-tds
Richard77 picture Richard77 · Oct 13, 2012 · Viewed 7.7k times · Source 
require "rubygems"
require "tiny_tds"

client = TinyTds::Client.new(:username => 'sa', :password => '', :host => 'RICHARD_PC\SQLEXPRESS')
result = client.execute("SELECT * FROM [Contacts]")

result.each do |row|
   //Do something
 end

I keep getting the same error: "Connect: Server name not found in the configuration files". All I need to do is to be at least be able to connect with Sql Server. So if the host is not the sqlexpress instance installed on my machine, what is it then? In the Github website it said this host => 'mydb.host.net' (:host - Used if :dataserver blank. Can be an host name or IP.)

Thanks for helping.

Answer

Klaus picture Klaus · Oct 13, 2012

Either use :dataserver => 'RICHARD_PC\SQLEXPRESS' Or use :host => 'RICHARD_PC', :port => 1433

Related questions

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 …

Read More
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 sp_executesql [...] Database …

Read More
How to check if a value exists in an array in Ruby

I have a value 'Dog' and an array ['Cat', 'Dog', 'Bird']. How do I check if it exists in the array without looping through it? Is there a simple way of checking if the value exists, nothing more?

Read More