Post reply

Linked Server Date problem

  • January 7, 2010 at 8:10 am

    #215464

    I have a SQL Server 2k8 machine with a linked server to another SQL 2k8 machine. When executing the following query:

    SELECT 1

    FROM LinkedServer.LinkedDatabase.dbo.Dim_Date

    WHERE Calendar_Date >= CONVERT(DATE,getdate())

    I get the following error:

    OLE DB provider "SQLNCLI10" for linked server "ATXSQL09" returned message "Unspecified error".

    OLE DB provider "SQLNCLI10" for linked server "ATXSQL09" returned message "The scale is invalid.".

    Msg 7322, Level 16, State 2, Line 1

    A failure occurred while giving parameter information to OLE DB provider "SQLNCLI10" for linked server "ATXSQL09".

    I can work around this by converting the date to datetime but would like to understand what the problem is since the date data type should be supported on both sides.

    Thanks for any help,

    Brian.

  • January 7, 2010 at 8:18 am

    #1100249

    My mistake. It is actually a SQK 2k5 instance that I'm connecting to.

  • January 8, 2010 at 1:52 am

    #1100742

    You are converting to a date datatype, but that doesn't exist on SQL 2005 only 2008. Try DateTime instead

  • May 14, 2012 at 4:21 am

    #1487007

    Thanks SSC Veteran, just has the same problem which had me perplexed for a good hour then found your answer. 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply