From: kranthi reddy <kranthicu@...>
Date: 2008-05-07T21:34:05+09:00
Subject: Re: Code for connecting to SQL Server?

------=_Part_22606_1975672.1210163644641
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

The code what I wrote above helps u to connect to the sql server by modifing
it a lil
require 'mysql'
 mysql = Mysql.init()
  mysql.connect('localhost','USERNAME','PASSWORD')
  mysql.select_db(' DATABASE NAME')
 result = []
result= mysql.query("SELECT name FROM users;")
  result.each do |x|
 puts x.name
 end

from the above when u run ur ruby file u can see the result as list of users
in the data base table called users .
name is the column in the users table.
hopefully this should work
You can alwyas change the database type from mysql/postgresql/sqlite3/sql by
modifing in the correct place form the above code
cheers,
kranthi.

On Wed, May 7, 2008 at 5:53 PM, Raveendran Jazzez <jazzezravi@gmail.com>
wrote:

> Hi Anukul,
>
> Try this. I am working windows here.
>
> TRY.rb
>
> ***************************************************************
> =begin
>  OS : Windows here
>  Ruby : 1.8.6
>  DB :Mysql
>  Gem :> gem install mysql
> =end
>
> require "mysql"
> #require mysql gem
> connection = Mysql.connect("localhost", "root", "", "cdcol")
> #localhost = hostname
> #root = username of mysql DB
> #""=password of mysql DB
> #cdcol = DB name
> output = connection.query("SELECT * FROM cds;")
> #cds = table name
> output.each do |x|
>  puts x.inspect
>  end
>
> ***************************************************************
>
> Regards,
> P.Raveendran
> Railsfactory
> http://raveendran.wordpress.com
> --
> Posted via http://www.ruby-forum.com/.
>
>

------=_Part_22606_1975672.1210163644641--