Binding DTC to the DateTime Field in the SQL server

Hi every one,

I have two DateTime Controls. one displays the Medium date (27-Apr-01)and the other displays the time (12:12:00 PM).

When I tried to bind this two controls to the DateTime field in the SQL server 6.5 Table, I get the error "Unable to bind to the field"

How ever, I can bind this Date Time controls to the Date/Time fields in the Access 2000 database. IN this Access database, I have selected "Medium Date" and "Medium Time" as the formats for the two fields.

Is there any way to bind the DateTime controls to the Date/Time fields in the SQL server Tables?


I have one more Question.

I have a Datacombo control, which is populated with the Company names. when the user selects a company name, I need a text box in the same form, to be populated with the Contact person of that company.


Any help is greatly appreciated.

Thank you.
sincerley,
Rathi.J