DW, JSP, MySQL and Mac OSX

[V64]

I have so far been unable to set up a connection in DW to MYSQL on my Mac, as a localhost server

I have been able to set up and test a connection using Mac's ODBC Administrator (using a MySql driver), and I have been working OK with Cold Fusion.

I have also installed Apache-Tomcat and can run a test JSP page (without any Database Connections) in DW. So I know the 'basics' are kind of there.

The Apache Support Documentation suggests (by ommision) that DW only supports JSP on a PC with Microsoft's SQL.

Has anyone know how to do this? I am a complete newbie to Java, but I have installed mysql-connector-jar-5.1.6-bin.jar, in /Library/java/extensions, but is this relevant?

Thank-you all

David Huxtable

[Newsgroup_User]

V64 wrote:
> I have so far been unable to set up a connection in DW to MYSQL on my Mac, as a
> localhost server

If you're using Leopard, just Google "MySQL Leopard". You'll find
gazillions of references to the fact that Leopard puts the mysql.sock in
a non-standard location. There are several different ways of solving the
problem. Choose the one that suits you best.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[V64]

Thank-you David for such a quick response - I am not using Leopard - but your reply encourages me to believe that I should be able to get this combo to work on OSX 10.4.

mysqladmin version tells me that my mysql.sock is in /tmp.

Thank-you

David H