>Hi,
>
>We are getting below error while running a query to show the date type data in SQL Server 2008.
>
> Msg 8114, Level 16, State 8, Line 1
> Error converting data type DBTYPE_DBTIMESTAMP to datetime.
>
>Sample Query:
> SELECT code, name, age, dob, doj
> FROM [open_rowset]...[emp_data]
>
> NOTE: dob & doj are date type fields.
>
>
>Thanks In Advance
>Ravi Mehrotra
SQL server doesn't have an understanding of empty dates while VFP has. You can use openquery instead. ie:
Select * from OpenQuery( VFPLINKEDSERVER,
'SELECT code, name, age, cast(evl(dob, null) as date) as dob, doj FROM emp_data')
Cetin