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 On 5/6/05, Michael Bramwell <[EMAIL PROTECTED]> wrote: > > If your using a windows box i reckon you can install the excel datasource > as > an obdc datasource without using cf admin > start -> control panel -> administrative tools -> datasources (obdc) -> > system dsn -> add -> choose microsoft excel driver -> next steps are > pretty > obvious. > > Haven't tried this for excel files but have had success with access > databases via this method. > -- --------------- ------------------------------------- Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205822 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
