Yeah... that's a good idea change your < and > in <cfquery> and </cfquery> to <: and > temporarily, and wrap the whole thing in a cfoutput. That'll show you the text of exactly what's being sent to the datasource as is and in place.
The thing is, if CF Admin gave you an OK, you know the file is accessible, that you've got the right username and password, and that the JDBC access driver is working... so also make sure you DSN matches! I've done that... wasted 3 hours fixing a "problem" only to find out that it's a typo in the DSN. UGH. Good luck, keep us posted. J On Mon, 28 Feb 2005 14:24:02 +0000, Thomas Chiverton <[EMAIL PROTECTED]> wrote: > On Monday 28 Feb 2005 14:06 pm, GM wrote: > > Any other ideas? > > Dump the app vars just before the call. > Maybe they aren't being set. > > -- > Tom Chiverton > Advanced ColdFusion Programmer > -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:196779 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
