Reporting Services using IBM DB2 Data Provider for .NET framework 2.0

Hello, I have been testing the IBM DB2 .NET data provider the last couple of months with the intention too use it with Reporting Services. I am using the IBM DB2 Data Provider for .NET framework 2.0. Everything seems too work fine until I started too test the Cashing and Scheduling of reports in Reporting Services.
Too be able too cash or too schedule reports in Reporting Services you have too set the "Credientials stored securely in the report server". The problem is when I do this with the Data Connection using the IBM .Net Provider I get an error Message:

"The data source 'XXXX' uses a managed data provider which does not implement IDbConnectionExtension. Only Windows Integrated Security or No Credentials are supported."

Is it possible too write a wrapper around the IBM dataprovider too implement IdbConnectionExtension and thereby extend the SSRS security model or is this something IBM have too do in the provider.

You can implement the wrapper yourself. Use this documentation to get started: http://msdn2.microsoft.com/en-us/library/ms154655(SQL.90).aspx

-- Robert

|||

Ok, thanks. I will look into this in a couple of days. Will this kind of wrapper couse much overhead or lack of performance?

I still wonder why IBM has not implemented this Interface in their release of the dataprovider.

B

|||

The purpose of the wrapper is mainly to "link" the defined interfaces, properties and methods to the underlying managed DB2 provider.

Your data extension wrapper should not perform any real data processing - just passing through calls. Hence, there won't be any significant overhead.

-- Robert

|||Were you able to create this provider?

Reporting Services Tuning

A couple of questions related to Reported Services tuning that I hope
someone might be able to give me a clue about....
1) In the Reporting Services Books Online, I have found a lot of
information on performance monitoring, but very little on performance
tuning. Is any additional information available, perhaps a whitepaper? Or
perhaps I am just missing something that is in the BOL?
2) An immediate question we have that perhaps someone can answer is, is
there any way to give On Demand reports a higher execution priority than
Scheduled reports? A particular concern is that a shared schedule, say "End
of month" processing, might become very popular and have a large number of
reports subscribed to it. These reports might then overload the server,
adversely effecting the execution time of On Demand reports.
Any enlightenment would be greatly appreciated.
Thanks,
BobOne thing to keep in mind. A snapshot of the report/data can be saved. So,
you can schedule to run at night every night and then save x days of
reports. Or you can run weekly and save 10 weeks of data (you specify how
many snapshots to save). This report or a link to it can be emailed out. To
me that is what makes the most sense, run the scheduled reports in off time
and then you will have no concern about the On Demand reports.
Bruce L-C
"Bob Hug" <rhug@.brassring.com> wrote in message
news:O6LK84QZEHA.3944@.tk2msftngp13.phx.gbl...
> A couple of questions related to Reported Services tuning that I hope
> someone might be able to give me a clue about....
> 1) In the Reporting Services Books Online, I have found a lot of
> information on performance monitoring, but very little on performance
> tuning. Is any additional information available, perhaps a whitepaper? Or
> perhaps I am just missing something that is in the BOL?
> 2) An immediate question we have that perhaps someone can answer is,
is
> there any way to give On Demand reports a higher execution priority than
> Scheduled reports? A particular concern is that a shared schedule, say
"End
> of month" processing, might become very popular and have a large number of
> reports subscribed to it. These reports might then overload the server,
> adversely effecting the execution time of On Demand reports.
> Any enlightenment would be greatly appreciated.
> Thanks,
> Bob
>sql

Reporting Services Quirks?

Hi,
I'm a bit of a newbies to BIDS and SQL Server 2005 and I've noticed a
couple on things about Reporting Services.
- Has anyone noticed that it's almost impossible to get the background
and font settings
to work in the Reporting Services Query Analyzer?
-When I execute any query with a "where" clause, the Query Analyzer
returns the column headings but no returned data is visible. However,
it seems to be getting the results back, because my reports run with
the results set. Also, the SQl analyzer runs it without a
hitch...weird.
- Does Reporting Services ever just stop and hang for you? I usually
have to reboot several times a day. Even though this is the only thing
running on my machine except SQL Query Anayzer. I have only a half
gig of RAM, but I have very little running on the desktop.
So far I have patched, and service packed both SQL and Visual Studio
2005, but still have weird behavior with the tool. Anyway, as misery
loves company, please respond with your stories and any fixes you have
found.
Best,
ScottOn Jul 9, 8:22 pm, dunnsc...@.gmail.com wrote:
> Hi,
> I'm a bit of a newbies to BIDS and SQL Server 2005 and I've noticed a
> couple on things about Reporting Services.
> - Has anyone noticed that it's almost impossible to get the background
> and font settings
> to work in the Reporting Services Query Analyzer?
> -When I execute any query with a "where" clause, the Query Analyzer
> returns the column headings but no returned data is visible. However,
> it seems to be getting the results back, because my reports run with
> the results set. Also, the SQl analyzer runs it without a
> hitch...weird.
> - Does Reporting Services ever just stop and hang for you? I usually
> have to reboot several times a day. Even though this is the only thing
> running on my machine except SQL Query Anayzer. I have only a half
> gig of RAM, but I have very little running on the desktop.
> So far I have patched, and service packed both SQL and Visual Studio
> 2005, but still have weird behavior with the tool. Anyway, as misery
> loves company, please respond with your stories and any fixes you have
> found.
> Best,
> Scott
The issues you are experiencing seem to be related to minimal
available RAM. Check out this article for SQL Server 2005 system/
hardware requirements (http://msdn2.microsoft.com/en-us/library/
ms143506.aspx). I have not personally experienced these types of
performance issues w/SQL Server 2005 or SSRS 2005. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Jul 9, 9:22 pm, dunnsc...@.gmail.com wrote:
> Hi,
> I'm a bit of a newbies to BIDS and SQL Server 2005 and I've noticed a
> couple on things about Reporting Services.
> - Has anyone noticed that it's almost impossible to get the background
> and font settings
> to work in the Reporting Services Query Analyzer?
> -When I execute any query with a "where" clause, the Query Analyzer
> returns the column headings but no returned data is visible. However,
> it seems to be getting the results back, because my reports run with
> the results set. Also, the SQl analyzer runs it without a
> hitch...weird.
> - Does Reporting Services ever just stop and hang for you? I usually
> have to reboot several times a day. Even though this is the only thing
> running on my machine except SQL Query Anayzer. I have only a half
> gig of RAM, but I have very little running on the desktop.
> So far I have patched, and service packed both SQL and Visual Studio
> 2005, but still have weird behavior with the tool. Anyway, as misery
> loves company, please respond with your stories and any fixes you have
> found.
> Best,
> Scott
I occasionally have to restart my computer. I usually leave it
running for a week or so without a restart and VS works fine. I got a
GIG of RAM on a Pentium D. I prefer AMD and I believe it's
performance is better (especially dual core) but I have not had too
much of a problem with this work machine. Try optimizing your quires
and your parameters. I changed parameters from looking at a table to
looking to a mapping table for populating... it brought down the
report from minutes to seconds in execution. I am having some weird
problems when trying to run reports from the reporting site but no one
has replied to me with a solution.

