From: "Zelli, Brian" <Brian.Zelli@RoswellPark.org>
To: Oracle L <oracle-l@freelists.org>
Date: Wed, 9 Sep 2009 13:12:23 -0400
Subject: Oracle to SQL Server
Thread-Topic: Oracle to SQL Server
Message-ID: <6B3493ABEE194842A8EFC3FC3B23DE6A107C8F9027@MSXMBCCR2.roswellpark.org>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: multipart/alternative; boundary="_000_6B3493ABEE194842A8EFC3FC3B23DE6A107C8F9027MSXMBCCR2rosw_"
MIME-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: Brian.Zelli@RoswellPark.org
--_000_6B3493ABEE194842A8EFC3FC3B23DE6A107C8F9027MSXMBCCR2rosw_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello all,
   A manager just asked me to make a connection from oracle to sql server=
 and wants a view created from sql server data.  I've gone the other way =
but never from oracle to sql server.  I did a quick google and some thing=
s didn't seem clear.  Can anybody point me in the right direction?


ciao,
Brian


This email message may contain legally privileged and/or confidential inf=
ormation.  If you are not the intended recipient(s), or the employee or a=
gent responsible for the delivery of this message to the intended recipie=
nt(s), you are hereby notified that any disclosure, copying, distribution=
, or use of this email message is prohibited.  If you have received this =
message in error, please notify the sender immediately by e-mail and dele=
te this email message from your computer. Thank you.
--_000_6B3493ABEE194842A8EFC3FC3B23DE6A107C8F9027MSXMBCCR2rosw_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii"=
>
<META content=3D"MSHTML 6.00.6000.16890" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D834281017-09092009>Hello=20
all,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D834281017-09092009>&nbsp;&=
nbsp; A=20
manager just asked me to make a connection from oracle to sql server and =
wants a=20
view created from sql server data.&nbsp; I've gone the other way but neve=
r from=20
oracle to sql server.&nbsp; I did a quick google and some things didn't s=
eem=20
clear.&nbsp; Can anybody point me in the right direction?&nbsp;=20
</SPAN></FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV><?xml:namespace prefix =3D o ns =3D=20
"urn:schemas-microsoft-com:office:office" /><o:SmartTagType name=3D"City"=
=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype>
<STYLE>st1\:* {
=09BEHAVIOR: url(#ieooui)
}
</STYLE>

<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.2=
5in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: =
0; }
P.MsoNormal {
=09FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-fami=
ly: "Times New Roman"
}
LI.MsoNormal {
=09FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-fami=
ly: "Times New Roman"
}
DIV.MsoNormal {
=09FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-fami=
ly: "Times New Roman"
}
A:link {
=09COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
=09COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
=09COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
=09COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.GramE {
=09mso-style-name: ""; mso-gram-e: yes
}
DIV.Section1 {
=09page: Section1
}
</STYLE>

<DIV class=3DSection1>
<P class=3DMsoNormal align=3Dleft><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">ciao,</SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Brian</SPAN></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2></FONT>&nbsp;</P></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>


<BR>
This email message may contain legally privileged and/or confidential inf=
ormation.  If you are not the intended recipient(s), or the employee or a=
gent responsible for the delivery of this message to the intended recipie=
nt(s), you are hereby notified that any disclosure, copying, distribution=
, or use of this email message is prohibited.  If you have received this =
message in error, please notify the sender immediately by e-mail and dele=
te this email message from your computer. Thank you. =20


--_000_6B3493ABEE194842A8EFC3FC3B23DE6A107C8F9027MSXMBCCR2rosw_--
--
http://www.freelists.org/webpage/oracle-l