Problem in accessing remote DB

[Jaydeep]

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.

 

[Ken Schaefer]

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

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

 

[Adhik]

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]

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


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

 

[Adhik]

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