MySQL ODBC Connections After Upgrade to CFMX 7
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?
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?
What version of MySQL?
ASKER
4.0.18 Server
3.51 Connector
3.51 Connector
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.