Advertisement

05.08.2008 at 07:49AM PDT, ID: 23386259 | Points: 250
[x]
Attachment Details

Could not relay results of procedure [OLE/DB provider returned message: Timeout expired]

Asked by kinton in Microsoft Programming, MS SQL Server

Tags: Could not relay results of procedure [OLE/DB provider returned message: Timeout expired]

Hi,
I am trying to run a remote procedure call between two linked sql servers and am receiving the following error:

"Could not relay results of procedure [OLE/DB provider returned message: Timeout expired]."

The remote query and login timeouts have been set to 0 (infinite) and yet I am still receiving the error message.

Are there any ways around this?

The properties of the SQL Server I am trying to access are as follows:
Data Access, RPC and RPC out are all checked,
Collation compatible and Use remote collation are not checked.
Connection Timeout and Query Timeout are both set tp 0.

Any help with getting around this would be extremely grateful.
ThanksStart Free Trial
 
Keywords: Could not relay results of procedure […
 
Loading Advertisement...
 
[+][-]05.08.2008 at 08:24AM PDT, ID: 21525531

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.08.2008 at 08:27AM PDT, ID: 21525547

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.09.2008 at 12:20AM PDT, ID: 21530892

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.09.2008 at 12:41AM PDT, ID: 21530965

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.09.2008 at 01:30AM PDT, ID: 21531112

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.09.2008 at 03:40AM PDT, ID: 21531542

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628