Querying Oracle from SQL Server RRS feed

  • Question

  • Hi,

    Is it possible to create a stored proc which will query a Oracle database?  How would I connect to Oracle from SQL Server?

    Saturday, November 15, 2008 9:44 AM


  • Yes, it is possible to connect to Oracle from Sql Server via two methods:
    1) Create a linked server, for the connection string we need to get from a temp UDL to select the Oracle driver and Server details to connect to)

    2) The other way is to use the resulting connection string in OPENROWSET function to return the resultset or a scalar value.
      for help regarding OPENROWSET read here

    Subhash Subramanyam
    Saturday, November 15, 2008 10:36 AM