"Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
news:8BDE9696-5EB8-42D6-B271-25027D5B442C@microsoft.com...
> Hi,
>
> For the past few months I have been developing reports using SQL Server
> only, but just recently I was assigned to a new client who needs reports
> created using a Oracle database. I have never used Oracle before in any
> fashion, so I was wondering about connections to the Oracle database, how
the
> coding will differ, etc. My biggest concern is with the coding, I mostly
> have used stored procs to produce the reports, so I am wondering how this
> would change with a Oracle database, or if there would be any change at
all,
> will the be syntax changes, etc.
>
> Any info would be good right now.
>
> The client also asked me to research on how to connect Reporting Services
to
> the Oracle db, any ideas on this would be appreciated as well.
>
> Thanks
>

"Bruce L-C [MVP]" wrote:

> What version of Oracle? How you connect to Oracle is significantly
> different. Before even attempting Reporting Services you need to get the
> Oracle Client installed, configured and make sure you can use their tool to
> run a query. Depending on the version of Oracle will make a difference on
> the compatibility of the SQL. I used 8i, it was not SQL 92 compliant. I
> believe 10i is and I am not sure about 9i. As an example, 8i did not allow
> using the inner join syntax. So you would have to use the where clause to
> define the inner join. Outer joins would use some non-standard syntax.
>
> Another point, 8i did not autogenerate statistics. Not sure if 10i does or
> not, I know Oracle was going more and more that way to compete.
>
> Anyway, don't even touch Reporting Services until you have control of how to
> install, configure the Oracle client and make sure you can create stored
> procedures (packages in Oracle terminology). You do have to create the SP a
> particular way to use it but it is possible. I haven't done it but I have
> seen people posting who have.
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
> news:8BDE9696-5EB8-42D6-B271-25027D5B442C@microsoft.com...
> > Hi,
> >
> > For the past few months I have been developing reports using SQL Server
> > only, but just recently I was assigned to a new client who needs reports
> > created using a Oracle database. I have never used Oracle before in any
> > fashion, so I was wondering about connections to the Oracle database, how
> the
> > coding will differ, etc. My biggest concern is with the coding, I mostly
> > have used stored procs to produce the reports, so I am wondering how this
> > would change with a Oracle database, or if there would be any change at
> all,
> > will the be syntax changes, etc.
> >
> > Any info would be good right now.
> >
> > The client also asked me to research on how to connect Reporting Services
> to
> > the Oracle db, any ideas on this would be appreciated as well.
> >
> > Thanks
> >
>
>