My favorite when I know I'm working with a limited set of users (preferably just me!) and the data I am trying to retrieve is from a CF site that I control, is to use VBA and XMLHTTP which is part of the MSXML parser. It can request a URL and put the XML that is sent back right into a XML DOM object. I'm still working on XL2000, so I haven't had a chance to try out the ability in 2002 to consume web services.
Dan -----Original Message----- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 1:08 PM To: CF-Talk Subject: Re: Can CF talk to a ODBC compliant db via an ISDN line. Along these same lines, is there some way to have an excel spreadsheet on a remote users desktop, periodically request and import data from a remote web/db server? Would this be an appropriate job for a web service which spits out XML data? At 12:34 PM 26/08/02 -0700, you wrote: >Definitely possible! I used to do this all the time when working from home, >with CF on my home computer and the SQL Server databases at work. > >There are not many tricks to it. Just make sure the database connection is >set up right. I always used ODBC, but I don't think you have to. I used >the ODBC control panel. I do remember a switch on the setup panel that let >me use domain names or TCP ports to reference the database and sometimes it >worked one way, sometimes it worked the other way. Whatever made the "test >database connection" work right. > >Have fun! > >Jevo > >On 8/20/02 8:09 AM, "Kodjo Ackah" <[EMAIL PROTECTED]> wrote: > > > My client has a sql DB server abroad that he connects to via an ISDN > > line to check status information of a cash transfer. > > His inhouse system built in VB does this.Qusetion is - is it possible to > > get CF to do the same? Any ideas as to how to proceed. > > > > Kodjo asks! > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
