User Profile

Collapse

Profile Sidebar

Collapse
afrotec2k
afrotec2k
Last Activity: Sep 11 '08, 09:23 AM
Joined: Sep 10 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • afrotec2k
    replied to How to isolate a DBTYPE_DBTIMESTAMP to datetime error?
    in SQL Server
    Hi

    The source is a Progress database.

    I've spoken to a colleague in the office and he suggested using a cursor to find the error, however when this employed, it returns a huge error message relating to various columns within the Progress database.

    The error may be appearing because the Progress database (via the linked server) uses a different datestamp to SQL Server or because there is a problem with...
    See more | Go to post

      Leave a comment:

    • afrotec2k
      started a topic How to isolate a DBTYPE_DBTIMESTAMP to datetime error?
      in SQL Server

      How to isolate a DBTYPE_DBTIMESTAMP to datetime error?

      Hi I am trying to extract data using SQL Server 2005 from a table on an ODBC linked server using the following syntax:

      select *
      from [Server]..[Schema].[Table]

      When I run the query the following message appears:

      'Error converting data type DBTYPE_DBTIMEST AMP to datetime'

      I know that this is because a date or dates have been incorrectly input into the source database (e.g. 200-06-01...
      See more | Go to post
      No activity results to display
      Show More
      Working...