I have a vb com+ object that has a function that is supposed to return some XML from the database. It gets the XML via an ADO stream object. However, when I run the VB from its test harness in the project group it gives the following error;
MSXML3: Reference to undeclared namespace prefix: 'sql'.
My project references has;
MS ActiveX Data Objects 2.6 Library
MS XML v4.0
If I debug print the XML out it before writing it to the stream it gives ;
<ROOT xmlns:sql='urn:schemas-microsoft-com:xml-sql'><sql:header><sql:param name='ID'>
1
</sql:param></sql:header><sql:query>
exec sp100PaAddress_Select @.ID
</sql:query></ROOT>
"Richard P" <anonymous@.discussions.microsoft.com> wrote in message
news:3D95465D-CAD3-41CF-894E-B4077DF9B75C@.microsoft.com...
> I have a vb com+ object that has a function that is supposed to return
some XML from the database. It gets the XML via an ADO stream object.
However, when I run the VB from its test harness in the project group it
gives the following error;
> MSXML3: Reference to undeclared namespace prefix: 'sql'.
Try posting the code that is causing the error...
Bryant
Showing posts with label reference. Show all posts
Showing posts with label reference. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
MSSQLServerADHelper
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
|||ah thks .. I thought it might have been something that did not belong ....
-BB
"TJ" <tunj@.hotmail.com> wrote in message news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
|||ah thks .. I thought it might have been something that did not belong ....
-BB
"TJ" <tunj@.hotmail.com> wrote in message news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
MSSQLServerADHelper
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BBThis is a multi-part message in MIME format.
--=_NextPart_000_006B_01C4A28F.9FA9B9A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of =Microsoft=AE SQL ServerT 2000 relational database engine or Analysis =server in the Microsoft Windows=AE 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and =databases for that instance. The service is dynamically started by an instance of SQL Server or the =Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain =administration rights or that are running under the localsystem Windows =account. Few sites run their SQL Server service under either of these =types of accounts. A service application that does not perform network =administration, such as SQL Server, is rarely granted full domain =administration rights. The localsystem account cannot be given any =privileges on remote computers; therefore, running SQL Server under this =account would prevent much of the SQL Server distributed functionality =from working. The MSSQLServerADHelper service is run under the =localsystem account so that it can add and remove objects registering =SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single =service handles the Active Directory objects for all instances of the =SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message =news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone =know
what it is?
Thx in advance..
-BB
--=_NextPart_000_006B_01C4A28F.9FA9B9A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper =Service
The MSSQLServerADHelper service performs two functions: It adds and removes the objects used to register instances of =Microsoft=AE SQL Server=99 2000 relational database engine or Analysis server in =the Microsoft Windows=AE 2000 Active Directory=99.
It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory objects =for the instance, as well as any replication publications and databases for =that instance.
The service is dynamically started by an instance of SQL Server or =the Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain administration =rights or that are running under the localsystem Windows account. Few sites =run their SQL Server service under either of these types of accounts. A =service application that does not perform network administration, such as SQL =Server, is rarely granted full domain administration rights. The localsystem =account cannot be given any privileges on remote computers; therefore, running =SQL Server under this account would prevent much of the SQL Server =distributed functionality from working. The MSSQLServerADHelper service is =run under the localsystem account so that it can add and remove objects =registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. =The single service handles the Active Directory objects for all instances of =the SQL Server relational database engine and all Analysis Manager applications =running on the computer.
"Brian Burgess" =wrote in message news:O$JIN2poEHA.3392=@.TK2MSFTNGP15.phx.gbl...Hi all,I have a service installed on my Win2KAdvancedServer called'MSSQLServerADHelper'. I cannot find any reference to this. Anyone knowwhat it is?Thx in advance..-BB
--=_NextPart_000_006B_01C4A28F.9FA9B9A0--|||This is a multi-part message in MIME format.
--=_NextPart_000_000B_01C4A3B3.808BDE20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
ah thks .. I thought it might have been something that did not belong =...
-BB
"TJ" <tunj@.hotmail.com> wrote in message =news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of =Microsoft=AE SQL ServerT 2000 relational database engine or Analysis =server in the Microsoft Windows=AE 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and =databases for that instance. The service is dynamically started by an instance of SQL Server or the =Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain =administration rights or that are running under the localsystem Windows =account. Few sites run their SQL Server service under either of these =types of accounts. A service application that does not perform network =administration, such as SQL Server, is rarely granted full domain =administration rights. The localsystem account cannot be given any =privileges on remote computers; therefore, running SQL Server under this =account would prevent much of the SQL Server distributed functionality =from working. The MSSQLServerADHelper service is run under the =localsystem account so that it can add and remove objects registering =SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The =single service handles the Active Directory objects for all instances of =the SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message =news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. =Anyone know
what it is?
Thx in advance..
-BB
--=_NextPart_000_000B_01C4A3B3.808BDE20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
ah thks .. I thought it might =have been something that did not belong ...
-BB
"TJ" wrote in message news:eLJLfiroEHA.2684=@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for = MSSQLServerADHelper
MSSQLServerADHelper =Service
The MSSQLServerADHelper service performs two functions:
It adds and removes the objects used to register instances of =Microsoft=AE SQL Server=99 2000 relational database engine or Analysis server in =the Microsoft Windows=AE 2000 Active Directory=99.
It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and databases =for that instance.
The service is dynamically started by an instance of SQL Server or =the Analysis Manager when needed. The service is stopped as soon as it has = completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain administration =rights or that are running under the localsystem Windows account. Few =sites run their SQL Server service under either of these types of accounts. =A service application that does not perform network administration, such =as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote =computers; therefore, running SQL Server under this account would prevent much of =the SQL Server distributed functionality from working. The =MSSQLServerADHelper service is run under the localsystem account so that it can add =and remove objects registering SQL Server entities in the Active =Directory.
There is only one MSSQLServerADHelper service on a computer. =The single service handles the Active Directory objects for all instances =of the SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" =wrote in message news:O$JIN2poEHA.3392=@.TK2MSFTNGP15.phx.gbl...Hi all,I have a service installed on my Win2KAdvancedServer called'MSSQLServerADHelper'. I cannot find any reference =to this. Anyone knowwhat it is?Thx in advance..-BB
--=_NextPart_000_000B_01C4A3B3.808BDE20--
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BBThis is a multi-part message in MIME format.
--=_NextPart_000_006B_01C4A28F.9FA9B9A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of =Microsoft=AE SQL ServerT 2000 relational database engine or Analysis =server in the Microsoft Windows=AE 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and =databases for that instance. The service is dynamically started by an instance of SQL Server or the =Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain =administration rights or that are running under the localsystem Windows =account. Few sites run their SQL Server service under either of these =types of accounts. A service application that does not perform network =administration, such as SQL Server, is rarely granted full domain =administration rights. The localsystem account cannot be given any =privileges on remote computers; therefore, running SQL Server under this =account would prevent much of the SQL Server distributed functionality =from working. The MSSQLServerADHelper service is run under the =localsystem account so that it can add and remove objects registering =SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single =service handles the Active Directory objects for all instances of the =SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message =news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone =know
what it is?
Thx in advance..
-BB
--=_NextPart_000_006B_01C4A28F.9FA9B9A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper =Service
The MSSQLServerADHelper service performs two functions: It adds and removes the objects used to register instances of =Microsoft=AE SQL Server=99 2000 relational database engine or Analysis server in =the Microsoft Windows=AE 2000 Active Directory=99.
It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory objects =for the instance, as well as any replication publications and databases for =that instance.
The service is dynamically started by an instance of SQL Server or =the Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain administration =rights or that are running under the localsystem Windows account. Few sites =run their SQL Server service under either of these types of accounts. A =service application that does not perform network administration, such as SQL =Server, is rarely granted full domain administration rights. The localsystem =account cannot be given any privileges on remote computers; therefore, running =SQL Server under this account would prevent much of the SQL Server =distributed functionality from working. The MSSQLServerADHelper service is =run under the localsystem account so that it can add and remove objects =registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. =The single service handles the Active Directory objects for all instances of =the SQL Server relational database engine and all Analysis Manager applications =running on the computer.
"Brian Burgess"
--=_NextPart_000_006B_01C4A28F.9FA9B9A0--|||This is a multi-part message in MIME format.
--=_NextPart_000_000B_01C4A3B3.808BDE20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
ah thks .. I thought it might have been something that did not belong =...
-BB
"TJ" <tunj@.hotmail.com> wrote in message =news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of =Microsoft=AE SQL ServerT 2000 relational database engine or Analysis =server in the Microsoft Windows=AE 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and =databases for that instance. The service is dynamically started by an instance of SQL Server or the =Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain =administration rights or that are running under the localsystem Windows =account. Few sites run their SQL Server service under either of these =types of accounts. A service application that does not perform network =administration, such as SQL Server, is rarely granted full domain =administration rights. The localsystem account cannot be given any =privileges on remote computers; therefore, running SQL Server under this =account would prevent much of the SQL Server distributed functionality =from working. The MSSQLServerADHelper service is run under the =localsystem account so that it can add and remove objects registering =SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The =single service handles the Active Directory objects for all instances of =the SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message =news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. =Anyone know
what it is?
Thx in advance..
-BB
--=_NextPart_000_000B_01C4A3B3.808BDE20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
ah thks .. I thought it might =have been something that did not belong ...
-BB
"TJ"
According to Books Online: Search for = MSSQLServerADHelper
MSSQLServerADHelper =Service
The MSSQLServerADHelper service performs two functions:
It adds and removes the objects used to register instances of =Microsoft=AE SQL Server=99 2000 relational database engine or Analysis server in =the Microsoft Windows=AE 2000 Active Directory=99.
It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and databases =for that instance.
The service is dynamically started by an instance of SQL Server or =the Analysis Manager when needed. The service is stopped as soon as it has = completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain administration =rights or that are running under the localsystem Windows account. Few =sites run their SQL Server service under either of these types of accounts. =A service application that does not perform network administration, such =as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote =computers; therefore, running SQL Server under this account would prevent much of =the SQL Server distributed functionality from working. The =MSSQLServerADHelper service is run under the localsystem account so that it can add =and remove objects registering SQL Server entities in the Active =Directory.
There is only one MSSQLServerADHelper service on a computer. =The single service handles the Active Directory objects for all instances =of the SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess"
--=_NextPart_000_000B_01C4A3B3.808BDE20--
Subscribe to:
Posts (Atom)