search for: 80040e14

...elpindex Foo 54 SQL:BatchCompleted IF @@TRANCOUNT > 0 ROLLBACK TRAN 54 And finally the log file contains the following: # Logfile created on Wed Jan 18 23:10:19 Eastern Standard Time 2006 by logger.rb/1.5.2.4 [4;36;1mSQL (0.000000) [0;1mDBI::DatabaseError: Execute OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server There is already an object named ''schema_info'' in the database. HRESULT error code:0x80020009 Exception occurred.: CREATE TABLE schema_info (version int) [4;35;1mSQL (0.000000) DBI::DatabaseError: Execute OLE error code:80040E14...

...e_adapter.rb:19:in `__send__'' c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in `run'' 2) Error: test_limited_eager_with_multiple_order_columns(EagerAssociationTest): ActiveRecord::StatementInvalid: DBI::DatabaseError: Execute OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server ORDER BY items must appear in the select list if SELECT DISTINCT is specified. HRESULT error code:0x80020009 Exception occurred.: SELECT * FROM (SELECT TOP 2 * FROM (SELECT DISTINCT TOP 3 posts.id FROM posts LEFT OUTER JOIN authors ON au...

...line_items array to the quote object (so they are saved as child records) I get a nasty SQL error. Rails appears to be trying to save the internal object reference to the DB, instead of the attributes. I can''t figure out why, or how to fix it. DBI::DatabaseError: Execute OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server The name "#" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. HRESULT error code:0x80020009 Exception occurred.: INSERT INTO line_items (...

...und the name as is required for SQL Server for names with spaces. ------------------- c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_ adapters/abstract_adapter.rb:88:in `log'': DBI::DatabaseError: Execute (ActiveRec ord::StatementInvalid) OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server Incorrect syntax near the keyword ''all''. HRESULT error code:0x80020009 Exception occurred.: SELECT * FROM all wells with apis from c:/ruby/lib /ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapte...

...int identity(1, 1) not null in SQL. I quit using uniqueidentifier as Rails gets very confused. I cannot add a Product<->Category relationship via Rails, like: aProduct = Product.find(41234) P.categories << aCategory It throws an exception coming from SQL: Execute OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server Line 1: Incorrect syntax near '')''. HRESULT error code:0x80020009 Exception occurred.: INSERT INTO partners_recipients () VALUES () While it is obvious the SQL statement fails, I don''t understand why Rails gener...

Hi, I have been encountering this error when I try to save text with japanese characters: DBI::DatabaseError: Execute OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server Line 1: Incorrect syntax near ''20070730''. HRESULT error code:0x80020009 Exception occurred.: INSERT INTO categories ([category_name], [updated_at], [created_by], [updated_by], [description], [created_at]) VALUES(''...

...8/gems/activerecord-1.14.2/lib/active_record/base.rb:1323:in `validate_find_options'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:376:in `find'' --- @perm = Permission.find(@user.id,@sector.id) gives: DBI::DatabaseError: Execute OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server Incorrect syntax at '',''. HRESULT error code:0x80020009 An exception occured.: SELECT * FROM PERMISSION WHERE (PERMISSION.FK_USR_ID,FK_SECT_ID IN (''gfk'',3)) --- Any idea on how to do it? Thanks a lot, GFK''...