Sorry for the delay in replying - I''m on holiday in Kerala, India at
the moment. Anyway, I''d suggest using the sql server adapter in ODBC
mode rather than ado. To do this (off the top of my head) you need a
database.yml file similar to this:
production:
adapter: sqlserver
mode: odbc
dsn: <full odbc dsn>
TOm
On 15/08/06, Nazar Bl <nazar@lpdirect.com> wrote:> 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 COLUMN_NAME as ColName, COLUMN_DEFAULT
> as DefaultValue, DATA_TYPE as ColType, COL_LENGTH(''S_RESIT
>
> I''ve tried using transactions in rails but to no avail, if I have
10
> windows open and refresh all at once, several windows will produce that
> error.
>
> MS suggests
> (http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B272358):
> Use a server-side or client-side cursor other than the forward-only and
> read-only (often called a firehose) cursor.
>
> Anyone know how to do this?
>
> Help is appreciated.
>
> Thanks,
> Nazar
>
> --
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>