Displaying 20 results from an estimated 1100 matches similar to: "Ruby on Rails | MS SQL Server 2005 | Configuration"
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
2010 Feb 16
1
Native odbc
Wine 1.1.31
Msi package installs for sqlncli.msi and psqlodbc.msk (psqlodbc_08_04) do not install correctly. They are not displayed in by "wine odbcad32.exe".
In previous betas they did work ok.
2007 Sep 10
12
mongrel_rails service on windows incompatible with recent ruby builds?
i was suffering from a massive memory leak in my application. after
searching and testing for quite a while i finally found that it wasn''t
my app that had a leak but the win32ole support that was used by the
ADO driver in sqlserver adapter.
the solution to fix the leak was to install ruby 1.8.5p52 or 1.8.6p36
but sadly as soon i install one of the fixed releases mongrel won''t
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
2006 Apr 05
0
[SPAM] Problem with scaffolding on test setup
Yet another newbie question here.
My setup is thus:
I have lighty running with scgi (working fine) on windows XP sp 2.
Rails 1.1 and ruby 1.8.x.
The server and scgi are working. I know this because I can get a test
page to work easily enough.
I did the following:
ruby script\generate model Recipe [following the Rolling with Rails
Tutorial]
ruby script\generate controller Recipe
I also
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
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:
2009 Sep 09
0
Setting up Ruby for use with MS SQL 2008
Hello there!
I am pretty close to being able to develop in rails, but I keep
running into a problem with my setup in connecting to my MS SQL
database. When I try to navigate to my control page, I get the "..but
something went wrong" page. In the dev log I get the following error:
Unable to load driver ''ADO'' (underlying error: uninitialized
constant DBI::DBD::ADO)
I
2006 Oct 11
0
ActiveRecord + SqlServer 2005, looking for feedback
Hi!
I''ve just started using AR on top of SqlServer 2005 (through ADO:
http://www.softiesonrails.com/articles/2006/06/28/activerecord-with-sqlserver-without-rails).
Not a Rails site per se, but I''m using AR and ruby to build data aggregation
tools.
If you have used AR with SqlServer 2005 and met quirks or caveats of some
kind, I''d be happy to get some feedback from your
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
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
2008 Jan 17
6
Problems with sqlserver 2000 and ActiveRecord
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:
2006 Jun 14
0
Mssql Multiple Database Access Error
Hi All,
I am having a problem to access multiple databases with mssql
I am running Ruby 1.8.4 and Rails 1.1 on Windows 2000 Advanced Server.
I am simply 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
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
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,
2007 Sep 04
0
RoR on windows with MS SQL Server DBI:ADO driver Memory Leak
i''m running ruby 1.8.5 and rails 1.2.3 on windows with a bunch of
mongrels that are proxybalanced via apache 2.2.4
the db adapter i''m using is the sqlserver one in ADO mode. so it''s using
win32ole.
when a mongrel service is freshly started it consumes about 40 megs of
ram. but about each and every request is leaking memory. about 20 megs
per hour(!!!).
so after half a
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
2009 Feb 28
0
activerecord-odbc-adapter 2.0 failed to allocate memory
I''m currently trying to connect rails to a legacy SqlServer database. System
is windows XP and my attempts to connect with activerecord sql adapter and
ADO.rb file failed miserably (I wrote a mail about it before)
So it seems like odbc adapter is more recent compared to sql adapter and
probably more used. I''m using active_record_store as session store, and
probably the first
2010 Sep 07
3
ActiveRecord::ConnectionNotEstablished error
I''ve attached my database.yml
I''ve installed gem install activerecord-sqlserver-adapter
But when I navigate to a simple page I get the
ActiveRecord::ConnectionNotEstablished error
Any ideas what I should be checking?
Ruby 1.92
Rails 3
Attachments:
http://www.ruby-forum.com/attachment/5016/database.yml
--
Posted via http://www.ruby-forum.com/.
--
You received this message
2006 Sep 30
1
mssql, problem authenticating from stored procedure...
Hello,
running plain samba 3.023c on debian, I'm trying to connect to a samba
share from within a stored procedure.
This works as long as samba is in "share" mode:
[2006/09/29 14:53:01, 5] auth/auth.c:check_ntlm_password(309)
check_ntlm_password: guest authentication for user [] -> [] -> [nobody]
succeeded
When I try to attach samba share manually when logged in as the