Problem with LoadReport web method

Hi,

I'm working on a reporting client for Reporting Services 2005 using SOAP. The problem I'm having is that for reports with multiple pages or a document map, the LoadReport web method, always says they have 0 pages or no document map.

To simplify the problem, i created a simple console app that just calls LoadReport on the /AdventureWorks Sample Reports/Product Catalog report to see if HasDocumentMap is true (it should be but isn't).

Any suggestions?

Kwan

I figured it out and it makes sense. The information is available only after you call Render.

So call, Render, then GetExecutionInfo to get the correct values for HasDocumentMap and NumPages.

Problem with linked server to Oracle

I run linked server from SQL Server 2000 to Oracle 9.i. In SQL Server oracle client is xa73.dll.
EXEC sp_addlinkedserver @.server='ORDB',
@.provider='MSDAORA',
@.srvproduct = 'Oracle',
@.datasrc='ORDB'
EXEC sp_addlinkedsrvlogin
@.rmtsrvname ='ORDB',
@.useself ='false',
@.locallogin =NULL,
@.rmtuser = 'ivr',
@.rmtpassword = 'jjcom'
SELECT * FROM OPENQUERY(ORDB,'SELECT * FROM SUBSCRIBER')
but get error like for the following :
Server: Msg 7399, Level 16, State 1, Line 2
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.]
Please help me to get a solution ?

Hi,

did you check those threads on the groups ?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=56755&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=19365&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=408756&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=417751&SiteID=1

The latter one including links for troubleshotting linked servers in Oracle.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||Yes, I already checked those site and still get error.
|||

Please try to install MDAC 2.8.

Thanks

|||Hi Zoya,
I already install mdac 2.8 sp1 and try to execute query, the error message nos is :
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Error while trying to retrieve text for error ORA-01019
]

problem with executing sp_addrolemember...

When I login localy (computer with sql server) I can call procedure sp_addrolemember but when I am loged in remotely (from client computer)and try to call the same procedure I get this message: 'User does not have permission to performe this action'.

hi

executing the procedure requires membership to db_owner or db_securityadmin database roles so that has nothing to do with workstation but with principals and thus logins...

verify the login you are connecting with from the remote client is mapped to a database user with enought permissions..

regards