tags:

views:

404

answers:

2
+2  Q: 

Ruby Connecting to SQL Server 2005

I want to connect to a sql server 2005/db with ODBC through ruby using windows authentication. I have the gems dbi-0.4.1 and dbd-odbc-0.2.4 installed. What do I need to do for a connection string? So far I haven't been able to get it to work.

DBI.connect("DBI:ODBC:Data Source=#{server};Integrated Security=SSPI;Initial Catalog=#{db}")

A: 

I've successfully connected to a test database with just:

DBI.connect('DBI:ODBC:test')

Dave McLaughlin  2009-04-08 15:34:05
What about a server db pair? Do you have any permissioning setup, are you sure it's really auto authenticating with your credentials?
Jeremy T  2009-04-08 15:43:46
Hmm, good question! I can't investigate it just now, but I'll get back to it next week.I'm not that familiar with MS SQL myself, just evaluating it for a project against MySQL (which is more familiar). Thanks for the pointer.
Dave McLaughlin  2009-04-10 18:24:29
+1  A: 

It appears after you specify DBI:DriverName: you can put whatever connection info you need

DBI.connect("DBI:ODBC:Driver={SQL Server};Server=#{server};Database=#{db};Trusted_Connection=yes")

http://www.devlist.com/ConnectionStringsPage.aspx

Jeremy T  2009-04-08 16:25:53
How would this translate into a yml config file? I have a similar issue w/ a Rails application.
catalpa  2009-07-25 03:46:30

related questions

Best place to get Ruby on Vista up and running as dev environment
How can I encode xml files to xfdl (base64-gzip)?
What is the best way to learn Ruby?
Learning Ruby on Rails any good for Grails?
How to sell Python to a client/boss/person with lots of cash
How do I create a Class using the Singleton Design Pattern in Ruby?
How do I update Ruby Gems from behind a Proxy (ISA-NTLM)
Why Should I Learn Ruby?
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
How do I rake tasks within a ruby script?
Ruby On Rails with Windows Vista - Best Setup?
Mapping values from two array in Ruby
Reverse DNS in Ruby?
Text Editor For Linux (Besides Vi)?
What is good forum software to add to an existing Rails application?
Calling Bash Commands From Ruby
How can I modify .xfdl files? (Update #1)
How do I use (n)curses in Ruby?
Open Source Ruby Projects
How do I fix 'Unprocessed view path found' error with ExceptionNotifier plugin in rails 2.1?
When to use lambda, when to use Proc.new?
Frequent SystemExit in Ruby when making HTTP calls
Implementation of "Remember me" in a Rails application.
.NET Migrations Engine
How do I add existing comments to RDoc in Ruby?