 | |
sharepoint + office 2003 webparts + analysis services 2005
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
sharepoint + office 2003 webparts + analysis services 2005 -
05-23-2006
, 07:06 AM
#2
| |||
| |||
|
|
Hello, This configuration works fine inside intranet. It is a killer combination. When trying to acces from extranet, with OWC and 2005 drivers installed, we receive an OLEDB multistep error. In sharepoint we are promted for credentials and everyting work great, except for pivot table. There are couple of demos in internet that shows that it is possible. Any help is much appreciated. Lori |
#3
| |||
| |||
|
|
Hello, This configuration works fine inside intranet. It is a killer combination. When trying to acces from extranet, with OWC and 2005 drivers installed, we receive an OLEDB multistep error. In sharepoint we are promted for credentials and everyting work great, except for pivot table. There are couple of demos in internet that shows that it is possible. Any help is much appreciated. Lori |
#4
| |||
| |||
|
|
Sorry, but I don't really have any good news for you. The issue here is that OWC is an ActiveX control. It actually executes on the clients PC, not on the web server. So in an extranet scenario, the external users would need to be logged in to their local PC's with credentials that are valid on your network and are part of a role in the olap database. Another way to get this to work in an extranet environment would be to set up the OWC connection as a http connection, although this would also mean that your AS server would need to be directly accessible by your extranet users. Finally you could look at something other than OWC, Mosha has some examples of thin clients here http://www.mosha.com/msolap/util.htm#ThinClients I have setup ThinSlicer and one or two of the others and they execute entirely on the server sending html to the client. They are not quite as interactive as OWC, but it is something else you might want to consider. -- Regards Darren Gosbell [MCSD] Blog: http://www.geekswithblogs.net/darrengosbell In article <eV8xVDmfGHA.3572 (AT) TK2MSFTNGP04 (DOT) phx.gbl>, lhaiducescu (AT) seniorsoftware (DOT) ro says... Hello, This configuration works fine inside intranet. It is a killer combination. When trying to acces from extranet, with OWC and 2005 drivers installed, we receive an OLEDB multistep error. In sharepoint we are promted for credentials and everyting work great, except for pivot table. There are couple of demos in internet that shows that it is possible. Any help is much appreciated. Lori |
#5
| |||
| |||
|
|
Is there any chance that using Sharepoint 2007 + Office 2007 to accomplish this? Thank you! "Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote in message news:MPG.1edefdf211df1bd2989925 (AT) news (DOT) microsoft.com... Sorry, but I don't really have any good news for you. The issue here is that OWC is an ActiveX control. It actually executes on the clients PC, not on the web server. So in an extranet scenario, the external users would need to be logged in to their local PC's with credentials that are valid on your network and are part of a role in the olap database. Another way to get this to work in an extranet environment would be to set up the OWC connection as a http connection, although this would also mean that your AS server would need to be directly accessible by your extranet users. Finally you could look at something other than OWC, Mosha has some examples of thin clients here http://www.mosha.com/msolap/util.htm#ThinClients I have setup ThinSlicer and one or two of the others and they execute entirely on the server sending html to the client. They are not quite as interactive as OWC, but it is something else you might want to consider. -- Regards Darren Gosbell [MCSD] Blog: http://www.geekswithblogs.net/darrengosbell In article <eV8xVDmfGHA.3572 (AT) TK2MSFTNGP04 (DOT) phx.gbl>, lhaiducescu (AT) seniorsoftware (DOT) ro says... Hello, This configuration works fine inside intranet. It is a killer combination. When trying to acces from extranet, with OWC and 2005 drivers installed, we receive an OLEDB multistep error. In sharepoint we are promted for credentials and everyting work great, except for pivot table. There are couple of demos in internet that shows that it is possible. Any help is much appreciated. Lori |
#6
| |||
| |||
|
|
I don't think MS is really doing too much with OWC (there were even rumours that it may have been dropped from this version of Office). It looks like the files are still there in beta 2, but I have not actually seen it running yet. see: http://blog.u2u.info/DottextWeb/patr.../28/19104.aspx There is a new product coming called Excel Services. This is a server which can "publish" Excel workbooks. It may suit your needs, but from what I have heard it will not have the same level of functionality as OWC. see: http://prologika.com/CS/blogs/blog/a...01/03/751.aspx -- Regards Darren Gosbell [MCSD] Blog: http://www.geekswithblogs.net/darrengosbell In article <erhCHp#fGHA.4932 (AT) TK2MSFTNGP03 (DOT) phx.gbl>, lhaiducescu (AT) seniorsoftware (DOT) ro says... Is there any chance that using Sharepoint 2007 + Office 2007 to accomplish this? Thank you! "Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote in message news:MPG.1edefdf211df1bd2989925 (AT) news (DOT) microsoft.com... Sorry, but I don't really have any good news for you. The issue here is that OWC is an ActiveX control. It actually executes on the clients PC, not on the web server. So in an extranet scenario, the external users would need to be logged in to their local PC's with credentials that are valid on your network and are part of a role in the olap database. Another way to get this to work in an extranet environment would be to set up the OWC connection as a http connection, although this would also mean that your AS server would need to be directly accessible by your extranet users. Finally you could look at something other than OWC, Mosha has some examples of thin clients here http://www.mosha.com/msolap/util.htm#ThinClients I have setup ThinSlicer and one or two of the others and they execute entirely on the server sending html to the client. They are not quite as interactive as OWC, but it is something else you might want to consider. -- Regards Darren Gosbell [MCSD] Blog: http://www.geekswithblogs.net/darrengosbell In article <eV8xVDmfGHA.3572 (AT) TK2MSFTNGP04 (DOT) phx.gbl>, lhaiducescu (AT) seniorsoftware (DOT) ro says... Hello, This configuration works fine inside intranet. It is a killer combination. When trying to acces from extranet, with OWC and 2005 drivers installed, we receive an OLEDB multistep error. In sharepoint we are promted for credentials and everyting work great, except for pivot table. There are couple of demos in internet that shows that it is possible. Any help is much appreciated. Lori |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.