MySQL ODBC Connections After Upgrade to CFMX 7
Posted on 2005-04-21
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?