• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1077
  • Last Modified:

odbc proxy, connect through a middle point

I need to query a database on  remote Server-C  and bring it to a warehouse on Server-A.  Server-C will only allow connections from Server-B due to network constraints.  Server-B has a system DSN pointing to the database on Server-C over ODBC.

The network constraints are being addressed but I need an interim solution.  I can not make network updates at this time.

I'm using Cognos Datamanager on server A.  My query request will originate on ServerA.  Ideally, I would issue an odbc request from Server-A and Server-B would echo this request to Server-C.  I have no control over Server-C.  I could potentially install freeware on Servers A,B but I will not be able to run Cognos DataManager on server B.

Server A is running MS SQL Server 2005.  Server B might be as well, I don't know this yet.

Any ideas?
0
lovingatx
Asked:
lovingatx
  • 2
1 Solution
 
Jim P.Commented:
On Server B create a linked server to Server C.

Then have a stored procedure of
-----------------------------------------
CREATE CP_Query_Server_C
AS
SELECT *
FROM openquery( Server_C_Link, 'Select * from MyDB.dbo.MyTable');
-----------------------------------------
Then on Server A create a link to the Server B and
do
CREATE VIEW Server_C_View
AS
SELECT *
FROM openquery( Server_B_Link, 'EXEC CP_Query_Server_C');
------------------------------------------

This is a guess but it might work.
0
 
lovingatxAuthor Commented:
Turned out that MS SQL was not installed so I couldn't try your solution.  Thanks for the input though.
0
 
Jim P.Commented:
Thanks.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now