DW8 -MySQL - CF

Larry - you might need to provide some info on the error you are getting.
You said you can create a connection in the CF Admin - you successfully set
up a DSN? You can view the database through command line, or a GUI (like
Navicat) - to see the DB exists, and is functioning?
Have you set the DSN in the application.cfm file? Is your site defined
correctly?
hth.
Brendon

"LIB" <webforumsuser@macromedia.com> wrote in message
news:euu0hj$3ef$1@forums.macromedia.com...
> I've installed the CF Server on the Mac, established a MySQL database
> connection in the CF Administrator. I have the MySQL server loaded and
> running and can connect to it easily with Cocoa.
>
> I've installed DW on the Mac and set up my Files.
>
> The problem is that I can't establish a connection to the MySQL
> databases. they do show up in the Database window of DW but I can't
> connect to them. A box pops up asking for User Name and Password for
> the CF Administrator even though I have eliminated that.
>
> If I try to establish a new new database connection with the + button in
> the Database window and enter the information that I use with Cocoa to
> access the database - I get the window asking for the connection data.
> When I try to either TEST or OK it - nothing happens. The only button
> that seems to work is the CANCEL.
>
> I've gone over this for hours but still can't get the connection. When
> I try the Bindings I get a long error message about MySQL syntax errors
>
> Any suggestions? Any help would be appreciated.
>
> Thanks
> Larry
>