A weird problem of Reporting Service

My company is using SQL 2000, Reporting Service SP2, Server 2003, .NET framework 1.1.

We have an ASP.NET application, working properly on one of our test machine, but when we test on another test machine, it would have the following problem:

When we want to view the PDF or EXCEL report generated by Reporting Services, we get prompted to download an ASPX file. If we choose [Open], it will use Visual Studio.NET to open it. But if we choose [Save], and change the extenstion name, it's actually the correct report file.

That means, the report is generated correctly, but we can't open it.

We have added the Content-Disposition to indicate a correct extension name, but that machine still have this weird problem. Frustrately, it works perfectly on our another machine, even without Content-Disposition.

So, we are thinking probably it's related some file system security configuration. Could anyone give me a little hint about it?

Thank you very much!

Hi, we have the same problem. Did you get anywhere with this?|||are u still looking for answer of it?

that's because the server turns on the http compression, stupid IE doesn't understand it.

one thing to work it around is, turn off the compression for aspx, it might affect too much. If that's a concern, change your report generator file from ASPX to another extension, then that extension file won't have compression on. And you can enable asp.net to handle that new extension, which is only used to generate report.

this just works fine for us

A weird problem of Reporting Service

My company is using SQL 2000, Reporting Service SP2, Server 2003, .NET framework 1.1.

We have an ASP.NET application, working properly on one of our test machine, but when we test on another test machine, it would have the following problem:

When we want to view the PDF or EXCEL report generated by Reporting Services, we get prompted to download an ASPX file. If we choose [Open], it will use Visual Studio.NET to open it. But if we choose [Save], and change the extenstion name, it's actually the correct report file.

That means, the report is generated correctly, but we can't open it.

We have added the Content-Disposition to indicate a correct extension name, but that machine still have this weird problem. Frustrately, it works perfectly on our another machine, even without Content-Disposition.

So, we are thinking probably it's related some file system security configuration. Could anyone give me a little hint about it?

Thank you very much!

Hi, we have the same problem. Did you get anywhere with this?|||are u still looking for answer of it?

that's because the server turns on the http compression, stupid IE doesn't understand it.

one thing to work it around is, turn off the compression for aspx, it might affect too much. If that's a concern, change your report generator file from ASPX to another extension, then that extension file won't have compression on. And you can enable asp.net to handle that new extension, which is only used to generate report.

this just works fine for us

A weird problem of Reporting Service

My company is using SQL 2000, Reporting Service SP2, Server 2003, .NET framework 1.1.

We have an ASP.NET application, working properly on one of our test machine, but when we test on another test machine, it would have the following problem:

When we want to view the PDF or EXCEL report generated by Reporting Services, we get prompted to download an ASPX file. If we choose [Open], it will use Visual Studio.NET to open it. But if we choose [Save], and change the extenstion name, it's actually the correct report file.

That means, the report is generated correctly, but we can't open it.

We have added the Content-Disposition to indicate a correct extension name, but that machine still have this weird problem. Frustrately, it works perfectly on our another machine, even without Content-Disposition.

So, we are thinking probably it's related some file system security configuration. Could anyone give me a little hint about it?

Thank you very much!

Hi, we have the same problem. Did you get anywhere with this?|||are u still looking for answer of it?

that's because the server turns on the http compression, stupid IE doesn't understand it.

one thing to work it around is, turn off the compression for aspx, it might affect too much. If that's a concern, change your report generator file from ASPX to another extension, then that extension file won't have compression on. And you can enable asp.net to handle that new extension, which is only used to generate report.

this just works fine for us
sql

A weird problem - Need URGENT HELP

Hello All,

Greetings!

I have been using the VS2005/SQL 2005 for over a year to develp an application. This is completly a web application and pretty simple and straight forward.

Here is the situation:

(1) Including myself, one more user is logging on.

(2) We both are querying different departments and adding employees to the department.

For example: I query a dept# 101 and the other users querying dept# 102.

