From: gregarican <greg.kujawa@...>
Date: 2005-08-09T03:51:08+09:00
Subject: Ruby DBI Error

I have been using Ruby v1.8.2 with DBI v1.42 for awhile now and it has
been pretty much smooth sailing. There is a new SQL Server 2000
database I am attempting to connect to and persistently get connection
errors using Ruby DBI. Here is a snippet of the connection string I'm
trying:

DBI.connect('DBI:ADO:Provider=SQLOLEDB;Connect Timeout=5;Data
Source=sawmill-arms;Initial Catalog=dbsARMS_B01;Persist Security
Info=True;User ID=sa;Password=xxxxxxx165;')

Here is the error I am receiving:

OLE error code:80040E4D in Microsoft OLE DB Provider for SQL Server
      Login failed for user 'sa'.
    HRESULT error code:0x80020009
      Exception occurred.	from
c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:584:in `connect'
	from c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:384:in `connect'
	from monthlyCommissions.rb:3

This database requires SQL security so I can't get it to Windows
integrated security. There are other databases I connect to using
either Windows or SQL security without incident. The connection string
has only been changed in this post where I made x's rather than the
characters in the password.

I can log into the database fine using these credentials in another OLE
DB application. In this case it is Crystal Reports. Any ideas why Ruby
DBI isn't working for me?