connect sql server 200 and oracle 8i

• gladiator9

  Say Hey Kid

  Points: 690

  More actions

  August 22, 2002 at 9:23 am

  #64188

  I wish to connect the to in order to pull data from oracle on linux into sql server. How do I set up the connection, if poss explain ineaxact steps as I've batted with oledb for ages now. Thanks

• jgama

  Mr or Mrs. 500

  Points: 509

  More actions

  December 19, 2002 at 8:28 pm

  #444898

  You can create a linked server with sp_addlinkedserver

  sp_addlinkedserver [ @server = ] 'server'

  [ , [ @srvproduct = ] 'product_name' ]

  [ , [ @provider = ] 'provider_name' ]

  [ , [ @datasrc = ] 'data_source' ]

  [ , [ @location = ] 'location' ]

  [ , [ @provstr = ] 'provider_string' ]

  [ , [ @catalog = ] 'catalog' ]

  Or you can use OPENROWSET

  Syntax

  OPENROWSET ( 'provider_name'

  , { 'datasource' ; 'user_id' ; 'password'

  | 'provider_string' }

  , { [ catalog. ] [ schema. ] object

  | 'query' }

  )

  Please check out the online reference:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp