Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006
    Posts
    1

    Unanswered: Integration of Oracle 10g with MSSQL

    Hi there all the database master,

    i have a doubt here that would like to have some advice from u all. Can i get data from Oracle 10g database if i have an application running on MS SQL ? If can, would it be cumbersome afterall? Please advice.

  2. #2
    Join Date
    Dec 2005
    Location
    Tilburg, Netherlands
    Posts
    73
    ... an application running on MS SQL Server ... ???

    Anyway, I get the picture. Yes you can create a connection to the Oracle database and then for instance create a linked server using that (ODBC for example) connection. You can query the data within the Oracle instance from within the ... application running on the MS SQL ...


    HTH

    Gr,
    Yveau

    > SELECT * FROM users WHERE clue > 0;
    Empty set (0.00 sec)


Posting Permissions

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