Friday, March 30, 2012
Load data from web page into sp (sql2000)
procedure using just a web address? The data will just be text/xml or
some such.
cheers,
ChrisHello Chris,
Not easily sorry.
Easy in SQL 2005 with a CLR function.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> Hi, using sql server 2000, is there a way I can load data into a
> stored procedure using just a web address? The data will just be
> text/xml or some such.
> cheers,
> Chris|||Simon Sabin wrote:
> Not easily sorry.
> Easy in SQL 2005 with a CLR function.
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
Thanks Simon.. I'm currently figuring it out using ado in an activex
script... would probably do it quicker upgrading to 2005 :D
cheers,
Chris
Load data from web page into sp (sql2000)
procedure using just a web address? The data will just be text/xml or
some such.
cheers,
Chris
Hello Chris,
Not easily sorry.
Easy in SQL 2005 with a CLR function.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> Hi, using sql server 2000, is there a way I can load data into a
> stored procedure using just a web address? The data will just be
> text/xml or some such.
> cheers,
> Chris
|||Simon Sabin wrote:[vbcol=seagreen]
> Not easily sorry.
> Easy in SQL 2005 with a CLR function.
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
Thanks Simon.. I'm currently figuring it out using ado in an activex
script... would probably do it quicker upgrading to 2005 :D
cheers,
Chris
Monday, March 26, 2012
Live communication Address book service
Hi, when I try to activate my address book, i get the error "There is no pool available for this operation. Exit the wizard. (Error Code: 0xc3EC78D9)".
I have verified my mmc shows that LCS is at SP1, it is activated, and
functioning properly (users able to interact via OC2005). It is locally
installed on the standard edition server.
As per the Technet reference :
Possible causes include:
The Live Communications Server service is not running on the pool or server.
No servers or pools in your topology have been upgraded to Service Pack 1.
The Standard Edition Server is not activated, or none of the Enterprise Edition Servers within a pool are activated. Check your servers.
You want to run the Address Book Service on a Standard Edition Server, but you have installed the Address Book Service on a separate computer. The Address Book Service must be installed locally on a Standard Edition Server to work in this deployment.
Live communication Address book service
Hi, when I try to activate my address book, i get the error "There is no pool available for this operation. Exit the wizard. (Error Code: 0xc3EC78D9)".
I have verified my mmc shows that LCS is at SP1, it is activated, and
functioning properly (users able to interact via OC2005). It is locally
installed on the standard edition server.
As per the Technet reference :
Possible causes include:
The Live Communications Server service is not running on the pool or server.
No servers or pools in your topology have been upgraded to Service Pack 1.
The Standard Edition Server is not activated, or none of the Enterprise Edition Servers within a pool are activated. Check your servers.
You want to run the Address Book Service on a Standard Edition Server, but you have installed the Address Book Service on a separate computer. The Address Book Service must be installed locally on a Standard Edition Server to work in this deployment.
What about that same error in Office Communications Server 2007? I get that same error code when trying to set up my edge server.
Wednesday, March 21, 2012
Listening IP address
I'm running MS SQL 2000 on Windows 2000 adv srv with 2 network adapters on
it .
How can I configure MS SQL to listen from one IP address and don't listen
from another?
Thanks,
LeonidYou can't do this with SQL. You could block the port on the adapter using
IPSEC
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Leonid" <le_le_to@.hotmail.!!!NO-SPAM!!!.com> wrote in message
news:qJGdnZeQApEvx5Xd4p2dnA@.comcast.com...
> Hi,
> I'm running MS SQL 2000 on Windows 2000 adv srv with 2 network adapters on
> it .
> How can I configure MS SQL to listen from one IP address and don't listen
> from another?
> Thanks,
> Leonid
>sql
Listening IP address
I'm running MS SQL 2000 on Windows 2000 adv srv with 2 network adapters on
it .
How can I configure MS SQL to listen from one IP address and don't listen
from another?
Thanks,
LeonidYou can't do this with SQL. You could block the port on the adapter using
IPSEC
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Leonid" <le_le_to@.hotmail.!!!NO-SPAM!!!.com> wrote in message
news:qJGdnZeQApEvx5Xd4p2dnA@.comcast.com...
quote:|||By default you can't do this. You could put the SQL Server behind an ISA
> Hi,
> I'm running MS SQL 2000 on Windows 2000 adv srv with 2 network adapters on
> it .
> How can I configure MS SQL to listen from one IP address and don't listen
> from another?
> Thanks,
> Leonid
>
server (firewall) and only publish the IP that you need.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Listening IP address
I'm running MS SQL 2000 on Windows 2000 adv srv with 2 network adapters on
it .
How can I configure MS SQL to listen from one IP address and don't listen
from another?
Thanks,
LeonidYou can't do this with SQL. You could block the port on the adapter using
IPSEC
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Leonid" <le_le_to@.hotmail.!!!NO-SPAM!!!.com> wrote in message
news:qJGdnZeQApEvx5Xd4p2dnA@.comcast.com...
quote:
> Hi,
> I'm running MS SQL 2000 on Windows 2000 adv srv with 2 network adapters on
> it .
> How can I configure MS SQL to listen from one IP address and don't listen
> from another?
> Thanks,
> Leonid
>
Friday, March 9, 2012
List of IP Address
I want to get list of IP address of all servers registered in my server
group
How can I get this
Thanks
AM wrote:
> Hi, all Gurus
> I want to get list of IP address of all servers registered in my
> server group
> How can I get this
> Thanks
You can ping each server from the console and see the IP address (the
server will have to be listening on TCP-IP). From console:
ping <server_name>
David Gugick
Imceda Software
www.imceda.com
List of IP Address
I want to get list of IP address of all servers registered in my server
group
How can I get this
ThanksAM wrote:
> Hi, all Gurus
> I want to get list of IP address of all servers registered in my
> server group
> How can I get this
> Thanks
You can ping each server from the console and see the IP address (the
server will have to be listening on TCP-IP). From console:
ping <server_name>
David Gugick
Imceda Software
www.imceda.com
List of IP Address
I want to get list of IP address of all servers registered in my server
group
How can I get this
ThanksAM wrote:
> Hi, all Gurus
> I want to get list of IP address of all servers registered in my
> server group
> How can I get this
> Thanks
You can ping each server from the console and see the IP address (the
server will have to be listening on TCP-IP). From console:
ping <server_name>
David Gugick
Imceda Software
www.imceda.com