I tried it and got pretty far. Unfortunately, I got a "Optional feature not implemented" error when I tried to use the getColumns() method. So I guess that method isn't supported for MS Access.
I guess I will look into the CFMX7 Administrator API. I am trying to work on a solution that woould work for CFMX 6.1 and above and the API doesn't look promising for this problem at a glance. so... If anyone has any more thoughts I would be grateful. As, indeed, am I for all of the thoughts thus far. Thanks! Steve >I had problems getting it to work with Access originally... and then >someone posted a comment on the article on the sys-con site with a >fix, which turned out to be hideously simple... I had been passing >username/password to connect to the db, and with Access you just omit >those arguments... What threw me was that it appeared according to the >JDBC docs that the un/pw arguments were required, so it never occurred >to me to simply omit them. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:216300 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
