search for: howtoconnecttomicrosoftsqlserv

I have been trying to find the adtiverecord adaptor for MS SQL server and attempted to install with the command found on the http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer wiki page: gem install activerecord-sqlserver-adapter --source=http:// gems.rubyonrails.org I then got the error message: ERROR: could not find activerecord-sqlserver-adapter locally or in a repository Does anyone know where the sqlserver adaptor has gone for activerecord 2.0.2? Harley...

Hi, I''m getting some trouble in connecting to a sql server 2000 database with ActiveRecord-2.0.1 and ruby 186-26, from win XP. Using the next conenction config: ActiveRecord::Base.establish_connection( :adapter => "sqlserver", :database => "nombre_bd", :username => "usu", :password => "contra" ) I have the next error:

Hi, I tried the steps explained in this link: http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServer The article t refers me to: src/lib/dbd_ado/ADO.rb But the file: dbi-0.1.0.tar.gz does not contain the src folder. Instead, it contains this file: \lib\dbd/ADO.rb Am I missing some steps, or this is a document inconsistency? Thank you, Alan -- Posted via http://www.ruby-forum.com/.

Based on this page: http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer using this specification development: adapter: sqlserver database: database_name host: server_name username: user_name password: your_pw_here in database.yml for your SQL Server connection doesn''t work. Some debugging code reveals that only the password comes through into...

I''m using RoR 1.0, Windows 2000, and SQL Server 2000. I am connecting to the database using these directions: http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer. Using the scaffold generator to generate the default files (ruby script/generate scaffold Location) I start up WebBrick and pull up the page. There are 58 records in the table. I am given the first 10 records. No problem so far. Then I click the next page link - which points to page 2 (page...

Hi all, When i use the ''delete_all'' function to remove a few rows from my database, it causes a deadlock on the sql server. The delete seems to be successful, it then redirects to the ''view'' page, and the record does appear to be deleted as far as the ''view'' rails page shows. BUT if i go into sql query analyser, i can''t do a

Hi, I?m working on a rails application that uses data from an existing ms sqlserver 2000 database. Unfortunately I can?t get the connection to work properly. I used http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer to make the connection. - Inserted the ado.rb - Changed my database.yml to development: adapter: sqlserver database: database_name host: DBI:ADO:Provider=SQLOLEDB;Data Source=server_name;Initial Catalog=database_name;User Id=user_name;Password=your_pw_here; username: user_name passwor...

...Login failed for user ''XXXXXXXX''. HRESULT error code:0x80020009 Exception occurred. I google''d for those error codes but nothing useful so far. To set up ruby for ms sql server, I followed the instructions here: http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer I followed the first 2 steps (copying ado.rb and modifying database.yml) but I cannot get it to connect to the sql server. Ofcourse, I have verified that the credentials are good since I am able to connect to the server from other interfaces. Also, is there a way to force ruby to use windows...

...y trying to integrate the application I wrote before for Oracle to Mssql. The application works perfectly with Oracle with the installed driver OCI8. The app retrives data based on a search criteria from those databases. I followed the directions given at: http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer to connect to the database with mssql Also my .yml file looks like the following: development: adapter: sqlserver database: GME_CCON host: DBI:ADO:Provider=SQLOLEDB;Data Source=satchel;Initial Catalog=GME_CCON;User ID=genesys;Password=**** username: genesys password: **** GME_CONFIG:...

Hi all, I dumped my schema from SQLServer 2000 without any problems. I then tried to "rake db_schema_import" on MySQL 4. To do this i changed my database.yml settings to use the mysql adapter (as it was set to use sqlsever before) and attempted the import. I haven''t changed a thing in the schema.rb script and, even though I do have generated a migration, I think I

Hello. I reeeeally want to get Instiki running at my day job, but they are Microsoft-heads. While I can probably sell them on trying Rails, they are definitely going to want the database to sit in our SQL Server instance with our other databases. I can''t get instiki to create the tables in sql server though (I''ve added ADO.rb, and gotten a connection). When I run the

This release is unchanged from release candidate 1 other than to update the version number in the Help>>About dialog. Instant Rails is a one-stop Rails runtime solution containing Ruby, Rails, Apache, and MySQL, all preconfigured and ready to run. No installer, you simply drop it into the directory of your choice and run it. It does not modify your system environment. This release of