Re: Errors in DBI docs

On 22/12/2012 09:14, Tim Bunce wrote:
>> I have a copy of the SQL:2011 standard, yet I cannot seem to find a
>> list of numbers correlating to data types? Is this DBI specific? Is
>> it still supported? Am I missing something?
> It's not DBI specific. I've attached the copy I have.

Thanks. This has led me to the relevant section of the 2011 (which is 
the same as 2008) SQL/CLI page 80:
     Table 7, "Codes used for implementation data types in SQL/CLI", 
specifies the codes associated with the
SQL data types used in implementation descriptor areas.

Now my current challenge is finding the ODBC definitions, which has thus 
far been unfruitful. I've been right through the current ODBC documentation:
http://msdn.microsoft.com/en-us/library/windows/desktop/ms710252%28v=vs.85%29.aspx
Failing that, tried finding the ODBC SDK. Searches in MSDN downloads 
only seemed to turn up MDAC:
http://www.microsoft.com/en-us/download/details.aspx?id=21995
Which didn't include the header files mentioned here (which I assume 
must contain the codes I seek):
http://msdn.microsoft.com/en-us/library/windows/desktop/ms713603%28v=vs.85%29.aspx

I did manage to find some second hand references to ODBC data type codes 
from SQL Server 2000:
http://msdn.microsoft.com/en-us/library/aa179135%28v=SQL.80%29.aspx
and open XML:
http://msdn.microsoft.com/en-us/library/office/documentformat.openxml.spreadsheet.parameter.aspx

On google I found some notes from Denis Box at Fermilab USA, who had the 
same troubling finding them (interesting as he references your book as 
the only place he could find them):
http://home.fnal.gov/~dbox/SQL_API_Portability.html

... Ah, found a copy of the header files, they come with the Windows 7 SDK:
http://www.microsoft.com/en-us/download/details.aspx?id=3138
By default it'll try to install all sorts, but you only need to select 
the header files. sqlext.h contains the ODBC SQL extended datatype codes.

I'm still doing this post because:
A) Others who get stuck looking for this may find this post. Google 
brings up the DBI archives quite a lot for non DBI specific searches on 
this kind of thing
B) Checking the header file doesn't seem like the ideal solution. 
Somebody might know of an official MS resource where this is properly 
defined?

>> If I can help with this, let me know, I can submit patches.
> I'd be delighted to get patches updating those. Thanks!

Working on it. If no one comes back with a better resource, should I add 
a description of how to find the ODBC codes from the header files?


Lyle