J Have you looked at kbmMW?
http://www.components4programmers.com/products/kbmmw/index.htm N ----- Original Message ----- From: "vss" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 10:54 AM Subject: [DUG]: Some Ideas? > 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/ > > --------------------------------------------------------------------------- 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/
