Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2005 Conectivity to SQL 2000


SQL 2005 Conectivity to SQL 2000

Author
Message
Rafael A. Colón
Rafael A. Colón
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 Visits: 169
Help (Out-of-process use of OLE DB provider):w00t:

We have a SQL server (SQL2005 Sp2 (3054) on our company that every night executes a SQL job (use Stored Procedures, no executables involved) that sends records to 4 different remote servers in the Same Building. All these servers are SQL2000 SP4 (8.00.2187) Enterprise Edition. The operating System in all servers is MS Server 2003- NT 5.2 (3790). The SQL job usually takes about 2 hours to complete but this week is started to fail only for one of the servers our Development team found a problem with a store procedure and is working on a hot fix, But last night our DBA team decided to put a trace in the SQL job to find out if there was any other error that we can capture and found the following error in the trace :

Msg 7430, Sev 16, State 3, Line 10 : Out-of-process use of OLE DB provider "SQLNCLI" with SQL Server is not supported. [SQLSTATE 42000]

After that happened we resubmitted the job on the same step and it completed without errors in less than 15 minutes, we have researched the internet to try to find out an explanation of this error but so far there is not much luck.

We only found this document but it has not been much help (http://msdn.microsoft.com/en-us/library/ms143359.aspx)

THis is na extract of that document:
--=========================================================================
A linked server that was defined by using 'SQLOLEDB' as the provider name will be modified to 'SQLNCLI' (SQL Native Client OLE DB Provider) upon upgrade. The sys.sysservers compatibility view shows linked servers that use 'SQLNCLI' as 'SQLOLEDB'. The SQL Server 2005 catalog view sys.servers shows linked servers that use 'SQLNCLI' as 'SQLNCLI'.

Heterogeneous queries and the use of OLE DB providers are not supported when SQL Server is running in fiber mode. Fiber mode is enabled when the lightweight pooling advanced configuration option is set to 1.

The SQL Native Client OLE DB Provider cannot be instantiated out-of-process.
--=========================================================================

If anybody has any additional information regarding this error will be greatly appreciated.BigGrin

Thank You,
Rafael A. Colón
Database Administrator, Information Systems
Stericycle, Inc.
www.Stericycle.com
Jarda Jirava
Jarda Jirava
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 6
Hi,

I know, it's too late to answer your question. Hope that it helps someone other. SQL Native Client provider cannot run out-of process so what you need to do is to check AllowInProcess property in SQLNCLI Provider (in Management studio under Linked server-Providers).

Regards

Jarda Jirava, Microsoft MVP - Client Application, MCAD, MCPD
http://jirava.net/blog
Lempster
Lempster
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2683 Visits: 1657
Jarda Jirava (7/9/2009)
Hi,

I know, it's too late to answer your question. Hope that it helps someone other. SQL Native Client provider cannot run out-of process so what you need to do is to check AllowInProcess property in SQLNCLI Provider (in Management studio under Linked server-Providers).


I have the same issue, but the AllowInProcess box is checked. Is there something else that needs to be configured and/or is there another cause of the error message?

Thanks
Lempster
jonnyCakes
jonnyCakes
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 12
same issue here. Allow in process is checked.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search