Reporting Services for SQL Server 2005?

I have been project managing the rollout of Reporting Services for the last
couple of months at several client sites in Austrlaia and have been looking
at the SQL Server 2005 Express Beta 2, as well as visiting some discussion
groups.
I have also noticed that the Beta doesn't have any Reporting Services stuff
included for 2005. Is there a release which has this or are they still
developing it?
Unfortunately I am not an MSDN Universal Subscriber so is this is where it's
located it there any way of obtaining a Beta copy to play with'There has not been a release in a public beta. It was not in beta 1 of
Widbey. So, you have not missed anything yet.
Bruce L-C
"David Dolheguy" <DavidDolheguy@.discussions.microsoft.com> wrote in message
news:5C070DD2-3716-436E-8CEC-CBDBEAF45360@.microsoft.com...
> I have been project managing the rollout of Reporting Services for the
last
> couple of months at several client sites in Austrlaia and have been
looking
> at the SQL Server 2005 Express Beta 2, as well as visiting some discussion
> groups.
> I have also noticed that the Beta doesn't have any Reporting Services
stuff
> included for 2005. Is there a release which has this or are they still
> developing it?
> Unfortunately I am not an MSDN Universal Subscriber so is this is where
it's
> located it there any way of obtaining a Beta copy to play with'|||Thanks for that...
I am so looking forward to the new relase.... I don't suppose anyone here
has read information on when it is going to be released?
"Bruce Loehle-Conger" wrote:
> There has not been a release in a public beta. It was not in beta 1 of
> Widbey. So, you have not missed anything yet.
> Bruce L-C
> "David Dolheguy" <DavidDolheguy@.discussions.microsoft.com> wrote in message
> news:5C070DD2-3716-436E-8CEC-CBDBEAF45360@.microsoft.com...
> > I have been project managing the rollout of Reporting Services for the
> last
> > couple of months at several client sites in Austrlaia and have been
> looking
> > at the SQL Server 2005 Express Beta 2, as well as visiting some discussion
> > groups.
> >
> > I have also noticed that the Beta doesn't have any Reporting Services
> stuff
> > included for 2005. Is there a release which has this or are they still
> > developing it?
> >
> > Unfortunately I am not an MSDN Universal Subscriber so is this is where
> it's
> > located it there any way of obtaining a Beta copy to play with'
>
>|||The last official word I've read on when Beta 3 of SQL 2005 would be
released is sometime in the second half of this year. I'm also interested in
any more specificity MS might be willing to offer...
Jeff Davis
"David Dolheguy" <DavidDolheguy@.discussions.microsoft.com> wrote in message
news:E5CF9D74-1921-4404-BE47-4A6AF8FAC49D@.microsoft.com...
> Thanks for that...
> I am so looking forward to the new relase.... I don't suppose anyone
here
> has read information on when it is going to be released?
> "Bruce Loehle-Conger" wrote:
> > There has not been a release in a public beta. It was not in beta 1 of
> > Widbey. So, you have not missed anything yet.
> >
> > Bruce L-C
> >
> > "David Dolheguy" <DavidDolheguy@.discussions.microsoft.com> wrote in
message
> > news:5C070DD2-3716-436E-8CEC-CBDBEAF45360@.microsoft.com...
> > > I have been project managing the rollout of Reporting Services for the
> > last
> > > couple of months at several client sites in Austrlaia and have been
> > looking
> > > at the SQL Server 2005 Express Beta 2, as well as visiting some
discussion
> > > groups.
> > >
> > > I have also noticed that the Beta doesn't have any Reporting Services
> > stuff
> > > included for 2005. Is there a release which has this or are they
still
> > > developing it?
> > >
> > > Unfortunately I am not an MSDN Universal Subscriber so is this is
where
> > it's
> > > located it there any way of obtaining a Beta copy to play with'
> >
> >
> >