DW8 -MySQL - CF

[LIB]

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

[Newsgroup_User]

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
>

[LIB]

Thanks Brendon

I did get the problem solved. It involved the MySQL connector file from here
http://dev.mysql.com/downloads/connector/j/3.0.html

Larry

[Newsgroup_User]

Oh sorry, that was the last thing I was going to suggest - the native
version 4 and 5 connectors don't work - you need to downgrade to version
3.1.x

Glad you are sorted.
Brendon

"LIB" <webforumsuser@macromedia.com> wrote in message
news:euuhsd$p3e$1@forums.macromedia.com...
> Thanks Brendon
>
> I did get the problem solved. It involved the MySQL connector file from
> here
> http://dev.mysql.com/downloads/connector/j/3.0.html
>
> Larry

[LIB]

Thanks again Brendon

Larry