I'm trying to create a binding to a stored procedure on a SQL server. I can create the database connection and view the tables and stored procedures. When I try to create a stored procedure binding I can choose the connection and the procedure. But when I check "Returns DataSet" and click Test... I get the following error after a minute or so:

A server timeout has occured. Here are the possible reasons.
1. Please make sure that the webserver is up and running.
2. Please verify that the ODBC DSN exists on the testing server.

My webserver is up and running and the web.config file is the same on both the local machine and testing server.

I can create datasets (querys) on the database tables. It's only when I try to generate a dataset from a stored procedure that run into problems.
I'm at a standstill.
If it matters I'm using ASP.NET VB, SQL Server 2000, and Dreamweaver MX 2004.