# Code for connecting to SQL Server?

**URL:** <https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927>\
**Category:** Ruby\
**Created:** [May 7, 2008, 1:18pm UTC](https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927 "2008-05-07T13:18:50Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 7, 2008, 1:18pm UTC](https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927/1 "2008-05-07T13:18:50Z")

</div>

Hi,

I want to connect to my SQL Server DB through ruby code.

Searched on the connection and was provided some steps like:

1. Save the latest source distribution of ruby-dbi and copy the file  
ADO.rb to  
X:/ruby/lib/ruby/site\_ruby/1.8/DBD/ADO/ADO.rb

2. Then, in your database.yml,

development:  
adapter: sqlserver  
database: database\_name  
host: server\_name  
username: user\_name  
password: pwd

I am not able to find this file.

Can anyone tell me for invoking sql server in SCITE editor?

Is there any other procedure 'coz I dont have rails installed?

Thanks,  
Anukul

---

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 7, 2008, 1:58pm UTC](https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927/2 "2008-05-07T13:58:13Z")

</div>

Hey,  
Do you want to invoke the sql using ruby code or ruby on rails…  
If its just ruby then you u can go a head like this:

require ‘mysql’  
mysql = Mysql.init()  
mysql.connect(‘localhost’,‘USERNAME’,‘PASSWORD’)  
mysql.select\_db(’ DATABASE NAME’)  
and proceed with the rest of the operations as required .

If its in Ruby on rails then you can configure your database.yml file

cheers,  
krantih

On Wed, May 7, 2008 at 4:48 PM, Anukul S.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 7, 2008, 2:23pm UTC](https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927/3 "2008-05-07T14:23:34Z")

</div>

kranthi reddy wrote:

> Hey,  
> Do you want to invoke the sql using ruby code or ruby on rails…  
> If its just ruby then you u can go a head like this:
> 
> require ‘mysql’  
> mysql = Mysql.init()  
> mysql.connect(‘localhost’,‘USERNAME’,‘PASSWORD’)  
> mysql.select\_db(’ DATABASE NAME’)  
> and proceed with the rest of the operations as required .
> 
> If its in Ruby on rails then you can configure your database.yml file
> 
> cheers,  
> krantih
> 
> On Wed, May 7, 2008 at 4:48 PM, Anukul S.  
> [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

Hi,

Thanks for the info.

My basic aim is to connect to SQL Server 2005 through Ruby without using  
rails.

Can you help in providing a code snippet for connecting to it?

Thanks,  
Anukul

---

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 7, 2008, 2:35pm UTC](https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927/4 "2008-05-07T14:35:07Z")

</div>

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 J. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 7, 2008, 2:23pm UTC](https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927/5 "2008-05-07T14:23:45Z")

</div>

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

> **[Raveendran](https://raveendran.wordpress.com)**
>
> Nothing is impossible...

---

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 7, 2008, 2:36pm UTC](https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927/6 "2008-05-07T14:36:55Z")

</div>

-----BEGIN PGP SIGNED MESSAGE-----  
Hash: SHA1

Anukul S. wrote:

| Hi,  
|  
| Thanks for the info.  
|  
| My basic aim is to connect to SQL Server 2005 through Ruby without using  
| rails.

You could use ActiveRecord. It is seperate from Rails, too.

| Can you help in providing a code snippet for connecting to it?

[http://ar.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/SQLServerAdapter.html](http://ar.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/SQLServerAdapter.html)

* * *

Phillip G.  
Twitter: [twitter.com/cynicalryan](http://twitter.com/cynicalryan)  
Blog: [http://justarubyist.blogspot.com](http://justarubyist.blogspot.com)

Use debugging compilers.  
~ - The Elements of Programming Style (Kernighan & Plaugher)  
-----BEGIN PGP SIGNATURE-----  
Version: GnuPG v1.4.8 (MingW32)  
Comment: Using GnuPG with Mozilla - [http://enigmail.mozdev.org](http://enigmail.mozdev.org)

iEYEARECAAYFAkghodAACgkQbtAgaoJTgL/dSACfb41YflRqaS2kXjJL8qH3TgI4  
d9AAn18iSM4B7jSVhxHOhO9NqZqBFAAR  
=IFw5  
-----END PGP SIGNATURE-----

---

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 7, 2008, 2:44pm UTC](https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927/7 "2008-05-07T14:44:33Z")

</div>

-----BEGIN PGP SIGNED MESSAGE-----  
Hash: SHA1

kranthi reddy wrote:  
| 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

MySQL != MSSQL

MSSQL: [Microsoft SQL Server - Wikipedia](http://en.wikipedia.org/wiki/Microsoft_SQL_Server)  
MySQL: [MySQL - Wikipedia](http://en.wikipedia.org/wiki/MySQL)

* * *

Phillip G.  
Twitter: [twitter.com/cynicalryan](http://twitter.com/cynicalryan)  
Blog: [http://justarubyist.blogspot.com](http://justarubyist.blogspot.com)

~ I’m looking for something that can deliver a 50-pound payload of  
snow  
~ on a small feminine target. Can you suggest something? Hello…?  
~ — Calvin  
-----BEGIN PGP SIGNATURE-----  
Version: GnuPG v1.4.8 (MingW32)  
Comment: Using GnuPG with Mozilla - [http://enigmail.mozdev.org](http://enigmail.mozdev.org)

iEYEARECAAYFAkgho+sACgkQbtAgaoJTgL9qxwCcCe6QA31tSUG1bKya+CMA+efT  
W8UAn0jVy3Dhjn8L4KJDHrrHW1TysD0h  
=m/XE  
-----END PGP SIGNATURE-----

---

<div class="post-metadata">

**Author:** ![anukulsinghal](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/dbc845/32.png) [@anukulsinghal](https://www.ruby-forum.com/u/anukulsinghal)\
**Post date:** [May 8, 2008, 1:15am UTC](https://www.ruby-forum.com/t/code-for-connecting-to-sql-server/136927/8 "2008-05-08T01:15:48Z")

</div>

On May 7, 6:18 am, Anukul S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> 1. Then, in your database.yml,  
> Can anyone tell me for invoking sql server in SCITE editor?
> 
> Is there any other procedure 'coz I dont have rails installed?
> 
> ## Thanks, Anukul
> 
> Posted viahttp://www.ruby-forum.com/.

require ‘dbi’

@server\_name=‘localhost’  
@dbh=DBI.connect(“DBI:ADO:Provider=SQLNCLI;Data  
Source=#{@server\_name};Integrated Security=SSPI”)

if @dbh  
puts “connected”  
else  
puts “not connected”  
end

@dbh.select\_all(‘SELECT name FROM master.sys.databases ORDER BY 1’) do  
| row|  
puts row  
end

Here’s an example.

Luis