Connecting To Sql Server

[jaydwest]

I'm trying to create a connection string to access SQL Server 2000 stored procs from MS Access 2003. I created a connection string using a UDL and attempted to execute a stored proc. When the stored proc executes, I get the following error.

This connection cannot be used to perform this operation. It is either closed or invalid in this context.

I know the connection is open. Any thoughts about what could cause this?

Thanks in advance for your help.