Link from SQL server to oracle

Hi
What is the best and most robust/recommended way to link SQL server 2000
to oracle 9i DB?
We are planning to send daily load across the link and do not want it
to fail.
Tks
Mangesh
I used linked servers for that. Worked very well.
HTH, Jens Suessmeyer.
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> schrieb im
Newsbeitrag news:2C3C1647-C94B-4C4A-BC85-389058124638@.microsoft.com...
> Hi
> What is the best and most robust/recommended way to link SQL server 2000
> to oracle 9i DB?
> We are planning to send daily load across the link and do not want it
> to fail.
> Tks
> Mangesh

Link from SQL server to oracle

Hi
What is the best and most robust/recommended way to link SQL server 2000
to oracle 9i DB?
We are planning to send daily load across the link and do not want it
to fail.
Tks
MangeshI used linked servers for that. Worked very well.
HTH, Jens Suessmeyer.
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> schrieb im
Newsbeitrag news:2C3C1647-C94B-4C4A-BC85-389058124638@.microsoft.com...
> Hi
> What is the best and most robust/recommended way to link SQL server 2000
> to oracle 9i DB?
> We are planning to send daily load across the link and do not want it
> to fail.
> Tks
> Mangesh

Link from SQL server to oracle

Hi
What is the best and most robust/recommended way to link SQL server 2000
to oracle 9i DB?
We are planning to send daily load across the link and do not want it
to fail.
Tks
MangeshI used linked servers for that. Worked very well.
HTH, Jens Suessmeyer.
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> schrieb im
Newsbeitrag news:2C3C1647-C94B-4C4A-BC85-389058124638@.microsoft.com...
> Hi
> What is the best and most robust/recommended way to link SQL server 2000
> to oracle 9i DB?
> We are planning to send daily load across the link and do not want it
> to fail.
> Tks
> Mangesh

Limit to number of databases in Analysis Services 2005

We are trying to run a load test on analysis services 2005. We were
going to start with 30 different databases out there and see what the
processing loads were. Analysis Services is stopping us at 25
databases and telling us that there is no more room. We have 260 GB
free on the server. Has anyone run into this before? Is there a limit
to the number of databases you can have? Does it vary by SQL edition?http://msdn2.microsoft.com/en-us/library/ms365363.aspx
<rbergstrom@.spectrumhr.com> wrote in message
news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...
> We are trying to run a load test on analysis services 2005. We were
> going to start with 30 different databases out there and see what the
> processing loads were. Analysis Services is stopping us at 25
> databases and telling us that there is no more room. We have 260 GB
> free on the server. Has anyone run into this before? Is there a limit
> to the number of databases you can have? Does it vary by SQL edition?
>|||Thanks for that link. Now I will ask a dumb question. in the page on
that link it shows Maximum sizes/numbers. The value for Databases in
an instance is 2^31-1 = 2,147,483,647. Is that a total size in bytes?
The number of databases? I don't understand what that is supposed to
represent. Thanks for your help.
Immy wrote:
> http://msdn2.microsoft.com/en-us/library/ms365363.aspx
> <rbergstrom@.spectrumhr.com> wrote in message
> news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...
> > We are trying to run a load test on analysis services 2005. We were
> > going to start with 30 different databases out there and see what the
> > processing loads were. Analysis Services is stopping us at 25
> > databases and telling us that there is no more room. We have 260 GB
> > free on the server. Has anyone run into this before? Is there a limit
> > to the number of databases you can have? Does it vary by SQL edition?
> >

Limit to number of databases in Analysis Services 2005

We are trying to run a load test on analysis services 2005. We were
going to start with 30 different databases out there and see what the
processing loads were. Analysis Services is stopping us at 25
databases and telling us that there is no more room. We have 260 GB
free on the server. Has anyone run into this before? Is there a limit
to the number of databases you can have? Does it vary by SQL edition?http://msdn2.microsoft.com/en-us/library/ms365363.aspx
<rbergstrom@.spectrumhr.com> wrote in message
news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...
> We are trying to run a load test on analysis services 2005. We were
> going to start with 30 different databases out there and see what the
> processing loads were. Analysis Services is stopping us at 25
> databases and telling us that there is no more room. We have 260 GB
> free on the server. Has anyone run into this before? Is there a limit
> to the number of databases you can have? Does it vary by SQL edition?
>|||Thanks for that link. Now I will ask a dumb question. in the page on
that link it shows Maximum sizes/numbers. The value for Databases in
an instance is 2^31-1 = 2,147,483,647. Is that a total size in bytes?
The number of databases? I don't understand what that is supposed to
represent. Thanks for your help.
Immy wrote:[vbcol=seagreen]
> http://msdn2.microsoft.com/en-us/library/ms365363.aspx
> <rbergstrom@.spectrumhr.com> wrote in message
> news:1154470182.648978.116860@.75g2000cwc.googlegroups.com...