similar to: MS-SQL Server dropping connections

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

Hey guys, For some strange reason, I started getting this error message this morning: Execute OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Connection failure HRESULT error code:0x80020009 IF I restart apache and scgi_service, the problem goes away. However, 10 minutes later, it comes back Any ideas? _______________________________________________ Rails

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

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

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

hey there folks, i have a bit of a sitch here and i would love some help/input on it. i''ve inherited a horrible asp/mssql app that i''m re-writting using rails, but unfortunately i have to keep the asp version up and running. in order to do so i''ve had to write some admin functions, which i''ve done in rails. because the mssql schema wasn''t written

I have committed a fix for the panic that happened with the da(4) or cd(4) drivers configured and INVARIANTS turned on. Let me know if there are any problems/comments/questions. Ken ----- Forwarded message from "Kenneth D. Merry" <ken@FreeBSD.org> ----- From: "Kenneth D. Merry" <ken@FreeBSD.org> Date: Tue, 9 Sep 2003 17:40:40 -0700 (PDT) To:

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

We''re using migrations to manage a SQL Server project and have been running into a number of issues with db_schema_dump/migrations. Can anyone confirm that these are actual issues with the SQL Server adapter and not issues with me :) 1) Fields are not properly setup with proper null settings (:null => true / false). I''m wondering if we need to update the def columns method

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

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''m trying to use activerecord outside of rails with a legacy mssql database. Reading from the db works, but when I try to save a new object (i.e. insert) I get the following error. DatabaseError: Execute (ActiveRecord::StatementInvalid) OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction

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, I am trying to walk through the following document: http://homepages.lu/charlesschwartz/radius/freeRadius_AD_tutorial.pdf in order to authenticate Cisco router and switch logins against FreeRadius/Active Directory. Using the HowTo, I have successfully joined a FC2 box to our Windows 2003 AD for testing purposes. I have also successfully used the manual ntlm_auth command to authenticate

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:

I would appreciate any tips/clues/advice very much. I have started using ruby on rails and when the MS SQL Server database is on a different box than my dev box (where the RoR app is located) I can connect fine. However when I try to connect to a MS SQL Server database on the same box as my RoR app I get an error. I have tried to use the IP address of the dev box as the value of

Greetings, I've been subscribed to this list for some time and I'd like to start off by thanking everyone who helps out on it. This is my first post to it, so please be gentle :-) I have several offices set up with RedHat and CentOS terminal servers. We are using CentOS 4.6 and RedHat 4.6 on them, GDM for the display manager, and PXES (http://sourceforge.net/projects/pxes/) for the

Hi! I've tried to install several games in Wine; however, many of them can't even be installed. They should work pretty well according to the AppDB, so it has to be a problem with my computer... The problem comes up as soon as the program starts copying the files. The first few files are copied without any problems, however. OS: Ubuntu 8.10 Wine version: 1.1.13 (I upgraded after it

WINE 1.1.18 has a regression from WINE 1.1.14. Once again, GP4 no longer installs from CD... the console outputs the following ole error repeatedly: err:ole:xCall Failed to serialize param, hres 80040155 err:ole:deserialize_param Failed to read integer 4 byte err:ole:TMStubImpl_Invoke Failed to deserialize param State, hres 80004005 err:rpc:I_RpcReceive we got fault packet with status 0x80004005

this is the error's I get running WoW in terminal via wine. Code: fixme:mshtml:nsHttpChannelInternal_SetDocumentURI (0x56caa20)->() fixme:mshtml:nsChannel_SetReferrer (0x56caa20)->(0x558b540) fixme:mshtml:HttpNegotiate_GetRootSecurityId (0x5684110)->(0x33dd4c 0x33dd40 0) fixme:shdocvw:ClOleCommandTarget_Exec Unimplemented group {000214d0-0000-0000-c000-000000000046}