Re: Error with Developer Toolbox Insert

["Nancy" <nancy@xxxxxxxxxxx>]

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@xxxxxxxxxxxxxx> wrote in message 
news:g562je$83k$1@xxxxxxxxxxxxxxxxxxxxxxxx
> 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?
>
>
>