Connect to ORACLE

Hello,
I created an ODBC connection to an ORACLE database that works in MS Access.
Now I would like to use the connection to link the tables in SS2K. However,
I can't figure out how to use it in SS2K. Should I be using
"sp_addlinkedserver?"
Any help would be appreciated.
--
Thanks in advance,
StevenYes. sp_addlinkedserver and sp_addlinkedsrvlogin. SQL Server Books Online
has examples specific to setting up Oracle linked servers.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Steven K" <sckeels@.lucent.com> wrote in message
news:OM5MKoOmDHA.2732@.TK2MSFTNGP11.phx.gbl...
Hello,
I created an ODBC connection to an ORACLE database that works in MS Access.
Now I would like to use the connection to link the tables in SS2K. However,
I can't figure out how to use it in SS2K. Should I be using
"sp_addlinkedserver?"
Any help would be appreciated.
Thanks in advance,
Steven|||Just want to add that you also need to install the Oracle client software on
the SQL Server box. The linked server to Oracle works fine.
You do need to watch out for performance and avoid bringing unnecessary data
to SQL instance for processing. Try to get as much processing done as
possible on Oracle and bring back only the resultset for further processing
on the SQL instance.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:eYa6FqOmDHA.2416@.TK2MSFTNGP10.phx.gbl...
> Yes. sp_addlinkedserver and sp_addlinkedsrvlogin. SQL Server Books Online
> has examples specific to setting up Oracle linked servers.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> What hardware is your SQL Server running on?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Steven K" <sckeels@.lucent.com> wrote in message
> news:OM5MKoOmDHA.2732@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I created an ODBC connection to an ORACLE database that works in MS
Access.
> Now I would like to use the connection to link the tables in SS2K.
However,
> I can't figure out how to use it in SS2K. Should I be using
> "sp_addlinkedserver?"
> Any help would be appreciated.
>
> --
> Thanks in advance,
> Steven
>
>sqlsql