>>Hello,
>>
>>I have trouble working with Date fields in SQL Server 2008. when I use Date type, it returns as Character(8) in queries. So I need to use datetime fields, but obviously the program should not display the time part of the datetime field. Has somebody found a good practice to work around this issue?
>
>Check if this thread Re: SQL Server 2008 Date Field Thread #1379346 Message #1379397 can be of some help.

Indeed it helped. I have to use "SQL Server Native Client 10.0" in StringConnect.