Hi Gregory, I host for emergency services and was having ODBC connection issues big time. I was able to speak with a Gold Level Tech Support person at Abobe who gave the following solution to my connection issue, and advised this is more stable. I followed the suggestion provided and my connection issues went away completely.
If you have access to the CF Administrator, go into the adding a datasource section and do the following. >From the drive pulldown form field, select "Other". On the next screen enter the following: JDBC URL: jdbc:mysql://localhost:[port number]/[database name] Driver Class: com.mysql.jdbc.Driver and then anyother pertinent information that you need (username/password, etc) I cannot guarantee this will take care of your issue, but I was getting really frustrated with the connection issue until I implemented the above and now have zero(0) ODBC connectivity issues. Leonard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4771 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
