.net Data Provider (YOU can help)

I don't get a Data Provider to access my oracle database.
Can somebody send me his Data Provider?
If you have a Provider accessing the SQL-Server you can send also this
Provider.
E-Mail: Data.Prov@.Freenet.de
I'm a novice in Report Services and Data Provider and search for days now
for a solution. All I find doesn't help, I guess something simple and very
basic is missing.
Please help!You will need Reporting Services SP1 installed.
How to use Oracle in RS:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y uses
OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e .NET
provider for Oracle, which indeed allows for named parameters.
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> I don't get a Data Provider to access my oracle database.
> Can somebody send me his Data Provider?
> If you have a Provider accessing the SQL-Server you can send also this
> Provider.
> E-Mail: Data.Prov@.Freenet.de
> I'm a novice in Report Services and Data Provider and search for days now
> for a solution. All I find doesn't help, I guess something simple and very
> basic is missing.
> Please help!|||I have SP1 installed and I still create reports with the oracle database. I'm
using in depth stored procedures for this reports, the SPs encapsulate comlex
applications.
I'm programming with VB since 10 years, so I have some general knowledge.
But I'm a novice in reporting services and .Net Data Providers. I wrote
application using ADO .net, so I have a basic understanding of ADO.Net.
But it is absolut impossible for me to get this Data Provider for reporting
services running. I'm realy annoyed about the documentation and the news
group posts about this. There is a huge amount of descriptions like
"implement interface A, B, C ..." instate of publishing somewhere a usefull
sample application.
The FSI... Sample is a joke. How many people will list files from the
filesystem in a report and how many will access a real database to create
reports? This are all "doghouse" samples. For a doghouse you need a hammer
and some nails but for a real building used by people there is something more
required.
"Alexandre Mineev [MSFT]" wrote:
> You will need Reporting Services SP1 installed.
> How to use Oracle in RS:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y uses
> OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e .NET
> provider for Oracle, which indeed allows for named parameters.
>
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> > I don't get a Data Provider to access my oracle database.
> >
> > Can somebody send me his Data Provider?
> > If you have a Provider accessing the SQL-Server you can send also this
> > Provider.
> > E-Mail: Data.Prov@.Freenet.de
> >
> > I'm a novice in Report Services and Data Provider and search for days now
> > for a solution. All I find doesn't help, I guess something simple and very
> > basic is missing.
> >
> > Please help!
>
>|||No answer is a answer too!
"Dev Main" wrote:
> I have SP1 installed and I still create reports with the oracle database. I'm
> using in depth stored procedures for this reports, the SPs encapsulate comlex
> applications.
> I'm programming with VB since 10 years, so I have some general knowledge.
> But I'm a novice in reporting services and .Net Data Providers. I wrote
> application using ADO .net, so I have a basic understanding of ADO.Net.
> But it is absolut impossible for me to get this Data Provider for reporting
> services running. I'm realy annoyed about the documentation and the news
> group posts about this. There is a huge amount of descriptions like
> "implement interface A, B, C ..." instate of publishing somewhere a usefull
> sample application.
> The FSI... Sample is a joke. How many people will list files from the
> filesystem in a report and how many will access a real database to create
> reports? This are all "doghouse" samples. For a doghouse you need a hammer
> and some nails but for a real building used by people there is something more
> required.
> "Alexandre Mineev [MSFT]" wrote:
> > You will need Reporting Services SP1 installed.
> >
> > How to use Oracle in RS:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> >
> > Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y uses
> > OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e .NET
> > provider for Oracle, which indeed allows for named parameters.
> >
> >
> > --
> > Alex Mineev
> > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > SQE.
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights
> >
> > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> > > I don't get a Data Provider to access my oracle database.
> > >
> > > Can somebody send me his Data Provider?
> > > If you have a Provider accessing the SQL-Server you can send also this
> > > Provider.
> > > E-Mail: Data.Prov@.Freenet.de
> > >
> > > I'm a novice in Report Services and Data Provider and search for days now
> > > for a solution. All I find doesn't help, I guess something simple and very
> > > basic is missing.
> > >
> > > Please help!
> >
> >
> >|||Two things. Unless it is a managed newsgroup posting you are not guaranteed
a MS response. This is peer response with MS people jumping in from time to
time.
Second, are you trying to create your own data processing extension or is
the issue that you are having trouble using stored procedures in Oracle?
First you asked for people to send you a data provider for SQL Server or
Oracle which I didn't answer because it didn't make sense to me. If the
issue is using Oracle people are successfully using Oracle. What
specifically is your problem using Oracle with Reporting Services?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:64B97405-AECC-45DA-8A93-551BBAE82FA2@.microsoft.com...
> No answer is a answer too!
> "Dev Main" wrote:
> > I have SP1 installed and I still create reports with the oracle
database. I'm
> > using in depth stored procedures for this reports, the SPs encapsulate
comlex
> > applications.
> >
> > I'm programming with VB since 10 years, so I have some general
knowledge.
> >
> > But I'm a novice in reporting services and .Net Data Providers. I wrote
> > application using ADO .net, so I have a basic understanding of ADO.Net.
> >
> > But it is absolut impossible for me to get this Data Provider for
reporting
> > services running. I'm realy annoyed about the documentation and the news
> > group posts about this. There is a huge amount of descriptions like
> > "implement interface A, B, C ..." instate of publishing somewhere a
usefull
> > sample application.
> >
> > The FSI... Sample is a joke. How many people will list files from the
> > filesystem in a report and how many will access a real database to
create
> > reports? This are all "doghouse" samples. For a doghouse you need a
hammer
> > and some nails but for a real building used by people there is something
more
> > required.
> >
> > "Alexandre Mineev [MSFT]" wrote:
> >
> > > You will need Reporting Services SP1 installed.
> > >
> > > How to use Oracle in RS:
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> > >
> > > Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y
uses
> > > OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e
.NET
> > > provider for Oracle, which indeed allows for named parameters.
> > >
> > >
> > > --
> > > Alex Mineev
> > > Software Design Engineer. Report expressions; Code Access Security;
Xml;
> > > SQE.
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
rights
> > >
> > > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > > news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> > > > I don't get a Data Provider to access my oracle database.
> > > >
> > > > Can somebody send me his Data Provider?
> > > > If you have a Provider accessing the SQL-Server you can send also
this
> > > > Provider.
> > > > E-Mail: Data.Prov@.Freenet.de
> > > >
> > > > I'm a novice in Report Services and Data Provider and search for
days now
> > > > for a solution. All I find doesn't help, I guess something simple
and very
> > > > basic is missing.
> > > >
> > > > Please help!
> > >
> > >
> > >|||Make you use RS SP1.
How to use Oracle in RS:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
Note: The Visual Data Tools (VDT) query designer (2 panes) actuall­y uses
OLE DB. The text-based generic query designer (GQD; 4 panes) uses th­e .NET
provider for Oracle, which indeed allows for named parameters.
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:4F451D47-B161-49C1-95ED-A6E5428E7ACB@.microsoft.com...
> I don't get a Data Provider to access my oracle database.
> Can somebody send me his Data Provider?
> If you have a Provider accessing the SQL-Server you can send also this
> Provider.
> E-Mail: Data.Prov@.Freenet.de
> I'm a novice in Report Services and Data Provider and search for days now
> for a solution. All I find doesn't help, I guess something simple and very
> basic is missing.
> Please help!|||@.Bruce: Thank you for the answer and sory for my last comment.
I don't have problems with oracle. I build reports using oracle data. I have
no problem with stored procedures, packages and everything else. Everything
works.
I'm unable to get a data provider for RS running and access the oracle
database. I'm familare with VB, with VB.net, ADO.net, Databases, Stored
Procedures etc. But it seems I don't know the right syntax to use in this
dataprovider. I like to complete the FSI... Example that it fullfills my
requirements. I read all documentation and spend many hours on it.
If I would implement a application using ado.net I would create a object for
the connection and refer to them. This seems to be not the right aproach in
this Data Provider. All the Implement interface blabla doesn't help me,
becouse I simply don't know how to do this exactly.
A simple real sample would save the hundrets of hours I'm waste on this.
The reason why I like to implement the data provider is, that im must
execute several stored procedures and return the result from a temporary
table. I can't use the stored procedure to query the result, becouse Oracle
(7.3) requires that I specify the amount of expected records, before I'm send
this stored procedure. If the dataprovider is running, I like to change them
in a way, that I can do something else before I execute the query. Returning
a dataset with a stored procedure from oracle (even if I know the expected
amount of returned records) is not efficient and results in bad performance.
Inside the dataprovider I like to create datasets and return them to
Reporting Services.
Thanks in advance!
"Dev Main" wrote:
> I don't get a Data Provider to access my oracle database.
> Can somebody send me his Data Provider?
> If you have a Provider accessing the SQL-Server you can send also this
> Provider.
> E-Mail: Data.Prov@.Freenet.de
> I'm a novice in Report Services and Data Provider and search for days now
> for a solution. All I find doesn't help, I guess something simple and very
> basic is missing.
> Please help!|||Ouch, 7.3. Everyone I have seen use Oracle has been on at least 8i.
One possible solution for you would be to use the controls coming out with
the next beta of Yukon and Widbey. These will work the way you are
expecting. It depends on when you have to go into production. There might be
a go live license for the next beta of Widbey but I don't know if that
includes the new controls or not. These new controls are really going to be
a help.
Although similar what it sounds like you are wanting to do is to create a
data processing extension. I suggest posting asking if anyone has additional
examples of data processing extensions (which is different from have a data
provider, similar but different).
I have two books which I suggest buying that between the two of them would
really get you going writing your own data processing extension: Microsoft
Reporting Services In Action by Teo Lachev (an MVP) and Hitchhiker's Guide
to SQL Server 2000 Reporting Services by Peter Blackburn and Willam Vaughn.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:AE9B3520-233F-4D6D-8EBC-746A29D68FF3@.microsoft.com...
> @.Bruce: Thank you for the answer and sory for my last comment.
> I don't have problems with oracle. I build reports using oracle data. I
have
> no problem with stored procedures, packages and everything else.
Everything
> works.
> I'm unable to get a data provider for RS running and access the oracle
> database. I'm familare with VB, with VB.net, ADO.net, Databases, Stored
> Procedures etc. But it seems I don't know the right syntax to use in this
> dataprovider. I like to complete the FSI... Example that it fullfills my
> requirements. I read all documentation and spend many hours on it.
> If I would implement a application using ado.net I would create a object
for
> the connection and refer to them. This seems to be not the right aproach
in
> this Data Provider. All the Implement interface blabla doesn't help me,
> becouse I simply don't know how to do this exactly.
> A simple real sample would save the hundrets of hours I'm waste on this.
> The reason why I like to implement the data provider is, that im must
> execute several stored procedures and return the result from a temporary
> table. I can't use the stored procedure to query the result, becouse
Oracle
> (7.3) requires that I specify the amount of expected records, before I'm
send
> this stored procedure. If the dataprovider is running, I like to change
them
> in a way, that I can do something else before I execute the query.
Returning
> a dataset with a stored procedure from oracle (even if I know the expected
> amount of returned records) is not efficient and results in bad
performance.
> Inside the dataprovider I like to create datasets and return them to
> Reporting Services.
> Thanks in advance!
> "Dev Main" wrote:
> > I don't get a Data Provider to access my oracle database.
> >
> > Can somebody send me his Data Provider?
> > If you have a Provider accessing the SQL-Server you can send also this
> > Provider.
> > E-Mail: Data.Prov@.Freenet.de
> >
> > I'm a novice in Report Services and Data Provider and search for days
now
> > for a solution. All I find doesn't help, I guess something simple and
very
> > basic is missing.
> >
> > Please help!|||Thank you!
I will order the recomended books today.
I have to go productive with one single report in 2 weeks.
The oracle version is in the scope from the customer and I have no influence
on it. It seems I'm living in a different world then other developers. My
customers are in most cases not uptodate. Wether with OS nor with Databases,
Exchange, Office etc. They say: "why should we change a running system, new
version new troubles". And if I see the ripeness of Reporting Services or the
ESH (Exchange Server Hell), I can understand them.
"Bruce L-C [MVP]" wrote:
> Ouch, 7.3. Everyone I have seen use Oracle has been on at least 8i.
> One possible solution for you would be to use the controls coming out with
> the next beta of Yukon and Widbey. These will work the way you are
> expecting. It depends on when you have to go into production. There might be
> a go live license for the next beta of Widbey but I don't know if that
> includes the new controls or not. These new controls are really going to be
> a help.
> Although similar what it sounds like you are wanting to do is to create a
> data processing extension. I suggest posting asking if anyone has additional
> examples of data processing extensions (which is different from have a data
> provider, similar but different).
> I have two books which I suggest buying that between the two of them would
> really get you going writing your own data processing extension: Microsoft
> Reporting Services In Action by Teo Lachev (an MVP) and Hitchhiker's Guide
> to SQL Server 2000 Reporting Services by Peter Blackburn and Willam Vaughn.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:AE9B3520-233F-4D6D-8EBC-746A29D68FF3@.microsoft.com...
> > @.Bruce: Thank you for the answer and sory for my last comment.
> >
> > I don't have problems with oracle. I build reports using oracle data. I
> have
> > no problem with stored procedures, packages and everything else.
> Everything
> > works.
> >
> > I'm unable to get a data provider for RS running and access the oracle
> > database. I'm familare with VB, with VB.net, ADO.net, Databases, Stored
> > Procedures etc. But it seems I don't know the right syntax to use in this
> > dataprovider. I like to complete the FSI... Example that it fullfills my
> > requirements. I read all documentation and spend many hours on it.
> >
> > If I would implement a application using ado.net I would create a object
> for
> > the connection and refer to them. This seems to be not the right aproach
> in
> > this Data Provider. All the Implement interface blabla doesn't help me,
> > becouse I simply don't know how to do this exactly.
> > A simple real sample would save the hundrets of hours I'm waste on this.
> >
> > The reason why I like to implement the data provider is, that im must
> > execute several stored procedures and return the result from a temporary
> > table. I can't use the stored procedure to query the result, becouse
> Oracle
> > (7.3) requires that I specify the amount of expected records, before I'm
> send
> > this stored procedure. If the dataprovider is running, I like to change
> them
> > in a way, that I can do something else before I execute the query.
> Returning
> > a dataset with a stored procedure from oracle (even if I know the expected
> > amount of returned records) is not efficient and results in bad
> performance.
> > Inside the dataprovider I like to create datasets and return them to
> > Reporting Services.
> >
> > Thanks in advance!
> >
> > "Dev Main" wrote:
> >
> > > I don't get a Data Provider to access my oracle database.
> > >
> > > Can somebody send me his Data Provider?
> > > If you have a Provider accessing the SQL-Server you can send also this
> > > Provider.
> > > E-Mail: Data.Prov@.Freenet.de
> > >
> > > I'm a novice in Report Services and Data Provider and search for days
> now
> > > for a solution. All I find doesn't help, I guess something simple and
> very
> > > basic is missing.
> > >
> > > Please help!
>
>