hi
i am programatically analysing a table in sql server using
Set objColumnRS = objconn.OpenSchema(adSchemaColumns, _
Array(Empty, Empty, objtable("Table_Name").Value))

i have created a table and called fields aDatatype
so an int field will be called aInt , text field aText etc
then I debug.print the results from objColumnRS("data_type") when i loop through objColumnRS
it seems to be working fine BUT I am getting the value from a binary field to be the same as that of a timestamp field ( the value returned is 128 ) my goal is to find out what datatype the field is but a binary field is obviously not the same datatype as a datetime field my results from the debug are below - and my question is how do i determine exactly what type of datatype the field is
( the number is what is returned from objColumnRS("data_type") the name is returned from objColumnRS("column_name") - and as you can see many numbers are the same - despite being different datatypes the one that bothers me most though is the binary being the same as a date ?! the others are at least both either numeric or text...

128 aBinary
129 aChar
135 aDateTime
131 aDecimal
5 aFloat
128 aImage
6 aMoney
130 aNchar
130 aNtext
131 aNumeric
4 aReal
135 aSmallDateTime
2 aSmallInt
6 aSmallMoney
129 aText
128 aTimeStamp
17 aTinyInt
72 aUniqueIdetifier
128 aVarBinary
129 aVarchar
130 nvarchar
3 aInt

thanks