Simple answer to this, (1). never thought about it, and (2). Citrix means I dont have to do ANY exta work. Ok, Citrix means a Lic. for each connection, but my boss is happy to wear this cost. Its cheaper than me redeveloping a solution that would have to be maintained in 2 places. :-)
Jeremy -----Original Message----- From: "Stephen Bertram" <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Thu, 31 Jul 2003 12:26:36 +1200 Subject: RE: [DUG]: Some Ideas? > Why not use IIS linked through to your SQL Server and get the result as > = > a XML stream via HTTP? > > You can use IIS security and even HTTPS if required. Just use > "Configure = > XML Support in IIS" from the SQL Server menu to set it up. > > Stephen > > -----Original Message----- > From: vss [mailto:[EMAIL PROTECTED] > Sent: Thursday, 31 July 2003 10:55 a.m. > To: Multiple recipients of list delphi > 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=20 > our IPNetwork, which means we can open up port 1433 for MS SQLServer > to=20 > ONLY these people. > BUT with some changes that are in the wings we will need to provide > the=20 > APP. to people who wont connect us. This means they will not be part > of=20 > our IPNetwork and therefore wont be able to connect to port1433 for > SQL=20 > Server. > There is quite a bit of data that needs to be passed around, and XML=20 > looks promising, but after 2 days of looking and trying and testing, I > = > am=20 > kinda going off it. > The only promising part IS, that I can use an ADOTable for instance > and=20 > 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=20 > 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=20 > sent to, which fires off a Delphi COM obj. that has an ADOQuery > object=20 > and an ADOTable object so you run a query via the control, save it > to=20 > file, the send the contents of the file back to the APP. which can > then=20 > be loaded into the ADOTable in the app. and all is happy. BUT this as = > you=20 > can tell is kinda messy. > > Can anyone else suggest another alternative? other than Soap etc. as > we=20 > cant really open ports up as the info is VERY sensitive.=20 > oh PS. the XML is also encrypted before it goes and decrypted on the=20 > 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/ > Disclaimer : This communication contains information that is = > confidential and the copyright of enSynergy Limited or a third party. > If = > you are not the intended recipient of this communication please delete > = > and destroy all copies and telephone enSynergy Limited on +64 9 9205441 > = > immediately. If you are the intended recipient of this communication > you = > should not copy, disclose or distribute this communication without the > = > authority of enSynergy Limited. Any views expressed in this = > Communication are those of the individual sender, except where the = > sender specifically states them to be the views of enSynergy Limited. = > Except as required by law, enSynergy Limited does not represent, > warrant = > and/or guarantee that the integrity of this communication has been = > maintained nor that the communication is free of errors, virus, = > interception or interference. > > ----------------------------------------------------------------------- > ---- > 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/
