Eric Grigg on 31 May 2008 08:12:28 -0700 |
What version of SQL Server are you using, 2000 or 2005? On Sat, 2008-05-31 at 11:01 -0400, talk-request@phillyonrails.org wrote: > Send talk mailing list submissions to > talk@phillyonrails.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.phillyonrails.org/mailman/listinfo/talk > or, via email, send a message with subject or body 'help' to > talk-request@phillyonrails.org > > You can reach the person managing the list at > talk-owner@phillyonrails.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of talk digest..." > > > Today's Topics: > > 1. Re: RailsConf (Evan Weaver) > 2. Re: RailsConf (Colin A. Bartlett) > 3. ODBC help needed (Ezra Wolfe) > 4. Re: ODBC help needed (Dan Berger) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 29 May 2008 16:12:33 -0500 > From: "Evan Weaver" <evan@cloudbur.st> > Subject: Re: [PhillyOnRails] RailsConf > To: talk@phillyonrails.org > Message-ID: > <b6f68fc60805291412t691f0e10s2b1973daf1f09c2e@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > What's the plan? > > On Thu, May 29, 2008 at 1:06 AM, Andrea O. K. Wright > <aok@chariotsolutions.com> wrote: > > I ***am*** there. > > AOK > > > > On 5/25/08, David A. Black <dblack@rubypal.com> wrote: > >> > >> Hi -- > >> > >> I won't be there, I'm afraid. I've got a family thing in PA on June 1 > >> (niece graduating from Swarthmore), and decided that going for 1/2 a > >> conference was too much of a travel ordeal. > >> > >> > >> David > >> > >> On Sat, 24 May 2008, Colin A. Bartlett wrote: > >> > >>> PoR peeps: > >>> > >>> Those of you who are going to RailsConf, reply back to this thread so we > >>> can all figure out who's going. I'd love to organize dinner out one night if > >>> we can squeeze it in. > >>> > >>> I'll be there, and I know of at least 4 or 5 others who are going. If you > >>> want to email me your cell number off-list, we might be able to coordinate a > >>> meet up out in Portland. Also, feel free to follow me on Twitter: > >>> @cbartlett. > >>> > >>> cheers, > >>> Colin > >>> > >>> Colin A. Bartlett > >>> Kinetic Web Solutions > >>> http://blog.kineticweb.com > >>> > >>> > >>> > >>> _______________________________________________ > >>> To unsubscribe or change your settings, visit: > >>> http://lists.phillyonrails.org/mailman/listinfo/talk > >> > >> -- > >> Rails training from David A. Black and Ruby Power and Light: > >> INTRO TO RAILS June 9-12 Berlin > >> ADVANCING WITH RAILS June 16-19 Berlin > >> INTRO TO RAILS June 23-26 London (Skills Matter) > >> See http://www.rubypal.com for details and updates! > >> _______________________________________________ > >> To unsubscribe or change your settings, visit: > >> http://lists.phillyonrails.org/mailman/listinfo/talk > > > > > > _______________________________________________ > > To unsubscribe or change your settings, visit: > > http://lists.phillyonrails.org/mailman/listinfo/talk > > > > > > > > -- > Evan Weaver > > > ------------------------------ > > Message: 2 > Date: Thu, 29 May 2008 14:15:30 -0700 > From: "Colin A. Bartlett" <phillyonrails@colinabartlett.com> > Subject: Re: [PhillyOnRails] RailsConf > To: talk@phillyonrails.org > Message-ID: <52E59165-9D5D-435B-BB82-DB2968004DA8@colinabartlett.com> > Content-Type: text/plain; charset=US-ASCII; format=flowed > > > On May 29, 2008, at 2:12 PM, Evan Weaver wrote: > > > What's the plan? > > There isn't one. But I'll be in search of beers tonight. > > > ------------------------------ > > Message: 3 > Date: Thu, 29 May 2008 17:27:02 -0400 > From: "Ezra Wolfe" <ewolfe@dlc-solutions.com> > Subject: [PhillyOnRails] ODBC help needed > To: <talk@phillyonrails.org> > Message-ID: <024901c8c1d2$bcdad4d0$0801000a@dlc.local> > Content-Type: text/plain; charset="us-ascii" > > Hi all, > > I am deploying a RoR app on a Windows 2003 server. It uses two databases, > MySql and SQL Server. The MySQL connection is fine. The SQL Server > connection fails. > > I am fairly confident the application code is OK because I have it deployed > to a separate XP staging server and it works great. I am now deploying to > our production server and I get the following errors (see below). I think it > must be a configuration issue, but I can't locate it. > > I've spent a lot of time with Google and haven't come up with anything that > seems to help. > > The DSN is set up and the test connection works fine. > > The connection data is in a .rb file and looks like this: > > class AmeObject < ActiveRecord::Base > end > AmeObject.establish_connection(:adapter => "sqlserver", > :mode => "odbc", > :dsn => "XXXXX", > :database => "XXXXX", > :username => "XXXXXX", > :password => "XXXXX") > > Anyone have any tips or ideas? > > A DBI::DatabaseError occurred in account#login: > > IM002 (0) [Microsoft][ODBC Driver Manager] Data source name not found and > no default driver specified > C:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect' > > ------------------------------- > Backtrace: > ------------------------------- > > C:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect' > C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:424:in `connect' > C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:215:in `connect' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters > /sqlserver_adapter.rb:41:in `sqlserver_connection' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters > /abstract/connection_specification.rb:251:in `send' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters > /abstract/connection_specification.rb:251:in > `connection_without_query_cache=' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/query_cache.rb:54:i > n `connection=' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters > /abstract/connection_specification.rb:220:in `retrieve_connection' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters > /abstract/connection_specification.rb:78:in `connection' > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:696:in > `columns' > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:709:in > `column_names' > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:722:in > `column_methods_hash' > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1158:in > `all_attributes_exists?' > > [RAILS_ROOT]/vendor/rails/activesupport/lib/active_support/dependencies.rb:1 > 40:in `all?' > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1158:in > `each' > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1158:in > `all?' > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1158:in > `all_attributes_exists?' > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1095:in > `method_missing' > [RAILS_ROOT]/app/models/user.rb:487:in `update_region' > [RAILS_ROOT]/app/models/user.rb:453:in `save_without_validation' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/validations.rb:724: > in `save_with_validation' > [RAILS_ROOT]/app/models/user.rb:474:in `save_with_validation' > [RAILS_ROOT]/app/controllers/account_controller.rb:17:in `login' > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/base.rb:910:in > `send' > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/base.rb:910:in > `perform_action_without_filters' > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/filters.rb:368:in > `perform_action_without_benchmark' > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:6 > 9:in `perform_action_without_rescue' > C:/ruby/lib/ruby/1.8/benchmark.rb:293:in `measure' > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:6 > 9:in `perform_action_without_rescue' > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/rescue.rb:82:in > `perform_action' > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/base.rb:381:in > `send' > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/base.rb:381:in > `process_without_filters' > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/filters.rb:377:in > `process_without_session_management_support' > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/session_managemen > t.rb:117:in `process' > [RAILS_ROOT]/vendor/rails/railties/lib/dispatcher.rb:38:in `dispatch' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/rail > s.rb:76:in `process' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/rail > s.rb:74:in `synchronize' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/rail > s.rb:74:in `process' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:1 > 59:in `process_client' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:1 > 58:in `each' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:1 > 58:in `process_client' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:2 > 85:in `run' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:2 > 85:in `initialize' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:2 > 85:in `new' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:2 > 85:in `run' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:2 > 68:in `initialize' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:2 > 68:in `new' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:2 > 68:in `run' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/conf > igurator.rb:282:in `run' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/conf > igurator.rb:281:in `each' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/conf > igurator.rb:281:in `run' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/bin/mongrel_rail > s:128:in `run' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/comm > and.rb:212:in `run' > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/bin/mongrel_rail > s:281 > C:/ruby/bin/mongrel_rails:16:in `load' > C:/ruby/bin/mongrel_rails:16 > > > > > Regards, > Ezra Wolfe > DLC Solutions > 3701 Market Street, Suite 462 > Philadelphia, Pa 19104 > Mobile: 215.868.5336 > Office: 215.966.6177 > Fax: 703.935.5594 > AIM: ezrawolfe > Skype: ezra.wolfe > www.dlc-solutions.com <http://www.dlc-solutions.com/> > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: http://lists.phillyonrails.org/pipermail/talk/attachments/20080529/509afcf6/attachment-0001.html > > ------------------------------ > > Message: 4 > Date: Thu, 29 May 2008 17:36:08 -0400 > From: "Dan Berger" <danielberger@gmail.com> > Subject: Re: [PhillyOnRails] ODBC help needed > To: talk@phillyonrails.org > Message-ID: > <32ddc7b50805291436q515b205eq3c831cf084d656dd@mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > Hey, > So I haven't used sql server with rails, but this may have to do with the > distinction between "User DSN" and "System DSN". if the web site is running > under a different user than you, it won't be able to access your user dsn. > > good luck, > > Dan Berger > > On Thu, May 29, 2008 at 5:27 PM, Ezra Wolfe <ewolfe@dlc-solutions.com> > wrote: > > > Hi all, > > > > I am deploying a RoR app on a Windows 2003 server. It uses two databases, > > MySql and SQL Server. The MySQL connection is fine. The SQL Server > > connection fails. > > > > I am fairly confident the application code is OK because I have it deployed > > to a separate XP staging server and it works great. I am now deploying to > > our production server and I get the following errors (see below). I think it > > must be a configuration issue, but I can't locate it. > > > > I've spent a lot of time with Google and haven't come up with anything that > > seems to help. > > > > The DSN is set up and the test connection works fine. > > > > The connection data is in a .rb file and looks like this: > > > > class AmeObject < ActiveRecord::Base > > end > > AmeObject.establish_connection(:adapter => "sqlserver", > > :mode => "odbc", > > :dsn => "XXXXX", > > :database => "XXXXX", > > :username => "XXXXXX", > > :password => "XXXXX") > > > > Anyone have any tips or ideas? > > > > *A DBI::DatabaseError occurred in account#login:* > > > > * IM002 (0) [Microsoft][ODBC Driver Manager] Data source name not found > > and no default driver specified* > > * C:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect'* > > > > ------------------------------- > > Backtrace: > > ------------------------------- > > > > C:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:95:in `connect' > > C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:424:in `connect' > > C:/ruby/lib/ruby/site_ruby/1.8/dbi.rb:215:in `connect' > > > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlserver_adapter.rb:41:in > > `sqlserver_connection' > > > > > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in > > `send' > > > > > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in > > `connection_without_query_cache=' > > > > > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in > > `connection=' > > > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in > > `retrieve_connection' > > > > > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in > > `connection' > > > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:696:in > > `columns' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:709:in > > `column_names' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:722:in > > `column_methods_hash' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1158:in > > `all_attributes_exists?' > > > > [RAILS_ROOT]/vendor/rails/activesupport/lib/active_support/dependencies.rb:140:in > > `all?' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1158:in > > `each' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1158:in > > `all?' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1158:in > > `all_attributes_exists?' > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/base.rb:1095:in > > `method_missing' > > [RAILS_ROOT]/app/models/user.rb:487:in `update_region' > > [RAILS_ROOT]/app/models/user.rb:453:in `save_without_validation' > > > > [RAILS_ROOT]/vendor/rails/activerecord/lib/active_record/validations.rb:724:in > > `save_with_validation' > > [RAILS_ROOT]/app/models/user.rb:474:in `save_with_validation' > > [RAILS_ROOT]/app/controllers/account_controller.rb:17:in `login' > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/base.rb:910:in > > `send' > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/base.rb:910:in > > `perform_action_without_filters' > > > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/filters.rb:368:in > > `perform_action_without_benchmark' > > > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:69:in > > `perform_action_without_rescue' > > C:/ruby/lib/ruby/1.8/benchmark.rb:293:in `measure' > > > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:69:in > > `perform_action_without_rescue' > > > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/rescue.rb:82:in > > `perform_action' > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/base.rb:381:in > > `send' > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/base.rb:381:in > > `process_without_filters' > > > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/filters.rb:377:in > > `process_without_session_management_support' > > > > > > [RAILS_ROOT]/vendor/rails/actionpack/lib/action_controller/session_management.rb:117:in > > `process' > > [RAILS_ROOT]/vendor/rails/railties/lib/dispatcher.rb:38:in `dispatch' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/rails.rb:76:in > > `process' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/rails.rb:74:in > > `synchronize' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/rails.rb:74:in > > `process' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:159:in > > `process_client' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:158:in > > `each' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:158:in > > `process_client' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:285:in > > `run' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:285:in > > `initialize' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:285:in > > `new' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:285:in > > `run' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:268:in > > `initialize' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:268:in > > `new' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel.rb:268:in > > `run' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/configurator.rb:282:in > > `run' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/configurator.rb:281:in > > `each' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/configurator.rb:281:in > > `run' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/bin/mongrel_rails:128:in > > `run' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/lib/mongrel/command.rb:212:in > > `run' > > > > C:/ruby/lib/ruby/gems/1.8/gems/mongrel-1.1.4-x86-mswin32-60/bin/mongrel_rails:281 > > C:/ruby/bin/mongrel_rails:16:in `load' > > C:/ruby/bin/mongrel_rails:16 > > > > > > > > Regards, > > Ezra Wolfe > > DLC Solutions > > 3701 Market Street, Suite 462 > > Philadelphia, Pa 19104 > > Mobile: 215.868.5336 > > Office: 215.966.6177 > > Fax: 703.935.5594 > > AIM: ezrawolfe > > Skype: ezra.wolfe > > *www.dlc-solutions.com* <http://www.dlc-solutions.com/> > > > > > > _______________________________________________ > > To unsubscribe or change your settings, visit: > > http://lists.phillyonrails.org/mailman/listinfo/talk > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: http://lists.phillyonrails.org/pipermail/talk/attachments/20080529/996c1810/attachment.html > > ------------------------------ > > _______________________________________________ > talk mailing list > talk@phillyonrails.org > http://lists.phillyonrails.org/mailman/listinfo/talk > > > End of talk Digest, Vol 32, Issue 14 > ************************************ _______________________________________________ To unsubscribe or change your settings, visit: http://lists.phillyonrails.org/mailman/listinfo/talk
|
|