Re: [RailsSQLServer] Adaptive Server is unavailable or does not exist

[KlausKohlbauer]

Hello,

you have activated the TCP/IP-Connections in the Sql Server Config-Tool?

Freundliche Grüße

Klaus Kohlbauer infosense gmbh Tel   +49 (89) 12 11 35 59 Mobil +49 (173) 999 777 9 Mail  klaus.k...@infosense.de Web   www.infosense.de

 

 

Ursprüngliche Nachricht

Von:	Arul Amirtharaj <aru...@gmail.com>
Am:	Fr, 31.07.2015 - 02:12
An:	rails-sqlse...@googlegroups.com
Betreff:	[RailsSQLServer] Adaptive Server is unavailable or does not exist

Hi All

 

I am using tiny_tds to connect MS SQL server through ruby.

 

 

Below is my ruby code to connect:

 

#--------------------------------------------------

 

require "rubygems"

 

require "tiny_tds"

 

 

 

#client = TinyTds::Client.new(:username => 'dhc\\zxxxx', :password => '11xxxx', :dataserver => 'txxxxsql0001\\PRDISP',:database => 'ISIS')

 

 

client = TinyTds::Client.new(:username => 'dhc\\xxxx4', :password => '11xxxx', :host => 'Txxxsql0001.sxxx.txxxx.com', :port =>1433 )

 

#result = client.execute("SELECT * FROM t_mod_item where dept_i=31")

 

puts client.dead?

 

puts client.active?

 

result.each

 

puts result.affected_rows

 

result.each do |row|

 

puts row

 

end

puts client.close

puts client.closed?

 

#---------------------------------------------------

 

its displays  

 

Unable to connect: Adaptive Server is unavailable or does not exist (T9816sql0001.stores.target.com:1433) (TinyTds::Error).

 

 

Any one can help on this?

 

Thanks

Arul

 

--
You received this message because you are subscribed to the Google Groups "Rails SQLServer Adapter" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rails-sqlserver-a...@googlegroups.com.
To post to this group, send email to rails-sqlse...@googlegroups.com.
Visit this group at http://groups.google.com/group/rails-sqlserver-adapter.
For more options, visit https://groups.google.com/d/optout.

---

infosense gmbh, Donnersbergerstr. 9, D-80634 München
Telefon: 089 / 12 11 35 59
Internet: http://www.infosense.de
Registergericht: Amtsgericht München
Registernummer: HRB 175784
Vertretungsberechtiger Geschäftsführer: Dipl. Kfm. Klaus Kohlbauer

Diese Information ist vertraulich und ausschließlich für die adressierte Person bestimmt. Sollten Sie diese Nachricht irrtümlich erhalten haben, bitten wir Sie, sich mit dem Absender in Verbindung zu setzen und das Material (die Mail nebst etwaigen Anhängen) von Ihrem Computer zu löschen, ohne eine Kopie davon zurückzubehalten.

This message is confidential and only intended for the recipient. Should you not be the intended recipient you are kindly asked to advise the sender immediately by reply e-mail and delete this message and all attachments without keeping a copy.

---