.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


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.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend