need help from a VB.net expert…. Hitting SQL server taking 3 minutes….

Hi all.

Here is my problem.

We have a SQL procedure that we were calling in a development environment, no problem… ran fairly fast…. no difference between the time it took to run in SQL server management studio and the VB app.

We move it to a staging environment…

The proc takes a few seconds longer to process on SQL Server, (about 12 seconds) but it takes about 3 minutes to process through Visual studio.net.

The only thing I changed was the server name in the connection string.

Does anyone know what could do this?