Hi All.
We have a project that we need to expand out to other locations.
Currently, we have certain client sites who connect to us and are part of
our IPNetwork, which means we can open up port 1433 for MS SQLServer to
ONLY these people.
BUT with some changes that are in the wings we will need to provide the
APP. to people who wont connect us. This means they will not be part of
our IPNetwork and therefore wont be able to connect to port1433 for SQL
Server.
There is quite a bit of data that needs to be passed around, and XML
looks promising, but after 2 days of looking and trying and testing, I am
kinda going off it.
The only promising part IS, that I can use an ADOTable for instance and
save teh record to an XML file, and load in from an XML file, BUT it has
to contain all the record source/set info and is kinda special looking.
This mean that I cant use FOR XML in the SQL statement to export the data
to XML as it cant be loaded my an ADOTable.
The solution that I thought if was to have a webpage that a request is
sent to, which fires off a Delphi COM obj. that has an ADOQuery object
and an ADOTable object so you run a query via the control, save it to
file, the send the contents of the file back to the APP. which can then
be loaded into the ADOTable in the app. and all is happy. BUT this as you
can tell is kinda messy.
Can anyone else suggest another alternative? other than Soap etc. as we
cant really open ports up as the info is VERY sensitive.
oh PS. the XML is also encrypted before it goes and decrypted on the
client..BTW
Cheers,Jeremy
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
