Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

DW8 -MySQL - CF

New Here ,
Apr 03, 2007 Apr 03, 2007
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
TOPICS
Server side applications
373
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 03, 2007 Apr 03, 2007
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
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 03, 2007 Apr 03, 2007
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
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 03, 2007 Apr 03, 2007
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


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 03, 2007 Apr 03, 2007
LATEST
Thanks again Brendon

Larry
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines