similar to: Problem connecting with an SQL Server 2000 database

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

Hi, Anyone got some tips on how to design some sort of datagrid/calendar where the columns define a resource and the rows define the date. In the corresponding cells are activities that match the resource and date, ... Thanks! Steven. -- Posted via http://www.ruby-forum.com/.

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

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

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

I still want to get this into Rails for all connection adaptors, but for now I''ve hacked my own addition on for just PostgreSQL. The following code extends every Column object returned by MyModel.columns to support a new #required? method, which indicates if the column may or may not be null. The following is a huge hack - suggestions on a cleaner way to add this functionality

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:

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

I have been creating conf files and similar with the following method that I picked up (I think from psotfix docs): cat <<EOF>>/etc/aliases || exit 1 root: youremail EOF See: http://medon.htt-consult.com/Centos7-armv7.html But with postfixadmin I stumbled onto a problem. The following: cat <<EOF>/usr/share/postfixadmin/config.local.php || exit 1 <?php

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

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

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

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

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

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

Hi, I''ve got a TimeStamp field in MySql and want to use the hour and minutes in the value. for example: StartTime = Schedule.find(action2.ScheduleID).DateTimeStart.to_s That returns "Mon Feb 20 08:00:00 Romance Standard Time 2006" How do I get 08:00 returned ?? Thanks ! Steven. -- Posted via http://www.ruby-forum.com/.

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

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

On 02/21/2017 11:03 AM, KM wrote: > I have never used this method per se, but in general in any script if you want to preserve the $ (dollar sign) or variable name you must use a backslash to preserve it. For example change your $CONF to \$CONF. The $CONF should then be printed into your conf file. Thanks that worked. > KM > > From: Robert Moskowitz <rgm at

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,