GetObject() func does not work in asp.net?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bic - 02 Sep 2005 01:59 GMT

When porting my Windows app to asp.net I get an System.Exception: Cannot
create ActiveX component. What function can I use instead? Thanks for your
comments.

Signature

bic

Reply to this Message

Norman Yuan - 02 Sep 2005 15:29 GMT

It depends on what object you want to get and if it has been already created
(GetObject() is inherited from VB by VB.NET, to get existing object
instance, not for instantiating a new object instance), and more
importantly, if the user account has the permission to run that app the
object instance stands for.

> When porting my Windows app to asp.net I get an System.Exception: Cannot
> create ActiveX component. What function can I use instead? Thanks for
> your
> comments.

Reply to this Message

bic - 04 Sep 2005 08:53 GMT

Norman,

Thanks for your attempt to help. My Windows app works but moved to asp.net
the same code as follows
Dim objExcel As Object
objExcel = GetObject("P:\newbuild_data.xls")
I got bogged down. Why?

Signature

bic

> It depends on what object you want to get and if it has been already created
> (GetObject() is inherited from VB by VB.NET, to get existing object
[quoted text clipped - 6 lines]
> > your
> > comments.

Reply to this Message

Norman Yuan - 05 Sep 2005 18:14 GMT

It is most likely that you have user permission problem: by default, the
user account running the ASP.NET app (ASPNET, or Network Service) does not
have permission to run applications, such as Word, Excel... on the web
server. There is quite some posts on this issue and how to solve this.
Search MS KB or Google will give lots of links.

BTW, running desktop app, such as Excel. on the server side, is risky and
tricky and not recommended, especially if the ASP.NET app is open to public
or has a lot concurrent users. Soon coming VS2005 for MS Office Tool add new
means to get data pushed into Excel/Word without actually opening
*.xls/*.doc on the server. You may want to look into that approach.

> Norman,
>
[quoted text clipped - 17 lines]
>> > your
>> > comments.

Reply to this Message

bic - 07 Sep 2005 07:21 GMT

Norman,

Thanks very much for being great help. Since you've helped answering this
question, would you please help answering my Win app question reqarding the
same object? What would I have to do to completely close the objExcel I
execute the app? For I have problem opening the file once the obj had been
accessed until I restart Windows. Thanks.

Signature

bic

> It is most likely that you have user permission problem: by default, the
> user account running the ASP.NET app (ASPNET, or Network Service) does not
[quoted text clipped - 29 lines]
> >> > your
> >> > comments.

Reply to this Message

GetObject() func does not work in asp.net?

Free Magazines