Re: GetOleDbSchemaTable enumeration for DATA_TYPE

If you are using SQL Server, these numbers map to the same SQL types used in
ADO and OLEDB enumerated in the platformSDK file OLEDB.H (look for enum
DBTYPEENUM).

You might want to post this in the managed newsgroups to get a better
answer.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Uwa Agbonile[MSFT]

"JohnMSyrasoft" <JohnMSyrasoft@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF383184-7E94-4ABC-8FE8-0D1BA0F93986@xxxxxxxxxxxxxxxx
> Hi, I'm using GetOleDbSchemaTable to retrieve schema information for
columns
> in a specified table. I'm placing the results in a DataTable and
everything
> is working well. I can look through the DataRows and see the correct
column
> names in the "COLUMN_NAME" column. I also can read the values from the
> "DATA_TYPE" column and they are consistent. However, these values are
> integers. Which enumeration should I use to translate them? So far, it
> seems as though
>
> Integer = 3
> Currency = 6
> Date = 7
> Boolean = 11
> String = 130
>
> Anyway, can you point me to the full enumeration? Thanks in advance.


.