It's an MS Access Database and ALL other functions on the site are working correctly ie: searching, emailing, uploading etc, The problem only lies when a credit card payment is submitted for the product purchased.. The original developer is unable to assist. The DSN is configured in GlobalApps.cfm and Application.cfm files.
I may have to install Ver4.5 to verifiy if it's a Version issue. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Faulkner Sent: Thursday, 1 April 2004 11:47 To: CFAussie Mailing List Subject: [cfaussie] Re: CFTRANSACTION Problem 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 --- 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
