tags:

views:

192

answers:

0
Q: 

difference between sql providers SQLOLEDB and 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 questions

Linked servers SQLNCLI problem. "No transaction is active"
Error- The SQLNCLI provider is not registered on the local machine.
Logon failed, Crystal Reports 9, VB6 , sql server, sqlncli
Changing SQL Provider from SQLOLEDB.1 to SQLNCLI.1 causes app to fail when accessing data via stored procedure
Upgrading to SQL Server 2005: Cannot INSERT QNAN into float column?
SQL Native Client crashes when second connection is opened when connection pooling is on?
SQL Native Client ODBC application not disconnecting after SQLDisconnect and not pooling?
sqlnclir.rll being loaded and unloaded continuously
Dead-lock issue created by 2 SQL connections, each using transactions, each working with a different table, with a foreign key constraint between the two tables
Need a row count after SELECT statement: what's the optimal SQL approach?
SQLBindParameter to prepare for SQLPutData using C++ and SQL Native Client
SQLGetData issues using C++ and SQL Native Client