Showing posts with label address. Show all posts
Showing posts with label address. Show all posts

Friday, March 30, 2012

Load data from web page into sp (sql2000)

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,
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)

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

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

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,
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
>
|||By default you can't do this. You could put the SQL Server behind an ISA
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

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

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

Hi, all Gurus
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

Hi, all Gurus
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