The workaround is to use a valid DSN in the CFQuery tag, even if you are not querying that DB
The syntax to use is <cfquery name="queryname" datasource="Any_Valid_DSN_Name_which_points_to_another_DB"> select id from "fullpathname to Access DB".tblTable </cfquery> This does work on CFMX. paddy ----- Original Message ----- From: "Stephen Moretti" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 11:03 AM Subject: Re: [ cf-dev ] More than one datasource in one query > Rich, > > Remember that CFMX apparently doesn't support DSNless connections anymore. > > So this would be a problem when upgrading from CF5 as far as I understand. > > > This workaround that Giles is using (which is a CF3/CF4 bodge) might work in > CFMX, but I don't have MX here to test it out.... Of course the JDBC > drivers may screw this too, as this is the reason why DNSless connections > were dropped from CFQUERY in MX. > > Neil, > > yep, I seem to remember that they were dropped; though I also remember a > > workaround of some sorts..... cant remember where though ... > > > Guessing.... That might be the workaround that Giles is using... > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
