difference between sql providers SQLOLEDB and SQLNCLI

Posted by salman on Stack Overflow See other posts from Stack Overflow or by salman
Published on 2010-04-26T16:13:23Z Indexed on 2010/04/26 16:13 UTC
Read the original article Hit count: 744

Filed under:

sqlncli

Hi Everyone

I just need to know what's the difference between sql providers SQLOLEDB and SQLNCLI. I have one scenario where one SSIS package should fail. Now when I use SQLNCLI provider in the connection string the package terminates by throwing the error as expected. However when I use SQLOLEDB provider, the package behaves abnormally by ending successfully without throwing any error?

Can someone shed some light on this scenario? Thanks.

Related posts about sqlncli

difference between sql providers SQLOLEDB and SQLNCLI

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Everyone I just need to know what's the difference between sql providers SQLOLEDB and SQLNCLI. I have one scenario where one SSIS package should fail. Now when I use SQLNCLI provider in the connection string the package terminates by throwing the error as expected. However when I use SQLOLEDB… >>> More
Linked servers SQLNCLI problem. "No transaction is active"

as seen on Stack Overflow - Search for 'Stack Overflow'
Im trying to execute a stored procedure and simply insert its results in a temporary table, and I'm getting the following message: The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "MyServerName" was unable to begin a distributed transaction. OLE DB provider… >>> More
Error- The SQLNCLI provider is not registered on the local machine.

as seen on Stack Overflow - Search for 'Stack Overflow'
I get the above error in one of my apps. However there is no reference to using the SQLNCLI provider. I know before the ConnectionString had "Provider=SQLNCLI".However now its changed to "Provider=SQLOLEDB" (using OLEDB since the same app connects to Access and SQL database). Why then do I still get… >>> More
Why does SQL 2005 SSIS component install fail?

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SSIS on our production SQL 2005 SP2 box. Each time I try, the install/setup screen results in failure, starting with the native client, and moving on down. Screen shots below show what I see: Here is the result of clicking on the status link to the right of the native… >>> More

Developer IT

difference between sql providers SQLOLEDB and SQLNCLI - Developer IT

difference between sql providers SQLOLEDB and SQLNCLI

sqlncli

Related posts about sqlncli

difference between sql providers SQLOLEDB and SQLNCLI

Linked servers SQLNCLI problem. "No transaction is active"

Error- The SQLNCLI provider is not registered on the local machine.

Why does SQL 2005 SSIS component install fail?

Categories cloud