Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Serge
Starting Member
44 Posts |
 Posted - 2008-02-13 : 06:41:59
|
| Hi,I have this really annoying issue and wonder if anyone else has came across it before and know a way around it. I am writing an app in VB.NET that fires of a stored procedure against an SQL server and waits for the results to come back so that the virtual table can be presented on windows form. The problem is this. When I ran the same sproc with the same parameters through SQL Management Studio it takes no longer than one minute to respond, but when I run the same sproc from my app it takes forever and it never returns anything, just hangs there waiting. I have the same credentials in my connection string to the DB as the ones I use in Management Studio. I am totally lost...Please helpSerge |
|
|
scootermcfly
Yak Posting Veteran
66 Posts |
Posted - 2008-02-13 : 21:01:23
|
| Can you post some of your code so that I can take a look? It's hard to say what is going on without seeing what type of connection you are using to retrieve the data. How much data is in the table that will be returned?Scooter McFly |
 |
|
|
|
|
|
.NET problem connection to SQL