Commerce Server General - Commerce Server Problem

This is Interesting: Free IT Magazines  
Home > Archive > Commerce Server General > June 2004 > Commerce Server Problem





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Commerce Server Problem
stephen noronha

2004-06-30, 5:56 pm

Hi Ravi,

yes both of us are accessing the same Commerce Server Backend... but my
server is registered in the site database as we ran the query suggested by
XU as follows,


If you have access to your commerce admin database (MSCS_Admin). Can you run
the
following query, (I assume your commerce site name is retail2002. If not,
please change accordingly)

SELECT rp.s_Value, r.s_DisplayName
FROM ResourceProps rp, SiteResources sr, Sites s, Resources r
WHERE rp.i_ResourceID = sr.i_ResourceID
AND sr.i_SiteID = s.i_SiteID
AND rp.i_ResourceID = r.i_ResourceID
AND s.s_Name ='retail2002'
AND rp.s_PropertyName = 's_WebServerMachine'



the result showed both of our names as being registered.

Stephen.



Andy Xu[MSFT]

2004-06-30, 8:50 pm

Stephen,

Refer to my answer in different thread. Thanks.
Andy Xu [MSFT]
Commerce Server Team
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------
From: "stephen noronha" <stephennoronha@hotmail.com>
Subject: Commerce Server Problem
Date: Wed, 30 Jun 2004 08:38:12 -0700
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Message-ID: <e8MlJgrXEHA.3668@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: 69.28.129.41
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.general:14168
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi Ravi,

yes both of us are accessing the same Commerce Server Backend... but my
server is registered in the site database as we ran the query suggested by
XU as follows,


If you have access to your commerce admin database (MSCS_Admin). Can you run
the
following query, (I assume your commerce site name is retail2002. If not,
please change accordingly)

SELECT rp.s_Value, r.s_DisplayName
FROM ResourceProps rp, SiteResources sr, Sites s, Resources r
WHERE rp.i_ResourceID = sr.i_ResourceID
AND sr.i_SiteID = s.i_SiteID
AND rp.i_ResourceID = r.i_ResourceID
AND s.s_Name ='retail2002'
AND rp.s_PropertyName = 's_WebServerMachine'



the result showed both of our names as being registered.

Stephen.





Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com