Sqlserver and database link
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Sqlserver and database link

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Posts
    141

    Sqlserver and database link

    Hi all !

    We have an application under SQLServer 2000 which retrieve datas from a view under an Oracle database release 8.1.7.
    It works fine until we changed the view to add a link to another Oracle database with a database link.

    Example :
    1)
    From SQLServer :
    select * from oracle_view;

    view oracle_view :
    select * from table_in_oracle;

    --> that works fine !

    2)
    From SQLServer :
    select * from oracle_view;

    view oracle_view :
    select * from table_in_oracle
    union
    select * from table_in_oracle@dblink_to_other_oracle_db;

    --> that's not work ...

    Taht anyone has encoutered this problem ?

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Hows the conectivity from MS SQL Server to Oracle DB?

    Make such conectivity from MS SQL Server to that remote DB ( DB Link ).

    Do you use MS provided ODBC for CONN?

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    When the view without DB link was working fine.Why did u change it to use DB link.

    Regards
    anandkl
    anandkl

  4. #4
    Join Date
    Dec 2001
    Posts
    141
    Originally posted by abhaysk
    Hows the conectivity from MS SQL Server to Oracle DB?

    Make such conectivity from MS SQL Server to that remote DB ( DB Link ).

    Do you use MS provided ODBC for CONN?

    Abhay.
    Good idea !
    It doesn't work with Oracle ODBC driver but it's ok with MS ODBC driver !

    It seems to be a bug ([BUG:914652]GETTING ORA-2041 CONNECTING THROUGH ODBC TO DB_LINK --> from Metalink).

    I will use MS ODBC driver

    Thanks a lot !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width