>>>>Does anyone have any experience with the date field that was added to SQL Server 2008?
>>>
>>>What is the question that requires experience? It is a date field (like date only version of datetime).
>>>If you would ask:
>>>-Why you get it back as a character value then I would say my guess would be that you are using and older version's driver.
>>>-If it supports 'empty' no it doesn't, defaults to 1/1/1900.
>>>-Its range, from Jan 1, 1 to Dec 31,9999.
>>>-Accuracy, one day, storage 3bytes.
>>>
>>>Nothing else special about it I think.
>>>Cetin
>>
>>Thanks for responding.
>>When you say older driver are you refering to the ODBC driver?
>
>No not specifically ODBC but the ODBC or OLEDB for SQL2000, 2005. ie:
>
handle = SQLSTRINGCONNECT('Driver={SQL Server Native Client 10.0};'+;
> 'Server=.\sql2008;Database=myDb;Trusted_Connection=yes;')
>works while
>Driver={SQL Server Native Client}
>Driver={SQL Server}
>
>do not. Older drivers have problems with new data types.
>Cetin
Thanks. I am looking into it.