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