Morning... I've just been given the dubious pleasure (?!?!) of spending a day next week showing has a customer's existing database can be neatly integrated into a CMS.
Their current DB is MSSQL - I'm not a Microsoft person (haven't touched ASP/MSSQL for, oooh about 4 years), but if I remember correctly I can use DTS as a scheduled task on MSSQL to FTP the appropriate information from the DB server (inside the firewall) to the webserver (outside), which then parses the info and updates the site. The other option is to open up a non-standard port through the firewall, which I can connect to from the webserver with a user with limited permissions etc to say run a SP to get back the appropriate information. Any advice on which optino to choose? Considering this is only a pilot-type thing to show it can be done... Tim. ------------------------------------------------------- Try the ColdFusion Coding Contest! Current contest: Maze Solver - http://tech.badpen.com/cfcontest/ ------------------------------------------------------- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
