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
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.