Displaying 20 results from an estimated 3000 matches similar to: "Problems with sqlserver 2000 and ActiveRecord"
2006 Mar 28
8
Problem connecting with an SQL Server 2000 database
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:
2006 Mar 13
2
Connectivity to Microsoft SQL Server using ADO
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
2007 Dec 10
8
could not find activerecord-sqlserver-adapter locally or in a repository
I''m trying to connect to a SQL Server db. I thought I installed the
DBI component per the instructions, but its not working.
When trying to start the ruby server, I get the message:
Please install the sqlserver adapter: `gem install activerecord-
sqlserver-adapter`
But when I try to install the repository, I get this error message:
could not find activerecord-sqlserver-adapter
2008 Feb 29
17
Is SQL Server not supported in RoR on the Mac?
Hi -- I''ve been having problems connecting to a SQL Server database that
I thought might be related to the fact I was upgrading Rails to 2.0.
However, I also was moving the project to my shiny new macbook.
Anyway, after jumping through a few hoops (instaling DBI, etc.), I
finally get to my latest error message:
<error>
DBI::InterfaceError: Could not load driver (no such file to
2006 May 01
1
Rails: Ho to connect to SQL Server
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
2006 Jul 26
7
Delete_all causes a deadlock on MSSQL database ???
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
2005 Dec 15
2
Migrations on SQLServer ??
Hello all,
I''ve spent a while looking for a sniff of this on the wiki or google at
large..
Does migrations work for SQL Server on 1.0 ?
--
------------------------------
Joyeux Noël
------------------------------
Peter Fitzgibbons
_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
2009 Feb 05
1
Need the activerecord-sqlserver-adapter but...
Hi... I am new to RoR development, and Web development in general (but
have about 25 years of IT/software experience - just not in the Web
area)... I have a really good RoR 2.X book that I have read and reread a
few times and starting to try to apply what I read... Have a Web app
that I need to write at work, and prove to folks that RoR is THE_WAY,
despite their ASP .NET protests otherwise...
So,
2006 Jan 05
3
MS SQL server connection problems
I am trying to connect to a remote sql server and I am getting the
following error:
c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `connect'': Open
(DBI::Databa
seError)
OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or access
denied.
HRESULT error code:0x80020009
Exception
2008 Jun 02
4
Cannot find sqlserver adaptor for ActiveRecord
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
2010 Jan 03
24
SQLServer on Rails
Does any one know how to setup SQLserver with ruby1.9. It was working
on an earlier version and now nothing works! I have installed the
gems dbi ,dbd-odbc and activerecord-odbc-adapter and can connect in
straight Ruby. However, using rails with database.yml nothing works!
I hosed everything and reinstalled rails and now, I get Win32/Parite
virus on ruby.exe. Any ideas? I''m losing
2007 Sep 26
1
Ruby on Rails | MS SQL Server 2005 | Configuration
Request: Full description of mechanims required to intergrate current
Ruby / Ruby on Rails with MS SQL Server 2005
Environment:
* Ruby 1.8.6-25
(ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32])
* Rails 1.2.3
* ruby-dbi 0.1.1 (installed dbi,dbd_ADO)
* OS: Windows XP Professional sp4
* MS SQL Server Express 2005 installed on local machine
Background:
I have used various settings for the
2009 Jan 23
7
RubyOnRails with MS SQL - Connectivity Error
Hi all...
Please help me solve the issue.
While trying to create a connection with MS SQL database in RubyOnRails,
I''m getting a ‘Deprecated ..’ error. (I referenced a doc posted in net
for the same.)
System details: OS: Windows Xp
Ruby version: 1.8.6
Rails: 2.1.2
Gems: 1.3.1
RadRails: 0.7.2
2009 Apr 14
6
SQL Server via DBI/ODBC configuration
I have followed the cookbook on http://wiki.rubyonrails.org/database-support/ms-sql
but am having problems with the rails part. I can connect to the
database using sqsh so I think all the freetds plumbing is good. When
I try to connect to the db with a rake db:migrate or just using script/
console I get this error:
>> Client.find(:first)
DBI::InterfaceError: Unable to load driver
2006 Jun 03
1
Unable to connect to ms sql server.
I get the following error message when trying to connect to ms sql
server:
Open
OLE error code:80040E4D in Microsoft OLE DB Provider for SQL Server
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
2006 Jan 12
9
Is RoR on SQLServer suitable for a commercial application?
Good Evening,
I need some advice. I am in a position at work where I''ve got the boss
pretty excited about rails. I think I could swing the Next Generation
version of our product to use rails as the platform, but I find myself a
little hesitant to do so until I''ve answered a few issues that I''m hoping
people on this list could help me with.
Firstly, we are tied to
2006 May 29
3
is Sql Server support built in?
Have installed ruby-one-click installer 1.8.4-16 and rails. Am unable to
get an app to talk to by SS2000 database using adapter: sqlserver. Is Sql
Server support built-in, or do I need to install something else?
--
Best Regards,
-Larry
"Work, work, work...there is no satisfactory alternative."
--- E.Taft Benson
-------------- next part --------------
An HTML attachment
2006 Mar 02
5
Instiki and SQL Server??
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
2006 Jan 23
4
Proposal: Deprecate ADO support in the SQL Server adapter
The SQL Server adapter can currently operate in two modes, ADO and
ODBC, each of which uses a different interface to access the db. The
ADO interface is currently the default, while ODBC can be specified as
an option.
I propose this situation is reversed, and that use of the ADO
interface is deprecated, if not removed altogether. Here are some
reasons, I'm sure there are more:
a) ADO uses
2005 Mar 10
1
Running unit tests on SQL Server
Hi everyone,
It''s been more than a month since I last fired up Ruby or ActiveRecord, so
imagine my surprise when, after getting the latest source and running the
unit tests for MySql, I was greeted with a screen full of errors.
I''ll come back to the MySql errors later. What follows is the output I get
when I run the tests for SQL server.
I installed ruby with the one-click