MySQL ODBC Connections After Upgrade to CFMX 7

Posted on 2005-04-21
Medium Priority
Last Modified: 2013-12-24
We are at the beginning stages of upgrading our servers from ColdFusion 5 to CFMX 7.  We are running Windows 2000 and IIS with all patches and Service Packs installed.  Our database is MySQL.  In CF5, to connect to MySQL, we simply create the DSNs on Windows and CF detected them, listed them in CFAdmin, and used them without a problem.

After upgrading the system, all the MySQL connections were converted to ODBC Socket Drivers.  My understanding was this meant it was simply "connected" to the Windows ODBC list and would use the appropriate drivers.  However, we can not get CFMX 7 to connect using this driver.  The error we receive is:

Connection verification failed for data source: db-test
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.

We have verified all passwords are correct and we can still connect through the Windows control panel.  For now, all ports are open until we get this fixed.

If we delete the datasource from CFAdmin and re-enter it using the built-in CF MySQL driver, the connection will then work with no problem.  However, I'd like to figure out why the ODBC Socket driver does not work.

Lastly, we also have several application that read user uploaded Excel files.  The way we did this was set up Windows datasources for these files.  In CF 5 it was treated as any other datasource and things were good.  Now, it also has the ODBC Socket driver and we can no longer connect.  Nothing we've tried can get us connected to these Excel files.  The error we get is the same as we get for the MySQL connections, above.  Any ideas?
Question by:pmascari
  • 3

Expert Comment

ID: 13836351
What version of MySQL?

Author Comment

ID: 13836721
4.0.18 Server
3.51 Connector

Author Comment

ID: 13836966
I deleted the datasources and re-entered them, this time as ODBC Connectors again rather than MySQL, and that seemed to work.  Apparently the conversion when upgrading from CF 5 simply doesn't work properly.  That leads to a new question: I'm now faced with deleting and re-entering dozens of datasources on several servers.  Is there a script that can do this or a way to back up CFAdmin settings and import them to another machine?  Same amount of points apply.
LVL 35

Accepted Solution

mrichmon earned 1500 total points
ID: 13838044
I would not recommend the import even if it were possible as it would most likely preserve the 5 settings that are causing the problem.

There is no script that I know of out there, but I have heard of people writing interfaces for this (although on a per project basis - not as something for sale).

It may take time, but the manul process will be the cleanest.

Author Comment

ID: 14070904
I have found that after entering all the datasources manually for one server, I can then simply copy CF's neo-query.xml file from one server to the next (after upgrading to CFMX7) in order to duplicate the datasources.  So, the manual entering only had to occur once.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
What You Need to Know when Searching for a Webhost Provider
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question