I have CFMX7 developer on MACOSX 10.4 and I have recently installed MySQL5. I have built a database in MySQL so I know it's working and I have used CFMX7 and that works, but (after pouring through posts) cannot get the ColdFusion administrator to verify the connection. Is there any hope of getting this combination to work? I thought about using MySQL 3.xx so I can use the built-in driver in ColdFusion, but it looks crazy to install. I'm a newbie. I also tried the solution from the adobe technote (http://www.adobe.com/cfusion/knowledgebase/ index.cfm?id=tn_19170), but where to put the "mysql-connector- java-3.1.10-bin.jar" file <-- (see technote from adobe below) is unclear to me on a mac.
These are the instructions from the knowledge base from Adobe: ----------- begin instructions from adobe -------------- Download the desired version of MySQL Connector/J from the MySQL download site. Extract the JDBC driver JAR file. For example: mysql-connector-java-3.1.10-bin.jar. Place the JAR file in the ColdFusion Class Path: Server Configuration: Place the mysql-connector-java-3.1.10-bin.jar in cf_root/wwwroot/WEB-INF/lib J2EE Configuration: Place the mysql-connector-java-3.1.10-bin.jar in cf_web_root/WEB-INF/lib Restart ColdFusion MX. Use the ColdFusion MX Administrator Data Sources page to add a new data source for the MySQL Connector: For example: Name the data source MySQL_test when it will connect to the test database. Note: There is a test database installed by default in the MySQL server. Select Other in the driver field to tell ColdFusion you will describe another type of driver. Click Add to add the data source and display the default driver window for this driver. Enter the following in the JDBC URL field: jdbc:mysql://localhost:3306/test Where localhost is the name of the database server. Where 3306 is the port number for the data source connection. Where test is the database name. Note: The information in this field is case-sensitive. Enter the following in the Driver Class field: com.mysql.jdbc.Driver Note: The information in this field is case-sensitive. Enter a valid username and password in the Username and Password fields. Where the username and password are defined as user account information on the database server. (Optional) Enter the name of the driver in the Driver Name field. Click submit to apply the changes to the data source. ----------- end from adobe -------------- This didn't work. How do I know if I have a server configuratiuon or a J2EE configuration? I put the "mysql-connector-java-3.1.10-bin.jar" file into /Applications/ColdFusionMX7/wwwroot/WEB_INF/lib and had no luck. Where is cf_root/wwwroot/WEB-INF/lib??? Any help is very much appreciated! I am new to this. Any other free DB recommended that is easier to hook into CFMX7 on a mac? I want to develop on my mac and only have experience using CF on a PC with Access. Thank you, John Cardwell | 425 750-5557 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2570 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
