[Ruby-DBI-devel] Trouble Using Ruby/DBI and Microsoft Sql Server 7

[John L. <JL...@ib...>]

Hi,

I've been using ruby/dbi with sqlrelay lately and am having some problems
with code pausing indefinately. When I kill sqlrelay I get the following
stack trace:

Error occurred in
test_get_ati_user__strange_case_on_firstname(TC_SQLRelayUserPersistenceStrat
egy): DBI::ProgrammingError: Failed to execute the query and/or process the
result set. A query, bind variable or bind value could be too large, there
could be too many bind variables, or a network error may have ocurred.
     /usr/local/lib/site_ruby/1.6/DBD/SQLRelay/SQLRelay.rb:203:in `execute'
     /usr/local/lib/site_ruby/1.6/dbi/dbi.rb:1039:in `execute'
     /usr/local/lib/site_ruby/1.6/dbi/dbi.rb:631:in `execute'
 
/home/jlong/workspaces/websites/secure.iblp.org/login/library/persistence/tc
_sqlrelay-user-persistence-strategy.rb:85:in `normalize_db'
 
/home/jlong/workspaces/websites/secure.iblp.org/login/library/persistence/tc
_sqlrelay-user-persistence-strategy.rb:9:in `set_up'
 
/home/jlong/workspaces/websites/secure.iblp.org/login/library/persistence/tc
_sqlrelay-user-persistence-strategy.rb:92

There doesn't seem to be much rhyme or reason to why it does this, but
happens consistently. I suspect it may have something to do with the number
of times execute is called durring a session. (I can get my tests to run
successfully by commenting out a few of them so that there aren't as many
queries run. As far as I know there are no dependancies between tests that
would cause the problem.)

I've been poking around with it all day but haven't been able to figure it
out. Before I spend any more time on the problem I thought I would ask if
anyone else has experienced something similiar. Is there a bug in the
SQLRelay DBI driver?

Thanks.

--
John Long
http://wiseheartdesign.com