all groups > sql server connect > may 2007 >
You're in the

sql server connect

group:

Looking for a tool within 2005 similar to Oracle Connection Manage


Looking for a tool within 2005 similar to Oracle Connection Manage Jason
5/3/2007 1:59:00 PM
sql server connect:
I would like to know if there is a comparable tool in SQL Server 2005 to the
ORacle Connection Manager (link provided to Overview below)
Re: Looking for a tool within 2005 similar to Oracle Connection Manage William (Bill) Vaughn
5/3/2007 2:46:34 PM
SQL Server connections are handled by the client and the server in entirely
different ways. There is no equivalent to this unless you count the SQL
Server Surface Area Configuration Utility or Configuration Manager
utilities.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Re: Looking for a tool within 2005 similar to Oracle Connection Ma Jason
5/3/2007 3:44:02 PM
Here is my situation. I require a database link from either a web app or
other db system, which are on the outside of two firewalls, to my SQL Server
2005 db which is inside the 2nd firewall. The Oracle Connection Manager acts
as sort of a proxy server and sits in the middle of the two firewalls. The
client may make requests to the CM and the CM has the ability to communicate
with the Oracle database. Since the CM and the client or other db mngmt
system are configured to talk on the same port, the request can be handled
and the data passed from the CM to where the request originated. Anything in
the Windows world that accomplishes this?



[quoted text, click to view]
Re: Looking for a tool within 2005 similar to Oracle Connection Ma stcheng NO[at]SPAM online.microsoft.com
5/4/2007 12:00:00 AM
Hi Jason,

As for the Oracle connection manager like tool, I'm afraid there is no
direct equivalent one for SQL Server 2005. I think such a "connection
manager" is completely a separate intermediate service/program which should
be separate from database engine. So far SQL Server hasn't provided a
built-in one

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.
Re: Looking for a tool within 2005 similar to Oracle Connection Ma DAVID
7/24/2007 12:00:00 AM
I think SQL Server might be able to do that - answer on one
port, pass an authenticated request on to another server,
pass the data back.

Look for information on 'linked servers' perhaps?


[quoted text, click to view]
AddThis Social Bookmark Button