similar to: Weak DBI support for MSSQL (was rails and MSSQL transactions)

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

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

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

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?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:

This error appears when y try to login into a SQL server . I run the aplication Silverlab.exe ( in VB6) , and in the first windows appear a image and two butonms 1 for exit an 2 to login ... I press a bottom "Login " and .... in a windows the wine put: Database Engine Open Error ! Server Name : Connection_String = Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial

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''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

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''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

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

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],

Hi Rowland, Yes, thats done, the domain user exist on both servers in local sudo group. But why do i see much more groups on the ADDC, and even groups where this user is NOT member of, like 3000005(NTDOMAIN\denied rodc password replication group). See .. 2x 3000005(NTDOMAIN\denied rodc password replication group 3000005(NTDOMAIN\denied rodc password replication group Greetz, Louis >

> > I love diving : ) > Ok mathias, Can you explain this. This i dont get.... Why is this output so different, and i dont mean the difference with NTDOMAIN\.. See the groups differences... between a ADDC and a member server.. Samba 4.4.3 ADDC id someusername uid=10002(NTDOMAIN\someusername) gid=10000(NTDOMAIN\domain users) groups=10000(NTDOMAIN\domain

Hi, I trieed umpteen times to connect ruby on rails to MSSQL server using the standard procedures and I always get the samw error. As I was previously working with MYSQL I faced no problem .Now at a time critical situation I need a solution for this........... Open OLE error code:800A0E7A in ADODB.Connection Provider cannot be found. It may not be properly installed. HRESULT error

To all, I am using Dovecot on solaris 10. Home directories are mounted using NFS. However, they are not readable by root. I compiled Dovecot from the source. I set the following environment variables: export LDFLAGS='-L/local/software/openssl/lib -R/local/software/openssl/lib' export CPPFLAGS=-I/local/software/openssl/include Then I ran gmake and the gmake install. In the server

I''ve been asked to make my app work on Windows Server 2003 and connect to SQL Server. I''m having trouble getting connected to SQL Server. It fails as follows: is not a class/module C:\InstantRails-1.0\ruby\lib\ruby\site_ruby\1.8\dbi\dbi.rb:499 in ''load_driver'' So, I went through the instructions on the Rails/MSSQL page. I installed the ADO.rb stuff. Also,

[Reposted now I've joined the list, so I hopefully don't get moderated out] Hi, I've upgraded lots of machines to 5.6 (thanks!) and there was one particular machine that I'd also like to upgrade to PHP 5.3. Unfortunately it seems I can't. On the machine I have php-mssql installed, and it appears that there is no php53-mssql. php-mssql is built from the php-extras SRPM, so

Hi all, I''m trying to get rails up on mssql for a friend, does anyone have experience? We''re working on a Windows XP box with MSSQL 2000 (no service pak), and both rails (1.1) and MSSQL are on the same box. I''m running into a bug (I think) where activerecord is using this syntax: SELECT TOP 1 * FROM users WHERE (users.user = ''jbgnuumnbu'')

Hi, I have an app with Delphi7 + MSSQL, developed during 10 years. Now, the users have asked me about some way to run this app into Linux Fedora Core 2/3. I use Fedora for apps in Java with no problems, but I never heard about Delphi run. I look at WineHQ site about this combination of Delphi + MSSQL but I didn't find. I found some thing about Delphi 7 install and slow behaviour in