Describe command.

Hi,

I have some (OLD) college notes that say if I type

Describe tablename;
Name NOT NULL? Type

in my SQL code window in access once run it will give me the structure of the table.

When I try to run I get a Invalid SQL statement error 'DELETE', 'INSERT'...

Where am I going wrong.

Thanksoh, it's simple, your old notes are wrong, access doesn't support that commandsql

Deployment of analysis services on windows 2003(Very urgent Please)

I have window 2000 as my development machine. I am using visual studio 2003 and sql server 2000.
I was able to develop a web application which uses the pivot table componant.
Every thing was working fine with out any problem.

I deployed my Project to windows 2003.
I am able to see the pivot table control.
I am not able to get any data into my pivot table.

I am not sure what is going wrong.
Is there anything I need to take care in windows 2003 specifically.

I don't have microsoft office on windows 2003.
Does it make a difference?

Please help!!!

Anil

Help Please|||

If you are using MSOWC for your pivot table component and if yout new server do not have riyhrt MSOWC installled or Office instaled,then you will not be able to view the data.

|||

MSOWC is already available on that machine.
I think the webservice is not able to contact the iis properly.
I have already setup the virtual directory for olap on IIS.

Any ideas

|||

Are you using the HTTP connection to Analysis Services or are you connection directly?

If you are connecting directly, what is the version of the MSOLAP80.dll? You may have to upgrade it to a service pack for Analysis Services.

Copy the MDX Sample Application exe to the 2003 machine and see if it can connect.

David

|||

Finally we narrow down the error it is with the fieldsets for the pivot table.

The web service is working fine if we remove the accessing fieldsets code.

When ever we tried to access the fieldsets in the cube we are getting error.

The error message is "Interop.OWC10 - Unspecified error ".

We installed service pack 4 on sql server.

I reinstalled the owc10 dll again.

I gave the permissions to the user machinename_iuser....

But nothing has solved my problem.

Please help.

|||

Hello. I have some doubts about if OWC:s work with HTTP unless you write some code to make them work. OWC are ActiveX controls and they use tcp/ip.

If you disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine, will this work? This is to make sure that nothing else is causing these problems.

It is not recommended to develop on an older O/S than the server O/S, but you are probably aware of that now.

Also check that you are allowed to run programs in your IIS folder on Windows 2003.

In IIS/ Win2003 you can check what web service extensions that are allowed.

Regards

Thomas Ivarsson

|||

i am not sure how to disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine.

Yes I am member in administrator group. I can run programs in my IIS folder.

Webservice has extensions allowed in iis are
Active Server Pages
ASP.Net v1.1.4322
Front Page server extensions
HwsMessages HttpReceive
Windows Sharepoint Services.

Regards
Anil

|||

Hello. Build a report from SSAS2000 in Excel and publish it to a webfolder on your IIS. I see that you have Sharepoint services. Upload your Excel SSAS2000 report to Sharepoint on Win2003 server.

Regards

Thomas Ivarsson

|||

I published it on iis and I am able to see all dimension but I am not able to see the fact table values.
I don't know what else to do.

Thanks So much for your help

Anil

|||

Here is link to a kb with your keywords(http://support.microsoft.com/kb/331400)

Regards

Thomas Ivarsson

Deploying reports on remote report server

Hello all,

I am trying to deploy my rdl's to a remote report server. I have given a valid path in the properties window before deploying...https://RemoteServerName/ReportServer. Now I get the error :

Error 1 The permissions granted to user 'domain\user' are insufficient for performing this operation.

what permission do I need on the remote server for deployment?

Thanks.....

You need rights to execute the Manage Reports, Manage Data Sources, and Manage Resources tasks. The pre-defined Content Manager role will give you these rights.|||

Hello Teo,

thanks for responding. where do I set the content manager role? Could you please tell me the steps involved?

Thanks...

|||

1. Open up the Report Manager (or use SQL Server Management Studio).

2. Navigate to the folder where your reports are and go to the folder properties and then Security tab.

3. Click Edit Item Security and click OK on the dialog that follows.

4. Click New Role Assignment.

5. Type in the Windows account (domain\user) or group that you want grant permissions to and select the Content Manager checkbox. Hit OK.

|||Hi I got the same issue. I tried to follow the steps given above. This is the first time I am deploying a report. There are no prior reports. I don't know what folder I need to navigate. Do I need to create a folder in Report Manager? I tried creating a folder and go to the security tab but I didn't see any Edit Item Security...Can you please explain? Thanks...|||You specify the deployment folder on the Report Server project properties (TargetReportFolder property). If you want to have access to all folders, grant your account Content Manager rights on the root Home folder in the Report Manager.

Deploying reports on remote report server

Hello all,

I am trying to deploy my rdl's to a remote report server. I have given a valid path in the properties window before deploying...https://RemoteServerName/ReportServer. Now I get the error :

Error 1 The permissions granted to user 'domain\user' are insufficient for performing this operation.

what permission do I need on the remote server for deployment?

Thanks.....

You need rights to execute the Manage Reports, Manage Data Sources, and Manage Resources tasks. The pre-defined Content Manager role will give you these rights.|||

Hello Teo,

thanks for responding. where do I set the content manager role? Could you please tell me the steps involved?

Thanks...

|||

1. Open up the Report Manager (or use SQL Server Management Studio).

2. Navigate to the folder where your reports are and go to the folder properties and then Security tab.

3. Click Edit Item Security and click OK on the dialog that follows.

4. Click New Role Assignment.

5. Type in the Windows account (domain\user) or group that you want grant permissions to and select the Content Manager checkbox. Hit OK.

|||Hi I got the same issue. I tried to follow the steps given above. This is the first time I am deploying a report. There are no prior reports. I don't know what folder I need to navigate. Do I need to create a folder in Report Manager? I tried creating a folder and go to the security tab but I didn't see any Edit Item Security...Can you please explain? Thanks...|||You specify the deployment folder on the Report Server project properties (TargetReportFolder property). If you want to have access to all folders, grant your account Content Manager rights on the root Home folder in the Report Manager.