Home > Archive > MS SQL Server > October 2006 > SQL Server 2005 Linked server to Oracle - Msg 8117









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQL Server 2005 Linked server to Oracle - Msg 8117
Olof

2006-10-24, 6:28 pm

Hi!

I get 'Operand data type nvarchar is invalid for sum operator.' (msg 8117)
when I tries to fetch a sum of a column(data type NUMBER) from Oracle.

I've used provider - Microsoft OLE DB Provider for Oracle.

Any ideas?

Regards
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com