similar to: sqlserver image columns

Hello all, I''m trying to initialize my migrations against a current database implementation. rake db:schema:dump runs without error. The resulting schema.rb is pasted below, along with my database.yml Can one of you point me in the direction of enlightenment? -- ------------------------------ Apple MacBook. Black. It''s the new White! ------------------------------ Peter

"bitsweat" has given AR/SQLServer some love, but it''s still unhappy... http://dev.rubyonrails.org/changeset/6912 ------------------------------------------------------------------------ r6912 | bitsweat | 2007-05-31 10:15:56 -0700 (Thu, 31 May 2007) | 1 line Fix an edge case with find with a list of ids, limit, and offset. Closes #8437.

Hello, Using Edge_Rails and SQL Server I get an error in my schema.rb file after issuing "rake migrate". database.yml --------------------------------- development: adapter: sqlserver database: triage_development username: user password: pass host: server schema.rb --------------------------------- # Could not dump table "categories" because of following

Hello, I have rails using a MSSQL db. The set up works fine with low volume, but with 2+ requests/second I keep on getting the following error: DBI::DatabaseError: Execute OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction mode. HRESULT error code:0x80020009 Exception occurred.: SELECT

Hi, I am using send_data to allow users to download files from the database but ran into a small problem, it seems that files upload fine but when they download only 64kb of the file is sent. I''m using the basic rails code from the Agile book: #upload code in my sheet model def file=(document_field) self.filename = base_part_of(document_field.original_filename)

I just started investigating Ruby on Rails and am trying the tutorial. I need to connect to a SQL Server 2000 database for testing purposes. I followed the instructions in the How-To on the wiki for SQL Server. The problem is that when attempting to connect to the database I receive the following errors: DBI::DatabaseError in RecipeController#new Open OLE error code:80004005 in

Hi, I''m having issues with getting a consistent result with the emails I am sending using Actionmailer. Problem: Emails that I send with plain text, rich text, and attachments do not display the same results across GMail, Yahoo, Outlook and Thunderbird. Scenario: I am sending an email with text/plain, text/html, and 2 attachments using the code below, and I''ve specified the

I have a model; I do photo = Photo.new(parameters) parameters contains: {"picture"=>#<File:C:/DOCUME~1/BART~1/LOCALS~1/Temp/CGI3180.1>} so i expect that the def picture=(filename) method is called in this constructor.. this is not the case. Does anyone know why? params[:photo].each_pair do |id, parameters| photo = Photo.new(parameters) end class Photo

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

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

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFooTable and updated the migration to look as follows: class

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

Hi there, I have a file upload form on my page that is for images. In the model I have this: def file_data=(file_data) @file_data = file_data write_attribute ''extension'', file_data.original_filename.split(''.'').last.downcase write_attribute("content_type", file_data.content_type) write_attribute("current_name",

I thought I found how to post a file to my controller for PaperClip attachment processing , but I am stuck with the the RestClient processing I am creating the file from the email attachment : file = StringIO.new(part.decoded) file.class.class_eval { attr_accessor :original_filename, :content_type } file.original_filename = part.filename file.content_type = part.mime_type # then adding some

I''m currently new to Rails and Ruby and I''m trying to learn from my mistakes, this time I''m trying to upload 2 files from a form for later processing, however, after I hit the "Submit" button. I keep getting this error: TypeError in UploadFilesController#create app/controllers/upload_files_controller.rb:28:in `new''

i have a problem with the datetime format of rails. i am unable to save a dataset to the db. here''s the error message -- the original error message was in german, so i translated it -- i get: DBI::DatabaseError: Execute OLE error code:80040E07 in Microsoft OLE DB Provider for SQL Server Couldn''t convert a char-Datatype to datetime HRESULT error code:0x80020009

Hi there, I''m writing a little application that parses an image file and extracts the camera settings from the file (the EXIF data) and saves all the fields to the database. The idea is that after awhile people will be able to search based on camera make, model, lens settings, etc... and all the pictures that meet those requirements will be displayed. The picture is stored on the file

Hi. I''m setting up an upload form for internal users of a Rails site, and I''m trying to use the Upload Progress Bar plugin from http://sean.treadway.info/demo/upload/. I followed the directions as set out in the Rails Wiki (http://wiki.rubyonrails.org/rails/pages/Upload+Progress+Bar). Basically the problem is no progress bar or any upload information shows up. In WEBrick, I

There is something seriously wrong with DBI support for SQL server. I have tried both DBI::ODBC and DBI:ADO and the following code always fails. ---------- Code require ''dbi'' host= "DEVELOPMENT_DATABASE_SERVER" database="adventureworks2000" username="someusername" password="Somepwd" db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data

Hello everyone, I''m fairly new to Rails (writing my first real app) and brand new to this mailing list. I''ve got a rails/sql error I just can''t seem to solve. It''s probably really simple, but I''m been googling and reading for a day and have made zero progress on it. Hopefully someone on this list can shine some light on my problem, or point me in the