Error when using openrowset for particular record

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kallem
    New Member
    • Jan 2011
    • 6

    Error when using openrowset for particular record

    Hi,
    I am executing following query
    [INSERT INTO OPENROWSET('MSD ASQL', 'Driver=Postgre SQL Unicode;uid=pos tgres;Server=lo calhost;port=54 32;database=dat a;pwd=XXXX',
    'SELECT projectCode,pro jectName,projec tDesc,expectedb enifits,AttachF ileNames,lastup dated,userid
    FROM Project WHERE projectCode = ''-1'' ')
    SELECT projectCode,pro jectName,projec tDesc,expectedb enifits,AttachF ileNames,lastup dated,userid from Project where projectCode=110 3]

    and i am getting following error
    Msg 8152, Level 16, State 10
    String or binary data would be truncated.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Just looking at the error message, it means the value you are trying to store is longer than the structure of your table.

    Good Luck!!!

    ~~ CK

    Comment

    Working...