cftransaction causes login failed for user '(null)'

[j9]

CFMX 6.1,Win2k,IIS5

When using cftransaction tags, I receive the following warning in the CF application.log file: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

It is only a warning and does not prevent my queries from executing. A corresponding error is found in my SQL Server log. The problem disappeared when I removed the cftransaction tags.

Does anyone know of any problems with cftransaction?

Thanks!

 

[CFMSACCESS]

Can you post the lines of code for this page?
What attributes of cftransaction are you using?

http://www.GracefulWebDevelopment.com

 

[j9]

It happens on every page that uses cftransaction, regardless of the cftransaction attributes that are used.

Also, I forgot to note that the problem does NOT happen if the database username and password are set in the CF Administrator instead of within the <cfquery> tag.

Here's some code:
<CFTRANSACTION>
<CFQUERY NAME=&quot;qUpdate&quot; DATASOURCE=&quot;#myDataSource#&quot; USERNAME=&quot;#myLogin#&quot; PASSWORD=&quot;#myPassword#&quot;>
UPDATE Student
SET NameLast = '#form.NameLast#',
NameFirst = '#form.NameFirst#',
NameMiddle = '#form.NameMiddle#'
</CFQUERY>
</cftransaction>