DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle & SQL-Server

  1. 10-16-2002, 05:18 PM #1
    The War
    The War is offline Junior Member
    Join Date
    Oct 2002
    Posts
    4
    when i have a database in oracle and i need to receive some data from columns in SQL-Server Database ..How i can do that ???
    where my oracel Server in a seprate Server and the SQL-Server the same thing
    Reply With Quote Reply With Quote
  2. 10-16-2002, 05:37 PM #2
    mike2000
    mike2000 is offline Senior Member
    Join Date
    Sep 2002
    Posts
    411
    convert the table from SQL to Oracle first and then write a short scripts to manupulate data from the column to whichever the table.

    Reply With Quote Reply With Quote
  3. 10-17-2002, 02:08 AM #3
    ales
    ales is offline Advisor
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    If the Oracle server runs on Windoze, you could use the Generic Connectivity feature.

    It makes possible to create dblink to heterogenous DB via ODBC or OLE DB.
    It's part of 8.1.6 and up, I think.

    See Metalink Note 114820.1

    [Edited by ales on 10-17-2002 at 03:19 AM]
    Ales
    The whole difference between a little boy and an adult man is the price of toys
    Reply With Quote Reply With Quote
  4. 10-17-2002, 08:58 AM #4
    chrisrlong's Avatar
    chrisrlong
    chrisrlong is offline
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Originally posted by ales
    If the Oracle server runs on Windoze, you could use the Generic Connectivity feature.
    According to the esteemed Mr. Hunter and others, it supposedly does not matter where the Oracle instance resides in order to use either GC or TGs.

    http://www.dbasupport.com/forums/sho...threadid=29773

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong
    Reply With Quote Reply With Quote
  5. 10-17-2002, 03:34 PM #5
    jrpm
    jrpm is offline Senior Member
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    You did not say which version of Oracle. If it is an older one without the ODBC connectivity, you can drive the link from the SQL Server side using Linked Servers, with a T/SQL proc pushing the data to Oracle, rather than having Oracle pulling the data.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'
    Reply With Quote Reply With Quote
  6. 10-22-2002, 04:26 AM #6
    ales
    ales is offline Advisor
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Originally posted by chrisrlong
    Originally posted by ales
    If the Oracle server runs on Windoze, you could use the Generic Connectivity feature.
    According to the esteemed Mr. Hunter and others, it supposedly does not matter where the Oracle instance resides in order to use either GC or TGs.
    Yes, that's true.
    As we all know, TG is a piece of software for the remote DB, thus platform of Oracle instance is irrelevant. Regarding TG.

    GC is different, it's not as mighty as TG and needs ODBC or OLE DB on the box where Oracle runs. In my experience, setup GC on Windoze is very easy. I did it in order to connect into DB2 via ODBC and it worked well.

    Setting up ODBC on a UNIX machine is not so easy and from this point of view the platform matters.
    If anybody knows how to setup DB2 v.6 ODBC on AIX 4.3.3 or can post a link here I'd really appreciate his/her help.
    Thanks!
    Ales
    The whole difference between a little boy and an adult man is the price of toys
    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