RE: SQL2005b2 - linked servers

From: Mike Cohen (Cohen_at_discussions.microsoft.com)
Date: 09/25/04

  • Next message: D Barry: "Win Auth. - How do I prevent direct user access" 
    Date: Fri, 24 Sep 2004 15:41:03 -0700

    I'm having the same issue on my server.

    "Michel Ulens" wrote:

    > Hi,
    >
    > when connecting SQL 2005b2 (on W2003server) to an Oracle instance I
    > consistently get following error message.
    >
    > select ename from ORCL..SCOTT.EMP
    > >>Results in
    > Msg 7421, Level 16, State 2, Line 1
    > Could not fetch rowset from OLE/DB provider 'OraOLEDB.Oracle' for linked
    > server 'ORCL'. .
    >
    > when executing a wrong query, I get following reply, proving that the link
    > is actualy working:
    >
    > select enames from ORCL..SCOTT.EMP
    > >>Results in
    > Msg 207, Level 16, State 1, Line 1
    > Invalid column name 'enames'.
    >
    > Any suggestions ?? Wait for the RTM release ?
    >
    > Michel

  • Next message: D Barry: "Win Auth. - How do I prevent direct user access"