• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

Retrieve data from Oracle database

Hi, how can i retrieve data from Oracle database to SQL Server 7? I thought
using DTS, how can i use it? Do i need to install oracle something to make
TDS work. I have small ideal of the Oracle Databse, Can anyone help me out?
Thanks
0
shyline777
Asked:
shyline777
  • 4
  • 4
1 Solution
 
Kevin3NFCommented:
Use DTS.  Select the Oracle driver from the drop down list in the "Source" screen of the DTS wizard.  Assuming you have the proper permissions on the Oracle side, it should be pretty simple to get started.

Alternatively, look up Linked Servers in Books Online and you can select directly from the Oracle tables.
0
 
shyline777Author Commented:
Which driver should choose? OLEDB driver for oracle , or ODBC driver for Oracle. Thanks
0
 
Kevin3NFCommented:
I would think OLEDB driver for Oracle, but since I have never needed to grab Oracle data, I can't say for sure.  Try both, see which performs better...
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
leonstrykerCommented:
To connect to an Oracle database you will need Oracle client on your machine.  You should use either Oracle of M$ OLEDB driver.
0
 
Kevin3NFCommented:
Ah yes...I recall now that you do need that (thanks leonstryker).  Microsoft hasn't made any improvements to their own Oracle driver since Oracle 7x or 8x.  If you are newer than that, you might never get to the data.  Use Oracle's driver by installing the client
0
 
leonstrykerCommented:
Yeah, I donot remeber teh exact limitations, but there are somethings that Oracle driver allowed you do that the M$ driver did not.  So definently stick to Oracle OLEDB driver if you can.
0
 
Kevin3NFCommented:
A split between me and leonstryker would be more accurate...he had a key piece of information I neglected to mention :-)
0
 
leonstrykerCommented:
Thank you Kevin3NF.
0
 
leonstrykerCommented:
no problem modulo, its the though that counted
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now