Phillip Gawlowski wrote:
>  -----BEGIN PGP SIGNED MESSAGE-----
>  Hash: SHA1
>  
>  Anukul Singhal wrote:
>  | Hi,
>  |
>  | I am using the following code snippet for connecting to SQL Server
>  | through Active Record:
>  |
>  | require 'rubygems'
>  | require 'active_record'
>  |
>  | ActiveRecord::Base.establish_connection(
>  | :adapter => "sqlserver",
>  | :host => "xxx.xxx.xxx.xxx,8080"
>  | :username => "username"
>  | :password => "password"
>  | :database => "xyz_1008"
>  | )
>  |
>  | Now, I want to execute a query in this sql server after getting
>  | successfully connected but am not aware how to do so. Can anyone give an
>  | example as to how we write the query say ("Select * from Name") after
>  | establishing the above connection successfully?
>  
>  ar.rubyonrails.com
>  
>  Look for #find, or #find_by_sql.
>  
>  - --
>  Phillip Gawlowski
>  Twitter: twitter.com/cynicalryan
>  Blog: http://justarubyist.blogspot.com
>  
>  You write with ease to show your breeding,
>  But easy writing 's curst hard reading.
>  ~ -- Richard Brinsley Sheridan (1751-1816)
>  ~ -- Clio's Protest, Life of Sheridan (Moore), Vol. i, p. 155
>  -----BEGIN PGP SIGNATURE-----
>  Version: GnuPG v1.4.8 (MingW32)
>  Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>  
>  iEYEARECAAYFAkgjHOcACgkQbtAgaoJTgL9k8QCdHTVwPREoYlByjns1t1Sr9NOY
>  eYYAmgJ5A9zOn9ZrX8KgAUXwSz6oLORz
>  =KK/C
>  -----END PGP SIGNATURE-----

Hi,

Thanks for the reply.

I am not using rails. Want to run the query only using Active Record on 
Ruby (Scite Editor)

Can you give any prototype as to how I can proceed writing a simple 
"SELECT" query after establishing the connection with the sql server db?

Thanks,
Anukul
-- 
Posted via http://www.ruby-forum.com/.