Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 Conectivity to SQL 2000 Expand / Collapse
Author
Message
Posted Thursday, May 15, 2008 10:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 4:12 PM
Points: 231, Visits: 143
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.:D

Thank You,
Rafael A. Colón
Database Administrator, Information Systems
Stericycle, Inc.
www.Stericycle.com
Post #501484
Posted Thursday, July 9, 2009 3:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 6, 2012 2:00 AM
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
Post #750006
Posted Wednesday, December 30, 2009 2:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:13 AM
Points: 2,036, Visits: 1,380
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
Post #840223
Posted Friday, November 8, 2013 9:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 20, 2014 11:43 AM
Points: 1, Visits: 9
same issue here. Allow in process is checked.
Post #1512726
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse