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
: > :
: > :
: >
: >
:
:
