Post New Web Links

SQLNCLI10 vs SQLNCLI10,1

Posted By: Posted Date: April 14, 2011 Points: 0 Category :

Hi,

What is the different between SQLNCLI10 and SQLNCLI10.1? If we define the provider, which one we should use so that if there is a new version e.g. 10.2, we don't have to update the connection string.

Thanks,

Kenny

View Complete Post

More Related Resource Links

SQLColumns and SQLColAttributes return different attribute for TIME datatype using SQLNCLI10 driver

Hello everyone,

I am using SQL Server 2008 native driver. When I query the attributes of a TIME column in SQL Server 2008, I see that using SQLColumns() API, I get length as 10 whereas with SQLColAttributes() I get the length as 12.

My application stores the column attributes got from SQLColums() call and use that length during a SQLBindCol(). Since SQLColumns() give me 10 as length, when I bind a buffer of 10 bytes, I get a "numeric overflow" error.

Please let me know if there is some setting that I might do so that attributes returned from SQLColums() and SQLColAttributes() are same.

TIA,

Navneet


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All