|
|
You're in the
sql server reporting services
group:.net Data Provider (YOU can help)
sql server reporting services:
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.
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) actually uses OLE DB. The text-based generic query designer (GQD; 4 panes) uses the .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 [quoted text, click to view] "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. [quoted text, click to view] 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. [quoted text, click to view] "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!
[quoted text, click to view] "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 [quoted text, click to view] "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) actually uses > > > OLE DB. The text-based generic query designer (GQD; 4 panes) uses the ..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) actually uses OLE DB. The text-based generic query designer (GQD; 4 panes) uses the .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 [quoted text, click to view] "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! [quoted text, click to view] "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. >
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 [quoted text, click to view] "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. [quoted text, click to view] "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! > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |