Re: Errors in DBI docs

On 22/12/12 17:56, Lyle wrote:
> 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.

You can just download a recent unixODBC source tar ball and you'll find all the headers in there. They won't be identical to the ones on Windows but the ODBC constants should be.

ftp://ftp.unixodbc.org/pub/unixODBC/

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

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com