Problem in Cursur

Hello Sir, I have a problem to create a cursur to showing 10 -10 records showing through Advance java Sql Queary. Please tell me to solve this problem.Hi Amandeep singh and welcome to TSDN MSSQL forum,

I have moved your post from the articles to the forum because this is where this type of question should be asked.

Can you confirm which version of MSSQL you are working on ?

Regards

Purple

Moderatorsql

Problem in browsing cube and dimension data

I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

Problem in browsing cube and dimension data

I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

Problem deploying reports

Apologies in advance, newbee to SQL Server and Reporting Services...
Installed Reporting Services in TEST environment (without SSL). I can author
a report, view the data from the data source and preview successfully.
However, I receive the following error message when trying to Deploy a
Solution from within Visual Studio Report Designer..."The underlying
connection was closed: Unable to connect to the remote server."
I can navigate to both the Report Manager and Report Server pages
successfuly using IE. Following the deployment failure the Report Manager
contains the new folder to which I was attempting to deploy the report but
it's empty (no report).
Any help would be appreciated.
Thanks,
Chris.In Report Manager, can you simply click on Upload File? Then you can upload
an RDL file manually.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Chris W, AgriBank" <ChrisWAgriBank@.discussions.microsoft.com> wrote in
message news:96862E2B-8F7C-422F-8A6E-71C86897BB60@.microsoft.com...
> Apologies in advance, newbee to SQL Server and Reporting Services...
> Installed Reporting Services in TEST environment (without SSL). I can
> author
> a report, view the data from the data source and preview successfully.
> However, I receive the following error message when trying to Deploy a
> Solution from within Visual Studio Report Designer..."The underlying
> connection was closed: Unable to connect to the remote server."
> I can navigate to both the Report Manager and Report Server pages
> successfuly using IE. Following the deployment failure the Report Manager
> contains the new folder to which I was attempting to deploy the report but
> it's empty (no report).
> Any help would be appreciated.
> Thanks,
> Chris.|||hey chris,
i m having the same issue .. are u able to resolve it ..
Please post ur comments if u know the solutions..
Thanks
SR
"Chris W, AgriBank" wrote:
> Apologies in advance, newbee to SQL Server and Reporting Services...
> Installed Reporting Services in TEST environment (without SSL). I can author
> a report, view the data from the data source and preview successfully.
> However, I receive the following error message when trying to Deploy a
> Solution from within Visual Studio Report Designer..."The underlying
> connection was closed: Unable to connect to the remote server."
> I can navigate to both the Report Manager and Report Server pages
> successfuly using IE. Following the deployment failure the Report Manager
> contains the new folder to which I was attempting to deploy the report but
> it's empty (no report).
> Any help would be appreciated.
> Thanks,
> Chris.