how to query database through proxy

Hi,
I want to know what is the name of the manager used in
MSSQL Server 2000 that queries a database through a proxy.
The name of that manager in Oracle is Connection manager.
"Daniela Tsigarovska" <danielat@.ramstore.bg> wrote in message
news:40be01c42b6a$09024d10$a601280a@.phx.gbl...
> I want to know what is the name of the manager used in
> MSSQL Server 2000 that queries a database through a proxy.
> The name of that manager in Oracle is Connection manager.
There is no dedicated manager in SQL Server 2000 to do this... Custom
applications typically use IIS and/or ISA Server to interface between the
public and private networks.
Steve

how to query database through proxy

Hi,
I want to know what is the name of the manager used in
MSSQL Server 2000 that queries a database through a proxy.
The name of that manager in Oracle is Connection manager."Daniela Tsigarovska" <danielat@.ramstore.bg> wrote in message
news:40be01c42b6a$09024d10$a601280a@.phx.gbl...
> I want to know what is the name of the manager used in
> MSSQL Server 2000 that queries a database through a proxy.
> The name of that manager in Oracle is Connection manager.
There is no dedicated manager in SQL Server 2000 to do this... Custom
applications typically use IIS and/or ISA Server to interface between the
public and private networks.
Steve

How to query a remote server from sql 2005

Ok,,im stuck.
I can access a remote 2000 sql server from sql 2005. I connect directly to
the 2000 database ok. I can run queries on it all day.
I can do the same thing with another remote ODBC server with SQL2005.
THe question is how do you login to SQL2000 from sql 2005 and yet still be
able to run queries on the other remote ODBC server?
--
HarryTry using opendatasource which will accept a connection string to access the
remote server.
--
"Harry" wrote:

> Ok,,im stuck.
> I can access a remote 2000 sql server from sql 2005. I connect directly t
o
> the 2000 database ok. I can run queries on it all day.
> I can do the same thing with another remote ODBC server with SQL2005.
> THe question is how do you login to SQL2000 from sql 2005 and yet still be
> able to run queries on the other remote ODBC server?
> --
> Harry|||Create linked servers and use openquery() method.
"Omnibuzz" wrote:
> Try using opendatasource which will accept a connection string to access t
he
> remote server.
> --
>
>
> "Harry" wrote:
>|||Create linked servers and use OpenQuery() method
"Harry" wrote:

> Ok,,im stuck.
> I can access a remote 2000 sql server from sql 2005. I connect directly t
o
> the 2000 database ok. I can run queries on it all day.
> I can do the same thing with another remote ODBC server with SQL2005.
> THe question is how do you login to SQL2000 from sql 2005 and yet still be
> able to run queries on the other remote ODBC server?
> --
> Harry