Integrating RS 2005 Reports with Web Applications

Hi All
M a newbie in RS 2005 ..
I need to integrate my RS 2005 Reports into the web applications ...
say ASP.NET or made using C# ...
without using the web-services ...
there's a way using URL access and one more using Visual Basic 2005 ...
All my queries are stored as stored procedure and need to have my own
interface where from the user can see the report for the actions which
one takes ..
Please help...
Regards
Manu GuptaURL access to reports is well documented in the SQL Server books online.
You can download here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
in case you don't already have SQL 2005 installed somewhere.
URL access will work no matter what your development environment or language
is. Obviously I'd recomend using VisualStudio.NET 2005. The choice of C#,
VB.NET or any of the other .NET language providers makes no difference at
all.
<rmanu7382@.gmail.com> wrote in message
news:1141130557.353566.267620@.t39g2000cwt.googlegroups.com...
> Hi All
> M a newbie in RS 2005 ..
> I need to integrate my RS 2005 Reports into the web applications ...
> say ASP.NET or made using C# ...
> without using the web-services ...
> there's a way using URL access and one more using Visual Basic 2005 ...
> All my queries are stored as stored procedure and need to have my own
> interface where from the user can see the report for the actions which
> one takes ..
> Please help...
> Regards
> Manu Gupta
>|||What is your problem with web services? That is how Report Manager itself
integrates wtih RS.
URL access will work but in your case what you should be looking at are the
new controls that come with VS 2005. The controls come in two flavors:
winform and webform. They will drastically reduce your integration time.
They are built using web services but that would be transparent to you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<rmanu7382@.gmail.com> wrote in message
news:1141130557.353566.267620@.t39g2000cwt.googlegroups.com...
> Hi All
> M a newbie in RS 2005 ..
> I need to integrate my RS 2005 Reports into the web applications ...
> say ASP.NET or made using C# ...
> without using the web-services ...
> there's a way using URL access and one more using Visual Basic 2005 ...
> All my queries are stored as stored procedure and need to have my own
> interface where from the user can see the report for the actions which
> one takes ..
> Please help...
> Regards
> Manu Gupta
>

Integrating MSDE 2000 with VB Applications

Hi,
I have VB 6.0 application using MSDE 2000.
I created setup file using Package & Deployment Wizard.
I have included "SQL Server Desktop Engine Merge Modules" and
"sqlredis.exe".
However, when I try to test it on another computer, I get following error.
DBNETLIB[ConnectionOpen(Connect()).] SQL Server does not exists or access is
denied.
clicking OK comes up with
Runtime error -2147467259 (80004005)
Automation Error
Unspecified error.
What am I missing?
Any Idea? Let me know if further info needed.
Shailesh
hi Shailesh,
Shailesh Patel wrote:
> Hi,
> I have VB 6.0 application using MSDE 2000.
> I created setup file using Package & Deployment Wizard.
> I have included "SQL Server Desktop Engine Merge Modules" and
> "sqlredis.exe".
> However, when I try to test it on another computer, I get following
> error. DBNETLIB[ConnectionOpen(Connect()).] SQL Server does not
> exists or access is denied.
> clicking OK comes up with
> Runtime error -2147467259 (80004005)
> Automation Error
> Unspecified error.
> What am I missing?
> Any Idea? Let me know if further info needed.
> Shailesh
please have a look at
http://support.microsoft.com/default...06&Product=sql
if helps
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply