Error converting data type DBTYPE_DBTIMESTAMP to datetime

• bratz111685

  Valued Member

  Points: 71

  More actions

  November 18, 2007 at 7:46 pm

  #70449

  Hi everyone, Im a newbie here.

  I have created a linked server on SQL Server 2005 to access data from visual foxpro database. I execute a query "Select * from OpenQuery(members, 'Select * from memfile')" but Im getting an error message: Error converting data type DBTYPE_DBTIMESTAMP to datetime.

  How can i retrieve the data from the query? Can anyone please help me or give me an example syntax. I urgently need it in my project. Thank you.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  November 19, 2007 at 2:48 am

  #752175

  The TIMESTAMP data type of SQL Server is not equivalent to DATETIME.

  It is equivalent to BINARY(8).