Hi Ken,
My COM+ is running under user from administrator group. Is there any problem
with IIS Anonymous User Context?
But how can IIS user affect DB connection coz DB server is on WAN with
respcet to IIS and I am passing appropriate user with appropriate rights for
DB access.
Also suggest what should i change in IIS settings, also what is OTOH.
Thanks
Jay
"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
news:OJy81eVaDHA.3360@tk2msftngp13.phx.gbl...[color=blue]
> Then it's probably some kind of user context problem (maybe). The only[/color]
thing[color=blue]
> that I can think of OTOH, is that when you run a VB program, it is running
> in your user context.
>
> ASP runs under the IIS Anonymous User context (unless you are forcing
> authentication). I don't know what your COM+ object is running under...
>
> Cheers
> Ken
>
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> "Adhik" <adhik@hotpop.com> wrote in message
> news:e3M8XPTaDHA.2580@TK2MSFTNGP09.phx.gbl...
> : I am able to connect through Enterprise Manager, and actally I can able[/color]
to[color=blue]
> : connect using VB. means if i create test VB application for connection
> with
> : remote DB it works fine.....
> : That what i am not getting if VB client is getting connection then why[/color]
not[color=blue]
> : ASP.
> :
> : Thanks
> : Jay
> :
> :
> : "Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
> : news:OJiUcYLaDHA.2572@TK2MSFTNGP09.phx.gbl...
> : > Are you sure there is no firewall or similar that is blocking the
> : connection
> : > of the COM object to the SQL Server? If you are on the webserver, can
> you
> : > use some other tool (eg SQL Server Enterprise Manager) to connect to[/color]
the[color=blue]
> : > remote SQL Server?
> : >
> : > Cheers
> : > Ken
> : >
> : > "Jaydeep" <jaydeep.vaze@solversa.com> wrote in message
> : > news:eQ9UXOKaDHA.3248@tk2msftngp13.phx.gbl...
> : > : Hello,
> : > : I am facing a strange problem. Problem accessing remote[/color]
database[color=blue]
> : from
> : > : ASP using COM+ server application having VB components (ActiveX DLL)
> : > : installed.
> : > : Tier 1 : ASP front End (IIS 5.0)
> : > : Tire 2 : COM objects
> : > : Tier 3 : SQL Server 2000 DB
> : > : Flow is : ASP talks with COM objects and COM objects talks with DB
> : > :
> : > : Scenario 1
> : > : All Tier installed on single m/c.
> : > : Scenario 2
> : > : Tier1 and 2 are on one m/c and Tier 3 on another m/c in the same
> LAN
> : > : network
> : > : Scenario 3
> : > : Tier1 and 2 are on one m/c and Tier 3 on another m/c but[/color]
connected[color=blue]
> : > over
> : > : internet or WAN
> : > :
> : > : Scenario1 and Scenario 2 are working fine. But in Scenario 3, I am
> : facing
> : > : problem of accessing remote DB.
> : > : Throwing error "Invalid procedure call or argument"
> : > : I am not able to find out whether problem is in
> : > : ASP, which accesses DB via COM objects OR
> : > : COM objects talking to DB.
> : > : While connecting to remote DB, in the connection string I am[/color]
providing[color=blue]
> : IP
> : > : address of DB Server in my COM object.
> : > :
> : > : --
> : > : Jaydeep
> : > : Solversa Technologies
> : > :
> : > :
> : >
> : >
> :
> :
>
>[/color]
