all groups > sql server dts > march 2007 >
You're in the

sql server dts

group:

xmldom connection


xmldom connection Not Me
3/6/2007 12:00:00 AM
sql server dts:
Hi there,

I have an activex script which loads up an xml file over http and
transforms the results into a table held on the database.

I'm not sure of all the technical nitty gritty (neither are the admins..)
so hopefully someone here can help with my problem..

The problem is, I would like the server which serves (!) the xml page to
limit connections to just the database server, and myself.. probably this
will be done by limiting to the ip address.

I'm told the database connects to the web through a proxy.. and this
confuses the server as to which ip address the request is coming from. Is
it possible to force the server to make a direct connection to the page
that is serving the xml?

Any other suggestions considered..

Thank you,
Re: xmldom connection Simon Sabin
3/6/2007 4:07:33 PM
Hello Not,

This is a question from who ever manages your networks.

The other option is to enforce some security on the download of the page.

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


[quoted text, click to view]

AddThis Social Bookmark Button