Open / Close Connection

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:

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?