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" <ke*******@THISadOpenStatic.com> wrote in message
news:OJ**************@tk2msftngp13.phx.gbl...
Then it's probably some kind of user context problem (maybe). The only
thing 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" <ad***@hotpop.com> wrote in message
news:e3**************@TK2MSFTNGP09.phx.gbl...
: I am able to connect through Enterprise Manager, and actally I can able
to : 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
not : ASP.
:
: Thanks
: Jay
:
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
: news:OJ**************@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
the : > remote SQL Server?
: >
: > Cheers
: > Ken
: >
: > "Jaydeep" <ja**********@solversa.com> wrote in message
: > news:eQ**************@tk2msftngp13.phx.gbl...
: > : Hello,
: > : I am facing a strange problem. Problem accessing remote
database : 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
connected : > 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
providing : IP
: > : address of DB Server in my COM object.
: > :
: > : --
: > : Jaydeep
: > : Solversa Technologies
: > :
: > :
: >
: >
:
: