Couldn't you in theory use a excel JDBC driver instead of the ODBC/ODBC socket route?
Have a look at https://xlsql.dev.java.net/ I have never tried it personally but it would be well worth investigating hth Mark PS If all else fails you can also fallback on asp/vb etc, which although painful do work well with Excel via ODBC -----Original Message----- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: 06 May 2005 08:47 To: CF-Talk Subject: Re: Excel sheet datasource in CFMX7 It won't work by going in to CFAdmin, hitting Datasources, setting the New Datasource Type popup to ODBC and configuring it with the DSN of your OS-based ODBC DSN? I guess I hadn't considered that the ODBC connector from within CFAdmin was dependent on the ODBC agent... if you've tried it and it doesn't work, I can't think of a workaround right off the top of my head... I'll give it some more thought, though... J On 5/6/05, Duncan <[EMAIL PROTECTED]> wrote: > > Ok I get where you are coming from and I would think that if the CF > ODBC agent was installed and running it would probably work. > > Unfortunately this server doesnt have the CF odbc agent. Any other > ways around this without installing the odbc agent? > > > On 5/6/05, Jared Rypka-Hauer - CMG, LLC <[EMAIL PROTECTED]> wrote: > > After setting up the OS-based ODBC datasource, you WILL need to go > > into > CF > > Admin and create a CFMX DSN that points to your ODBC DSN by name, > > and > supply > > the appropriate (if necessary) credentials. > > > > That is, you create an ODBC DSN via the Windows Control Panel and > > after > that > > a CF Administrator DSN that points to the original ODBC DSN. It's > confusing > > until you do it once. Don't hesitate to ask further questions. :) > > > > Laterz, > > J > -- --------------- ------------------------------------- Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205827 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
