Results 1 to 3 of 3

Thread: Connecting to oracle through SQL server

  1. May 22nd, 2006, 02:49 AM #1
    davebat
    davebat is offline

    Thread Starter
    Fanatic Member davebat's Avatar
    Join Date
    Dec 2002
    Posts
    727

    Connecting to oracle through SQL server

    Does any one have any information on connecting to an oracle database through SQL Server please?
    Reply With Quote Reply With Quote
  2. May 22nd, 2006, 02:52 AM #2
    Shuja Ali
    Shuja Ali is offline
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: Connecting to oracle through SQL server

    In Query Analyzer you can use OpenDataSource(providername, connectionstring) to connect to other datasource like Oracle, Excel, Access etc.
    Use [code] source code here[/code] tags when you post source code.

    My Articles
    Reply With Quote Reply With Quote
  3. May 23rd, 2006, 07:43 AM #3
    MrNorth
    MrNorth is offline
    Frenzied Member
    Join Date
    May 2002
    Posts
    1,602

    Re: Connecting to oracle through SQL server

    Please use the "linked servers" feature. It requires an oracle client on your sql server machine.

    Please read about it in books online. And note that performance is not very good when working with this feature because every query ahs to be executed twice.... without going into details. Please keep that in mind.


    Kind regards
    Henrik
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width