(3) When I commit my changes, I am getting the data saved into the table what other user queried in.(Instead of my dept# 101, I am getting dept#102 saved in the table.). The records that are commited using the stored prodedure, simple insert statement and they are between BEGIN TRAN and COMMIT TRAN.

(4) I trapped the sql command using the SQL profiler but I am in the need of some help to overcome.

Is there any SQL Server agent to be tweaked in? OR anything to do with IIS?

Your help will be highly appreciated.

Regards,

Amritha

Very difficult to say without more info, but my gut instinct is its not SQL server thats the issue here.

Have you tried running the stored procedures outside of the application? Do they give the correct results?

Is it a standard stored procedure or CLR stored procedure?

Post the sql code back here and it might help.

|||

Thank you so much for the response. I figured out the problem. Some of our colleagues declare variables as static and hence the reason. It should have been as session variables.

Again, I appreciate your time.

Regards,

Amritha

A weird problem - Need URGENT HELP

Hello All,

Greetings!

I have been using the VS2005/SQL 2005 for over a year to develp an application. This is completly a web application and pretty simple and straight forward.

Here is the situation:

(1) Including myself, one more user is logging on.

(2) We both are querying different departments and adding employees to the department.

For example: I query a dept# 101 and the other users querying dept# 102.

(3) When I commit my changes, I am getting the data saved into the table what other user queried in.(Instead of my dept# 101, I am getting dept#102 saved in the table.). The records that are commited using the stored prodedure, simple insert statement and they are between BEGIN TRAN and COMMIT TRAN.

(4) I trapped the sql command using the SQL profiler but I am in the need of some help to overcome.

Is there any SQL Server agent to be tweaked in? OR anything to do with IIS?

Your help will be highly appreciated.

Regards,

Amritha

Very difficult to say without more info, but my gut instinct is its not SQL server thats the issue here.

Have you tried running the stored procedures outside of the application? Do they give the correct results?

Is it a standard stored procedure or CLR stored procedure?

Post the sql code back here and it might help.

|||

Thank you so much for the response. I figured out the problem. Some of our colleagues declare variables as static and hence the reason. It should have been as session variables.

Again, I appreciate your time.

Regards,

Amritha

A weird maintenance problem.

I have a small database that is causing my maintenance plans to hang. There
are no errors logged and it does not eventually quit, it just hangs. If I
rename the database, it works fine, but then fails again when named back. I
dropped the db and looked in Master and msdb, but found no references to the
database name (at least in the few sys tables I looked in). Any ideas?
Send more info about the problem. If the database fails only with a
specific name, what this name is? Which version of SQL Server? Which
activities are you doing in your maintenance plan? Check on your log to see
which activity and database is hanging (log shows messages like dbcc
checkdb(db), Database backed up: Database: db, etc).
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn" wrote:

> I have a small database that is causing my maintenance plans to hang. There
> are no errors logged and it does not eventually quit, it just hangs. If I
> rename the database, it works fine, but then fails again when named back. I
> dropped the db and looked in Master and msdb, but found no references to the
> database name (at least in the few sys tables I looked in). Any ideas?
>
>
|||Thanks, but I think I got it. I rebuilt the database and then had to restart
SQL to clear something (I don't know what) out of memory. Now it works fine.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:9686B3F0-4AD7-4A46-A332-5717AB97EE07@.microsoft.com...[vbcol=seagreen]
> Send more info about the problem. If the database fails only with a
> specific name, what this name is? Which version of SQL Server? Which
> activities are you doing in your maintenance plan? Check on your log to
> see
> which activity and database is hanging (log shows messages like dbcc
> checkdb(db), Database backed up: Database: db, etc).
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Shawn" wrote:

A weird maintenance problem.

I have a small database that is causing my maintenance plans to hang. There
are no errors logged and it does not eventually quit, it just hangs. If I
rename the database, it works fine, but then fails again when named back. I
dropped the db and looked in Master and msdb, but found no references to the
database name (at least in the few sys tables I looked in). Any ideas?Send more info about the problem. If the database fails only with a
specific name, what this name is? Which version of SQL Server? Which
activities are you doing in your maintenance plan? Check on your log to see
which activity and database is hanging (log shows messages like dbcc
checkdb(db), Database backed up: Database: db, etc).
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn" wrote:

> I have a small database that is causing my maintenance plans to hang. Ther
e
> are no errors logged and it does not eventually quit, it just hangs. If I
> rename the database, it works fine, but then fails again when named back.
I
> dropped the db and looked in Master and msdb, but found no references to t
he
> database name (at least in the few sys tables I looked in). Any ideas?
>
>|||Thanks, but I think I got it. I rebuilt the database and then had to restart
SQL to clear something (I don't know what) out of memory. Now it works fine.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:9686B3F0-4AD7-4A46-A332-5717AB97EE07@.microsoft.com...[vbcol=seagreen]
> Send more info about the problem. If the database fails only with a
> specific name, what this name is? Which version of SQL Server? Which
> activities are you doing in your maintenance plan? Check on your log to
> see
> which activity and database is hanging (log shows messages like dbcc
> checkdb(db), Database backed up: Database: db, etc).
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Shawn" wrote:
>

A weird maintenance problem.

I have a small database that is causing my maintenance plans to hang. There
are no errors logged and it does not eventually quit, it just hangs. If I
rename the database, it works fine, but then fails again when named back. I
dropped the db and looked in Master and msdb, but found no references to the
database name (at least in the few sys tables I looked in). Any ideas?Send more info about the problem. If the database fails only with a
specific name, what this name is? Which version of SQL Server? Which
activities are you doing in your maintenance plan? Check on your log to see
which activity and database is hanging (log shows messages like dbcc
checkdb(db), Database backed up: Database: db, etc).
Ben Nevarez, MCDBA, OCP
Database Administrator
"Shawn" wrote:
> I have a small database that is causing my maintenance plans to hang. There
> are no errors logged and it does not eventually quit, it just hangs. If I
> rename the database, it works fine, but then fails again when named back. I
> dropped the db and looked in Master and msdb, but found no references to the
> database name (at least in the few sys tables I looked in). Any ideas?
>
>|||Thanks, but I think I got it. I rebuilt the database and then had to restart
SQL to clear something (I don't know what) out of memory. Now it works fine.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:9686B3F0-4AD7-4A46-A332-5717AB97EE07@.microsoft.com...
> Send more info about the problem. If the database fails only with a
> specific name, what this name is? Which version of SQL Server? Which
> activities are you doing in your maintenance plan? Check on your log to
> see
> which activity and database is hanging (log shows messages like dbcc
> checkdb(db), Database backed up: Database: db, etc).
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Shawn" wrote:
>> I have a small database that is causing my maintenance plans to hang.
>> There
>> are no errors logged and it does not eventually quit, it just hangs. If I
>> rename the database, it works fine, but then fails again when named back.
>> I
>> dropped the db and looked in Master and msdb, but found no references to
>> the
>> database name (at least in the few sys tables I looked in). Any ideas?
>>sql

A weird error !

I was developing a data-driven website but I got this error

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

(I have Sql server 2005 also downloaded before)

Please help me cause any website that has data can not be executed even the quick start tutorial that ships with the ASP.NET 2.0

What should I do?

Hey,

If you go into the SQL Server Surface Area Configuration, then view the components, you can enable remote connections, which may solve the problem.

A severe error occurred on the current command

I get this weird error. Was wondering whether anyone could help here with fi
nding a solution.
SqlException: A severe error occurred on the current command. The results,
if any, should be discarded.
I'm using 2 SQL 2000 Servers. Server A and Server B. I have a Stored
Procedure on Server A that executes a Stored Procedure on Server B. What's o
dd is that i can run the Stored Procedure on Server A in Query Analyzer and
it works
great... as expected... but when i call it in ASP.NET (VB.NET), i get the se
vere error
message.
Can you help me here with what is causing this and how can I get over with t
his error.
Thanks
Reji
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...Reji,
That error is being produced by ADO.NET, not by SQL Server. It's a
SqlException... Have you tried debugging your call to the stored procedure?
You might want to post this question in an ADO.NET specific group, or
perhaps microsoft.public.dotnet.languages.vb.data would be more helpful.
"Reji" <am_saved@.yahoo.com> wrote in message
news:%23wkbf%23BaEHA.3888@.TK2MSFTNGP10.phx.gbl...
> I get this weird error. Was wondering whether anyone could help here with
finding a solution.
> SqlException: A severe error occurred on the current command. The results,
> if any, should be discarded.
> I'm using 2 SQL 2000 Servers. Server A and Server B. I have a Stored
> Procedure on Server A that executes a Stored Procedure on Server B. What's
odd is that i can run the Stored Procedure on Server A in Query Analyzer and
it works
> great... as expected... but when i call it in ASP.NET (VB.NET), i get the
severe error
> message.
> Can you help me here with what is causing this and how can I get over with
this error.
> Thanks
> Reji
>
> ****************************************
******************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...|||Thanks much Adam. Appreciate the help. Have posted the same in the forum you
said. Hope some one would answer me.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...|||See whether this KBA http://support.microsoft.com/defaul...;82736
6 is any help to resolve.
--
--
Satya SKJ
"Adam Machanic" wrote:

> Reji,
> That error is being produced by ADO.NET, not by SQL Server. It's a
> SqlException... Have you tried debugging your call to the stored procedure
?
> You might want to post this question in an ADO.NET specific group, or
> perhaps microsoft.public.dotnet.languages.vb.data would be more helpful.
>
> "Reji" <am_saved@.yahoo.com> wrote in message
> news:%23wkbf%23BaEHA.3888@.TK2MSFTNGP10.phx.gbl...
> finding a solution.
> odd is that i can run the Stored Procedure on Server A in Query Analyzer a
nd
> it works
> severe error
> this error.
> ASP.NET resources...
>
>

A problem when opening PDF and EXCEL report

Hi, All
This is really weird. Here is the full story:
My company has a test site to test the application we are developing,
and the Reporting Server is on the same machine. Each developer has the
full application on their own machine so that they can test other parts
individually and check in to the test site later. But we are all using
the same webservice server (that test site machine) and the same report
database.
Now, when I run the report part locally, by locally, I mean I am
running the application in my own machine, but that application is
still loading the remote webservice to generate the report from the
remote database. The report generation is working correctly, I can open
the report and view.
But, if I run that part in the test site, it has a problem. It still
generates a report, but it will prompt a download window, and the
report extension name is always ASPX, (for pdf and excel file). If I
click Open, it will use Visual Studio to open it. If I click Save, and
change the extension name, it's a correct report.
More interesting, for PDF report, if the client machine has Adobe
Reader 7.0, it won't even prompt, instead, it would just show an empty
window, you know those empty windows, you can see the background
through that window, and if you move the window, the background will
follow. Yup, a kind of normal window. It only has that prompt window if
the client has Adobe Reader 6.0
Anyone has a clue how to solve this? Any help is appreciated, thank you
very much!
--
Best Regards!
SowenI saw this during the beta for 2005, but it cleared up once I went with the
released version of 2005. Has this machine ever had the beta on it?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139930602.042085.322510@.f14g2000cwb.googlegroups.com...
> Hi, All
> This is really weird. Here is the full story:
> My company has a test site to test the application we are developing,
> and the Reporting Server is on the same machine. Each developer has the
> full application on their own machine so that they can test other parts
> individually and check in to the test site later. But we are all using
> the same webservice server (that test site machine) and the same report
> database.
> Now, when I run the report part locally, by locally, I mean I am
> running the application in my own machine, but that application is
> still loading the remote webservice to generate the report from the
> remote database. The report generation is working correctly, I can open
> the report and view.
> But, if I run that part in the test site, it has a problem. It still
> generates a report, but it will prompt a download window, and the
> report extension name is always ASPX, (for pdf and excel file). If I
> click Open, it will use Visual Studio to open it. If I click Save, and
> change the extension name, it's a correct report.
> More interesting, for PDF report, if the client machine has Adobe
> Reader 7.0, it won't even prompt, instead, it would just show an empty
> window, you know those empty windows, you can see the background
> through that window, and if you move the window, the background will
> follow. Yup, a kind of normal window. It only has that prompt window if
> the client has Adobe Reader 6.0
> Anyone has a clue how to solve this? Any help is appreciated, thank you
> very much!
> --
> Best Regards!
> Sowen
>|||hi, Bruce
thanks for your reply.
But we are still using VS 2003, SQL 2000 and .NET framework 1.1|||Ahh, OK. What Service Pack are you on?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139933336.752696.258260@.g44g2000cwa.googlegroups.com...
> hi, Bruce
> thanks for your reply.
> But we are still using VS 2003, SQL 2000 and .NET framework 1.1
>|||for reporting service, SP2
for 2003 server, SP1,|||How are your viewing the report? In your own app? Report Manager? If your
own app are you using URL integration or web services? If in your own app,
does it work properly when you use Report Manager?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139934523.097245.13230@.g44g2000cwa.googlegroups.com...
> for reporting service, SP2
> for 2003 server, SP1,
>|||via URL. sth like
http://localhost/mmis/ReportViewer/tabid/140/desktopdefault/+/Default.aspx,
(we are using DNN too.)
the code generating the report is correct.
It works properly if I run all application on my own machine's IIS.
It only has those problems if I run it on our test site (remotely)|||OK, I think what is happening is the Server 2003 internet security. Try
putting in the name of the machine instead of localhost and add the local
machine to the safezone.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139936364.847940.143500@.g44g2000cwa.googlegroups.com...
> via URL. sth like
> http://localhost/mmis/ReportViewer/tabid/140/desktopdefault/+/Default.aspx,
> (we are using DNN too.)
> the code generating the report is correct.
> It works properly if I run all application on my own machine's IIS.
> It only has those problems if I run it on our test site (remotely)
>|||do you mean adding our test site url in IE security trusted site?|||Here is what I suggest you do. Go to the test server. Open up IE and go to
report manager and make sure your reports and exports etc work as you they
should. Until you know it all works from report manager I wouldn't waste
much time wondering why it isn't working from your app. My guess is that you
will see some of the same issues there. Windows 2003 SP1 really protects
what web sites you can go to. You most likely need to add to trusted sites
in IE on the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sowen" <sowencheung@.gmail.com> wrote in message
news:1139937391.453464.226010@.z14g2000cwz.googlegroups.com...
> do you mean adding our test site url in IE security trusted site?
>|||it works on our test site.
It is frustrated that the same code actually works on our another
remote test site, I just found out.
Is there any security configuration issue I should pay attention to?
It's strange that the same thing working on one machine but not another
machine.|||I mean it works on the test site report manager. I can see everything
running properly. But I have the same problem if I run the ASP.NET
program to create the PDF or EXCEL report, the prompt window asks me to
download a ASPX file.
But if I run the same code on another test machine, there is no such a
problem.
strange...