Link to Oracle 9.2.0

Hello!
Please, help me to link MS SQL Server 2000 Ent. edition sp3a to Oracle
9.2.0.
Thank you in advance.
IgorHi
If you are requiring to use the oracle database as a linked server then
check out sp_addlinkedserver in books online:
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_sp_adda_8gqa.htm
This may also help regarding what the equivalences are:
http://www.microsoft.com/technet/tr...part2/c0761.asp
http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
John
"Igor" <vorgi@.hotmail.com> wrote in message
news:OAr9rqT$DHA.4060@.TK2MSFTNGP10.phx.gbl...
> Hello!
> Please, help me to link MS SQL Server 2000 Ent. edition sp3a to Oracle
> 9.2.0.
>
> Thank you in advance.
>
> Igor
>|||Please, give me an example...
Oracle Server Name: Server1.domain1.com
Oracle DB Name: TestDB1
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:nwI%b.3570$lB2.31267975@.news-text.cableinet.net...
> Hi
> If you are requiring to use the oracle database as a linked server then
> check out sp_addlinkedserver in books online:
>
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq[col
or=darkred]
> lref.chm::/ts_sp_adda_8gqa.htm
> This may also help regarding what the equivalences are:
>[/color]
http://www.microsoft.com/technet/tr...part2/c0761.asp
> http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
> John
> "Igor" <vorgi@.hotmail.com> wrote in message
> news:OAr9rqT$DHA.4060@.TK2MSFTNGP10.phx.gbl...
>|||There is an example in books online under the sp_addlinkeserver subject, you
will need the SQL*Net alias.
John
"Igor" <vorgi@.hotmail.com> wrote in message
news:%2351dKXU$DHA.2804@.tk2msftngp13.phx.gbl...
> Please, give me an example...
> Oracle Server Name: Server1.domain1.com
> Oracle DB Name: TestDB1
>
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:nwI%b.3570$lB2.31267975@.news-text.cableinet.net...
>
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq[col
or=darkred]
>[/color]
http://www.microsoft.com/technet/tr...part2/c0761.asp
>|||Very good. What's the SQL*Net alias? Give me an example, please...
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eRM%b.3784$DY4.33338563@.news-text.cableinet.net...
> There is an example in books online under the sp_addlinkeserver subject,
you
> will need the SQL*Net alias.
> John
> "Igor" <vorgi@.hotmail.com> wrote in message
> news:%2351dKXU$DHA.2804@.tk2msftngp13.phx.gbl...
then
>
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq[col
or=darkred]
>
http://www.microsoft.com/technet/tr...part2/c0761.asp
Oracle
>|||Hi
The SQL*Net alias is whatever you set the alias to be when configuring
SQL*Net!! It will appear in the SQL*Net configuration file or you can
use the Network Configuration Utitity to view/set it.
John
"Igor" <vorgi@.hotmail.com> wrote in message news:<#a6wWj1$DHA.2072@.TK2MSFTNGP11.phx.gbl>...
> Very good. What's the SQL*Net alias? Give me an example, please...
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:eRM%b.3784$DY4.33338563@.news-text.cableinet.net...
> you
> then
> mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\
tsq
> http://www.microsoft.com/technet/tr...part2/c0761.asp
> Oracle|||Thanks to all!
The problem was that the Oracle TNS Service was not configured properly. So,
admin of Oracle works now...
Good luck!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3b81e6a.0403010515.25844e1b@.posting.google.com...
> Hi
> The SQL*Net alias is whatever you set the alias to be when configuring
> SQL*Net!! It will appear in the SQL*Net configuration file or you can
> use the Network Configuration Utitity to view/set it.
> John
> "Igor" <vorgi@.hotmail.com> wrote in message
news:<#a6wWj1$DHA.2072@.TK2MSFTNGP11.phx.gbl>...
subject,
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\tsq[col
or=darkred]
http://www.microsoft.com/technet/tr...part2/c0761.asp
http://vyaskn.tripod.com/ oracle_sq...ent
s.htmsql