[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Ruby-DBI to query MS SQL 2003 ? (newb

Josiah Ritchie

1/11/2006 6:35:00 PM

I'm trying to write a script to pull data out of a MS SQL 2003
database and manipulate it a bit. I've found ActiveRecord to be slim
on examples outside of the Rails environment.

I've tried lots of variations on the name of the driver; mssql, msql,
mysql examples.

dbh = DBI.connect("dbi:msql:wbctest:chad", "testuser", "testpass")

I've dug into the dbi code some, found that it is case-insensitive
and, I believe, confirmed that msql is the appropriate one for my
needs and that it exists under the DBD directory.

Maybe I'm making this harder than it needs to be? That would be
common. I will gladly accept corrections in my direction of attack.

JSR/
2 Answers

jeem.hughes

1/11/2006 7:42:00 PM

0

I think you want something more like this:

DBI:ADO:Provider=SQLOLEDB;Data Source=YOURSERVER;Initial
Catalog=YOURDB;User Id=YOU;Password=YOURPASSWORD;

You may be able to leave the user and pw out of the above string if
you include them in the 2nd and 3rd args to connect.

You'll probably need to download the ADO adapter and add it to your
Ruby install. For some reason, it doesn't come with the windows Ruby
installer, although DBI does.

You can get it from
http://rubyforge.org/frs/download.php/655/ruby-dbi-all-0.0....
Just pull the file "ADO.db" out and stick it in
<RUBYPATH>\lib\ruby\site_ruby\1.8\DBD\ADO. (You'll have to create the
ADO directory.)

Jim


Josiah Ritchie wrote:
> I'm trying to write a script to pull data out of a MS SQL 2003
> database and manipulate it a bit. I've found ActiveRecord to be slim
> on examples outside of the Rails environment.
>
> I've tried lots of variations on the name of the driver; mssql, msql,
> mysql examples.
>
> dbh = DBI.connect("dbi:msql:wbctest:chad", "testuser", "testpass")
>
> I've dug into the dbi code some, found that it is case-insensitive
> and, I believe, confirmed that msql is the appropriate one for my
> needs and that it exists under the DBD directory.
>
> Maybe I'm making this harder than it needs to be? That would be
> common. I will gladly accept corrections in my direction of attack.
>
> JSR/

Josiah Ritchie

1/11/2006 9:20:00 PM

0

thanks, I'll work on that.

On 1/11/06, jeem <jeem.hughes@gmail.com> wrote:
> I think you want something more like this:
>
> DBI:ADO:Provider=SQLOLEDB;Data Source=YOURSERVER;Initial
> Catalog=YOURDB;User Id=YOU;Password=YOURPASSWORD;
>
> You may be able to leave the user and pw out of the above string if
> you include them in the 2nd and 3rd args to connect.
>
> You'll probably need to download the ADO adapter and add it to your
> Ruby install. For some reason, it doesn't come with the windows Ruby
> installer, although DBI does.
>
> You can get it from
> http://rubyforge.org/frs/download.php/655/ruby-dbi-all-0.0....
> Just pull the file "ADO.db" out and stick it in
> <RUBYPATH>\lib\ruby\site_ruby\1.8\DBD\ADO. (You'll have to create the
> ADO directory.)
>
> Jim
>
>
> Josiah Ritchie wrote:
> > I'm trying to write a script to pull data out of a MS SQL 2003
> > database and manipulate it a bit. I've found ActiveRecord to be slim
> > on examples outside of the Rails environment.
> >
> > I've tried lots of variations on the name of the driver; mssql, msql,
> > mysql examples.
> >
> > dbh = DBI.connect("dbi:msql:wbctest:chad", "testuser", "testpass")
> >
> > I've dug into the dbi code some, found that it is case-insensitive
> > and, I believe, confirmed that msql is the appropriate one for my
> > needs and that it exists under the DBD directory.
> >
> > Maybe I'm making this harder than it needs to be? That would be
> > common. I will gladly accept corrections in my direction of attack.
> >
> > JSR/
>
>
>