oracle driver

Where can I download the Oracle driver for SQL Server Reporting Server? The
Oracle Client is 500MB, wasn't sure if there's something smaller for just the
driver. Thanks!I don't think there is a smaller download for the Oracle client. Make sure
you are installing version 8.1.7 or later of the Oracle client.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Teresa" <Teresa@.discussions.microsoft.com> wrote in message
news:FB197F40-D82C-4093-8F5F-73291E74C0C9@.microsoft.com...
> Where can I download the Oracle driver for SQL Server Reporting Server?
> The
> Oracle Client is 500MB, wasn't sure if there's something smaller for just
> the
> driver. Thanks!|||Hi Robert,
Thanks! You seem very knowledgable with Rpt Svcs. I saw your posts in many
places. I'm running into a more critical issue with executing Oracle reports.
I kept getting the "rsErrorOpeningConnection with Oracle" when running from
the server and I know I can make the db connection from the server. And I
also double check the permission in the Oracle folder per one of your
posting. Could you think of anything else I can try?
Thank you very much!
"Robert Bruckner [MSFT]" wrote:
> I don't think there is a smaller download for the Oracle client. Make sure
> you are installing version 8.1.7 or later of the Oracle client.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Teresa" <Teresa@.discussions.microsoft.com> wrote in message
> news:FB197F40-D82C-4093-8F5F-73291E74C0C9@.microsoft.com...
> > Where can I download the Oracle driver for SQL Server Reporting Server?
> > The
> > Oracle Client is 500MB, wasn't sure if there's something smaller for just
> > the
> > driver. Thanks!
>
>|||My first suggestion is to make sure that you have rebooted your server once
after the Oracle client installation happened (I have seen some machines
where applications running inside ASP.NET, such as report server, cannot
access the Oracle client without a reboot after the client installation).
Then, if this is RS 2005, you have to apply the following steps:
* make sure the WebServiceIdentity is configured through the RS
Configuration tool; often it is set to the Network Service user. You can
also check it by looking up the <WebServiceAccount> element in the
RSReportServer.config file.
* For the specified <WebServiceAccount> apply these steps on the Oracle
client installation directory (Oracle\Oracle version):
Right-click the directory, and then Properties. On the security tab, add the
<WebServiceAccount> and grant read&execute permission. Important: click on
the advanced button and select "Allow inheritable permissions from the
parent ..." before you click OK!
Note: it is also necessary to grant the account read&execute permissions
that is used to execute the RS Windows Service. For RS 2005, both the RS
Windows Service account and the configured RS Web Service account must have
permissions to access the files of the Oracle client installation in the
file system! On RS 2000, this was generally only needed for the RS Windows
Service account.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
PS: I guess I should know a few things about RS since I'm
designing/implementing some areas of the product :)
"Teresa" <Teresa@.discussions.microsoft.com> wrote in message
news:6BF6E4C3-B612-454D-99A7-DDFF431A04D2@.microsoft.com...
> Hi Robert,
> Thanks! You seem very knowledgable with Rpt Svcs. I saw your posts in many
> places. I'm running into a more critical issue with executing Oracle
> reports.
> I kept getting the "rsErrorOpeningConnection with Oracle" when running
> from
> the server and I know I can make the db connection from the server. And I
> also double check the permission in the Oracle folder per one of your
> posting. Could you think of anything else I can try?
> Thank you very much!
> "Robert Bruckner [MSFT]" wrote:
>> I don't think there is a smaller download for the Oracle client. Make
>> sure
>> you are installing version 8.1.7 or later of the Oracle client.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Teresa" <Teresa@.discussions.microsoft.com> wrote in message
>> news:FB197F40-D82C-4093-8F5F-73291E74C0C9@.microsoft.com...
>> > Where can I download the Oracle driver for SQL Server Reporting Server?
>> > The
>> > Oracle Client is 500MB, wasn't sure if there's something smaller for
>> > just
>> > the
>> > driver. Thanks!
>>