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

Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links


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


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.



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.



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