Oracle /MS-SQL Linked Server - OLE/DB provider returned message: ORA-12154

From: Jon Spartan <jonu_at_ixtech.net>
Date: Sun, 28 Jul 2002 13:36:53 GMT
Message-ID: <t0t7kugnmm7oaeg6uo9022mm1th0lf5cfu@4ax.com>

Can anyone help me solve the error below that I am receiving back from an Oracle server I am linked to ???

My thanks in advance !

Jon Spartan

TEST CASE - - - - SELECT CALLDETAILRECORDID, GROUPID, BRANDID, USERID,

       ACCOUNTID, BRANDPRODUCTID, TIME, ANI, DNIS,
       DESCRIPTION, ORIGINATINGHOST, TERMINATINGHOST,
       DURATION, CHARGEABLEDURATION, DESTINATION,
       FAXPAGES, FAXBYTES, BRANDCHARGEABLEDURATION,
       DIALSTRING, ROAMINGCHARGE, CALLCHARGE,
       GROUPCALLCHARGE, BRANDCALLCHARGE, GROUPNAME,
       BRANDNAME, USERNAME, CARRIERID, CARRIERNAME,
       GROUPSERVICEID, GROUPPRODUCTID, GROUPPROFIT,
       BRANDPROFIT, INITIALBRANDBASERATE, INITIALGROUPBASERATE,
       SESSIONID, ACCOUNTTYPE, ACCOUNTBATCHNUMBER,
       GROUPEXCHANGECODE, BRANDEXCHANGECODE,
       ORIGINATINGHOSTID, TERMINATINGHOSTID,
       TERMINATINGGROUPID, TERMINATINGGROUPNAME,
       GROUPSERVICENAME, BRANDSERVICENAME,
       ERRORCODE, BRANDSERVICEID, BILLINGRECORDID

FROM RTBE..RTBETELEPHONY.RTBETELCALLDETAILRECORDS Received on Sun Jul 28 2002 - 08:36:53 CDT