Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2010
    Location
    San Juan, Puerto Rico
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm getting this error running an openquery "Error converting data type DBTYPE_DBDATE to date." Exist a workaround to resolve this?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    We will need to know a bit more about your table structure, and about the query you are trying to run. Where is SQL Server 2008 encountering the data type DBTYPE_DBDATE? And is your query trying to return a column as a date that is some other type of column, for example text, or numeric? Finally, what does the query SQL statement look like?
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •