Access Oracle data from a SQL-Server database

[MikeLacey]

Is there a way to access Oracle Data from a SQL-Server database - in the same sort of way that you can have remote databases in Oracle?<br>
<br>
-ml<br>
<p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[calahans]

Hi Mike,<br>
<br>
I don't think that you can access an Oracle DB directly from SS, there are no link table features (that I'm aware of!). I think that you may have to use a third party tool.<br>
<br>
Unfortunately I don;t have a copy of SS at the moment :-(<br>
<br>
Cal

 

[MikeLacey]

Hi Cal,<br>
<br>
Does anyone know of a third party tool then?<br>
<br>
Mike<br>
<p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[farman]

I believe that it cannot be done this way. However, you can use a third-party software to convert and transmit your current database from one DBMS to another. farman

 

[MikeLacey]

Similar thread in Oracle: Oracle 5/6/7 which suggests a popular solution<br>
<br>
-ml<br>
<p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>