Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Katmai » Connectivity   (RSS)
Thursday, May 22, 2008 10:54 AM

Improved error messages about missing OLEDB providers

We've modified the OLEDB_NOPROVIDER error to return the name of the provider we failed to find. This will appear in the RC0 release of SQL 2008. SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.  The requested OLE DB provider SQLNCLI.1 is not registered.
Posted by mmasson | 0 Comments
Filed under: ,
Wednesday, May 21, 2008 4:53 PM

Package upgrade - connection strings

We tried to make our package upgrade as seamless as possible, but one problem we've seen people running into is with their connection strings. As I've previously noted, the provider name for SQL Native Client was changed in 2008 from SQLNCLI to SQLNCLI10.
Posted by mmasson | 3 Comments
Filed under: , ,
Friday, March 21, 2008 9:10 PM

Some notes about SQL Native Client in 2008

The SQL Native Client (SNAC) provider was renamed from SQLNCLI to SQLNCLI10 in 2008. The means that connection strings that used the Yukon provider (SNAC9) won't work if you only have the Katmai provider (SNAC10) installed. This will affect most SSIS
Posted by mmasson | 2 Comments
Filed under: ,
Thursday, June 07, 2007 9:40 AM

SQL Native Client 10 - provider name change

The provider name for SQL Native Client (SNAC) connections has changed in Katmai. Since this is the default provider for OLEDB connections, you'll probably be affected by this change if you're running SQL Server 2005 packages in Katmai. Version Provider
Posted by mmasson | 0 Comments
Filed under: ,
 
Page view tracker