So I’m introducing Rails to my workplace (enterprise! woo woo), and
I’m nearly finished with my first application. Because we’re using SQL
Server, I’m now getting zombie state errors.
Then I saw this post:
http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/220840
Here’s my confession, I’m developing on Vista using SQL Server to
deploy to Windows Server 2008 using IIS. So I know I’m already totally
off the Rails way. It seem like any other application using SQL
Server (not including Rails) opens and closes the connection for
individual transactions. The post I linked to earlier is a guy who
does exactly that. My question is, what’s the easiest and/or most
correct way to open and close the connection manually?