for transactions to work CF mustt be able to serially process each query
with the same connection. It cannot do this if anything about the connection
is different. Make sure all cfquery tags have same datasource [usernname and
password] attribute values. user/password not normally required for
MSAccess, so remove attributes all together. Also remove dbtype attribute
which is depreciated from 4.5 - >6.1. Name attribute is not relevant to this
issue and is nort needed unless the query returns results you want.
so should look like this
<cftransaction>
<cftry>
<cfquery datasource="toolshed" >
Insert...
</cfquery>
<cfquery datasource="toolshed">
update
</cfquery>
<cfquery datasource="toolshed">
delete
</cfquery>
<cftransaction action="commit" />
<cfcatch>
<cftransaction action="rollback" />
<cfcatch>
</cftry>
</cftransaction>
"Matthew Doepel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
>
> 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
