I assume you're only connecting to the one DB within CFTRANSACTION, and that you have application scope variables for all the CFQUERY connection parms? And does the DSN verify password-less on your administrator?
If so, I believe if you use the DSN set-up in your administrator and that verifies then you only need to supply the DSN name on CFQUERY, perhaps passing blanks for username and password is handled differently? Thinking about it, this depends on DB also I think, which DB are you connecting to? ----- Original Message ----- From: "Matthew Doepel" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, April 01, 2004 11:35 AM Subject: [cfaussie] CFTRANSACTION Problem > I have had to run a clients appliction (prev Ver 4.5) on my server Cold > Fusion MX Ver 6 > > I now get an error message: > Error Report > Data source toolshed verification failed. The root cause was that: > java.sql.SQLException: Usernames and Passwords for all the database tags > within CFTRANSACTION must be the same. > The error occurred on line 66. > > The database has no usename or password. > > Any suggestions, I appreciate any help on this. > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
