Executing a stored procedure that uses linked server from vb.NET

I can't execute my stored procedure from .NET (I think it might be
because the stored proc has joins in it via linked servers). I get
timeout error from .NET

MyBase.connString ="Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=DB;Data Source=Server;"

MyBase.selectString = "Exec sp_storedprocedure1 var1,var2,var3"
MyBase.GetDataSet()

The stored procedure takes the 3 arguments and uses joins to 2 other
db-servers that I have access to via linked server connections. (MS SQL
Server)

I can run the stored proc on in QA on my MS SQL with no prob.

Must i open connections to the 2 linked servers from .NET as well?

Glad for any opinions so i dont have to rewrite my sp,

Mikael

.

Relevant Pages

  • command timeout does not work
    ... The 2nd Stored Procedure returns a Record, while the 1st is not selecting ... linked servers. ... The ADO query does not run in Transaction nor does any transaction opened in ... SET NOCOUNT ON is set in both Stored procedures. ...
    (microsoft.public.data.ado)
  • @@REMSERVER with linked servers
    ... My system has multiple databases spread over multiple ... Procedure to call another Stored Procedure in another ... are on the same server but = 1 if on linked servers. ... @@REMSERVER would be non-null if the ...
    (microsoft.public.sqlserver.security)
  • Re: Dependencies of stored procedures in DTS packages
    ... SP_depends is the stored proc I was referring to. ... >> objects from the sysdepends table. ... >> it depends on the missing object 'you stored procedure name here'. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.dts)
  • Re: Update statement performance decreases in stored proc
    ... Have you had a look at the execution plan of the stored procedure? ... Here are the important parts of the stored proc: ... I found that this was casued by the UPDATE statement at the end ...
    (microsoft.public.sqlserver.programming)
  • Re: RETURN_VALUES ??? done... What have I gained?
    ... b (aka whipper-snapper) ... > similar questions via stored proc and can set up a function to do the work ... >> tAdoDataSet is really easy to use. ... >> dataset even though you are pointing to a stored procedure. ...
    (borland.public.delphi.database.ado)