Error with Developer Toolbox Insert

[ASHLEYHAYWARD]

I'm getting an error when using the Developer Toolbox to create a record in the
database.

Error:
The root cause was that: java.sql.SQLException: Invalid authorization
specification: Access denied for user
'name'@'XX-XXX-XX-XXX.servers.dedipower.net' (using password: YES)

What I guess it's telling me is that the username and password arn't
specified, but I can't find anywhere to put it.

They are specified in the:
<cfquery name="Recordset1" datasource="name" username="name" password="name">

So all is fine there.

Can anyone help on this one?

[Nancy]

It's a permissions issue. In order to insert a record into the database,
you have to grant write privileges to the database .. check the Cold Fusion
Administrator.


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: Dreamweaver CS3: The Missing Manual,
DMX 2004: The Complete Reference, DMX 2004: A Beginner's Guide
Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"ASHLEYHAYWARD" <webforumsuser@macromedia.com> wrote in message
news:g562je$83k$1@forums.macromedia.com...

> I'm getting an error when using the Developer Toolbox to create a record
> in the
> database.
>
> Error:
> The root cause was that: java.sql.SQLException: Invalid authorization
> specification: Access denied for user
> 'name'@'XX-XXX-XX-XXX.servers.dedipower.net' (using password: YES)
>
> What I guess it's telling me is that the username and password arn't
> specified, but I can't find anywhere to put it.
>
> They are specified in the:
> <cfquery name="Recordset1" datasource="name" username="name"
> password="name">
>
> So all is fine there.
>
> Can anyone help on this one?
>
>
>